Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
hi experts
 
one sql server in local
one asp.net 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 asp.net
 
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 4:14am

1 solution

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

Solution 1

You might check out this article:
 
Implementing a WCF Service with Entity Framework[^]
  Permalink  
Comments
Vartan Khachatourian at 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 at 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 http://www.codeproject.com/Articles/97204/Implementing-a-Basic-Hello-World-WCF-Service
 
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
0 Sergey Alexandrovich Kryukov 380
1 OriginalGriff 230
2 DamithSL 220
3 Zoltán Zörgő 150
4 Maciej Los 135
0 OriginalGriff 7,740
1 DamithSL 5,694
2 Sergey Alexandrovich Kryukov 5,404
3 Maciej Los 5,061
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 16 May 2012
Copyright © CodeProject, 1999-2014
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