Hi


1.Can we make CRUD operations on SQL Server from WCF service without going for REST,LINQ and just using ADO.NET Classes.
2.Is the above practice a good one or will there be issues with that.
3.What is the best approach to connect to SQL Server for data manipulation and insertion from the WCF service.

Thank You

You can do the the CRUD by using WCF and conventional ADO by using a dataLayer(I am following it in my product). DATA LINQ has lots of draw backs and not suggested for a big application , Data link can be used only if you app is too small.

Mark as answer if it helps.

Regards,
Pramod

You can do the the CRUD by using WCF and conventional ADO by using a dataLayer(I am following it in my product). DATA LINQ has lots of draw backs and not suggested for a big application , Data link can be used only if you app is too small.

Mark as answer if it helps.

Regards,
Pramod