Access SQL Server with WCF example

your question is very unclear, what you want to do? are you looking for WCF service to access SQL data?

Hi,

Please try the following:
http://muxtonmumbles.blogspot.com/2011/02/plumbing-for-free-wcf-mvvm-and-wpf.html
http://www.codeproject.com/KB/WPF/WPF_MMV.aspx

Thanks

I am new to WCF/WPF. And I am looking for WCF service to access SQL data :)

In WCF you can get data in same manners as you get in normal way, please follow the link for more details:
http://www.developerfusion.com/article/4278/using-adonet-with-sql-server/4/

WCF can very well work with your SQL server, it doesn't need anything specific as such, however, you should also consider the purpose of WCF, WCF is targetted as a step towards SOA so your service should not return anything specific to SQL, the ideal thing is to return entities, you can very well make use of LINQ with WCF to make it more useful, have a look at the codeproject sample to get an idea of how you can do that - http://www.codeproject.com/KB/WCF/LinqWcfService.aspx

Hi everybody! Thank you for all your responses and usefull links!

I think I am on a wrong path in terms of architecture for my project.
My WPF application draws polygons based on point coordinates. Points are stored in SQL Server database. I need to access this database and return data to my app. I thought that I have to use WCF to do this job. I guess I don’t have to, right?
In fact I think this will only add another level of complexity to my app.

Could anybody explain me should I use WCF or not for my scenario?
What are advantages/disadvantages in this approach?
Or should I just use ADO.NET with SQL Server like IJZ recommended?  Thank you guys! :)

Hi IJZ,
I still didn't find a good simple example how to use WCF between my app and SQL Server db. I just want to read some data from table and display it in window of WPF test application. Could you help me with this? Thank you!

It's not a solution but a direction to follow. Thank you!