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