Data Platform Developer Center >
Data Platform Development Forums
>
WCF Data Services (formerly known as ADO.NET Data Services)
>
Support for SQL 2005
Support for SQL 2005
- I am writing a small product for the banking industry. The product will be sold to customers who would be running SQL 2005 or SQL 2008.
I need to expose some of my database objects (tables / views / stored procedures) as web services.
I am ready to baseline .NET framework 3.5 to run the web services... but the database can be either SQL 2005 or 2008.
Can you please confirm if I can use ADO.NET Data Services? or will I have to write web services manually?
Regards,
Abhishek
Answers
- Hi Abhishek,We do support SQL 2005/08 via entity framework provider. The process is rather easy: generate the edm from the database and then use the EF data context as the generic parameter of the data service class.However, you might need to make sure your target environment's .net framework has our dlls. I think the minimum requirement is .net 3.5 SP1Regards,PQ
Peter Q. http://blogs.msdn.com/peter_qian- Marked As Answer byPratik Patel - MSFTModeratorWednesday, November 04, 2009 12:01 AM
All Replies
- Hi Abhishek,We do support SQL 2005/08 via entity framework provider. The process is rather easy: generate the edm from the database and then use the EF data context as the generic parameter of the data service class.However, you might need to make sure your target environment's .net framework has our dlls. I think the minimum requirement is .net 3.5 SP1Regards,PQ
Peter Q. http://blogs.msdn.com/peter_qian- Marked As Answer byPratik Patel - MSFTModeratorWednesday, November 04, 2009 12:01 AM
