database web service visual studio 2010

Question

can someone tell me usefull tutorials that explain how to create web services in visual studio in c#? What im trying to do is a webservice that access to database and allows to make crud operations in a table on a SQLServer database. What i need is a tutorial that explains how to create a database in SQL ce and SQL Express Edition and how to create a database web service in visual studio 2010 in c#.

thanks

Answer 1

Here's an article to get you started: A First Step in a Simple WCF Web Service...

• Sounds like you want a SQL CE 4 database. Here's a high level view using SQL CE Embedded Database in your ASP.NET project.

• Or.... wait, did you want it a SQL Server database? How To Create a SQL Server Database. Express is just a SKU meaning 'free' and 'has certain limitations'.

• The WCF article uses Entity Framework. Choose the data access you like (LINQ To SQL, plain ADO.NET, SubSonic, whatever)