CODEWITHSUNDEEP
c#sqlwpf
JayJay
JayJay

Reputation: 1068

How Connect my wpf app to database online?

I developed a WPF Application for an intranet connection, connecting to a database (SQL Server) in a local server, but now my company bought a new server in abroad and so they wish to connect this application to that server.

I should create a connection between this application to a database Online (SQL Server), so I ask you which is the best way to make a connection that allows the users here to manipulate the data like in past time?

If you have a better advice let me know I will appreciate your feedback.

Upvotes: 2

Views: 2481

Answers (2)

Eugene
Eugene

Reputation: 1535

You need only to change the connection string.

Probably it would be better to wrap SQL Server by some kind of service, like WCF. It would be more secure and flexible. You could use WCF Data Services to make it really fast.

Upvotes: 2

Coding Flow
Coding Flow

Reputation: 21881

Connecting to a SQL server in a remote location is not much different to connecting to one locally, you just have to specify the appropriate host name or ip in the connection string.

However there does have to be some kind of route to the remote server, which usually requires setting up a VPN if you need to go out over the internet but that's not really a programming question.

Upvotes: 6

Related Questions