Ask a questionAsk a question
 

AnswerSupport for SQL 2005

  • Tuesday, November 03, 2009 5:17 PMMSDN Student Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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

  • Tuesday, November 03, 2009 8:27 PMPeter Qian - MSFTAnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    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 SP1

    Regards,
    PQ

    Peter Q. http://blogs.msdn.com/peter_qian

All Replies

  • Tuesday, November 03, 2009 8:27 PMPeter Qian - MSFTAnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    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 SP1

    Regards,
    PQ

    Peter Q. http://blogs.msdn.com/peter_qian