Geek asks and answers

Looking to create a client application (WPF) for CRUD operations with remote data

I am handed an application development project in which I am completely excited. The problem is that I'm not quite sure how to implement one specific requirement.

The application must be a client application (therefore, I use WPF to develop it) and must perform CRUD operations on the remote server (so that others can also access this data). The main difficulty that I'm stuck with is that this client application will not only be launched from a certain network, but one of the main users will use it from home as well. I am not sure how to safely provide data on the Internet.

I originally developed the application using only LINQ 2 SQL, and imagined that I was just forwarding the ports to a dedicated SQL Server computer, but that was probably a terrible idea. While doing some research, it seems like I should use WCF to create a service and then run it on a machine, and use WPF client applications instead.

This seems like a bit of extra work here, especially since I am using this project to learn WPF. I did not even look at WCF. Do I have another alternative? Is my original concept just exposing SQL Server on the Internet really so bad?

Thank!

+3
source share
4 answers

SQL Server ?

. , ( , ).

WCF, , , WPF.

, - . , .

+1

-, , ... ( ).

. , , VPN. , SQL Server , .

, WCF Linq-to-SQL . , . Linq-to-SQL WCF. , , - CRUD - Load, Find, InsertOrUpdate Save.

+1

, , ...

: SQL Server - . VPN , SQL.

MVVM. WPF WPF . , , WCF .

0

why not use WCF data services - http://msdn.microsoft.com/en-us/library/cc668772(v=vs.103).aspx . If you need this to be safe, check out http://msdn.microsoft.com/en-us/library/dd728284.aspx

0
source

More articles:


All Articles