Click here to Skip to main content
12,952,603 members (39,873 online)
Rate this:
Please Sign up or sign in to vote.
hi experts

one sql server in local
one application has been uploaded to internet.

the application must use sql server. i got a static ip but i coudn't set web config and connection string. yes i searched google and i did several solutions.

the application or solution has many projects like data access, business and

data access works with entityframework4 that is connected to a local sql server 2008 in my computer.

the questions are:
1. can i add web service between database and data access?
2. if yes, will i have to change all data access code?
3. can enity framework update its model from web service instead of sql server directly? (it's database first)
4. will you guid me how i can get ride of this problem?

thanks for any help
Posted 15-May-12 3:14am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You might check out this article:

Implementing a WCF Service with Entity Framework[^]
Vartan Khachatourian 18-May-12 12:41pm
thank you but 1. I didn't asked about wcf i said "web service" i now wcf is for web service too but my question is more general and i don't want to use wcf because i don't know it. 2. my questions are distinguished and i need their answers here, not a link to an artcile that doesn't contain my answers.
Clifford Nelson 19-May-12 0:12am
In the newer frameworks it is recommended that WCF be used for Web Services. It is not that hard to set up a basic Web Service in WCF. Then if you need to enhance with security, or whatever, you will find it is much easier. WCF has been available for 4 years, almost half the lifetime of .NET. Time to move up to WCF. To see a very basic example look at

Hope this helps somewhat.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,289
CHill60 3,490
Maciej Los 3,103
Jochen Arndt 1,975
ppolymorphe 1,900

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 16 May 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100