Abdurahman Almatrodi
asked on
Best way to connect to SQL in WPF
Hi all
right now I am working in analyzing a multiuser project. I will use WPF with C#, and the Database will be SQL 2012. In previous project I used sql statement to connect to database. While reading I found many suggestion to use LINQ TO SQL.
Could anyone help me in this matter.
right now I am working in analyzing a multiuser project. I will use WPF with C#, and the Database will be SQL 2012. In previous project I used sql statement to connect to database. While reading I found many suggestion to use LINQ TO SQL.
Could anyone help me in this matter.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can try below sample WPF with LINQ/SQL
http://www.codeproject.com/Articles/47229/A-LINQ-Tutorial-WPF-Data-Binding-with-LINQ-to-SQL
http://www.codeproject.com/Articles/47229/A-LINQ-Tutorial-WPF-Data-Binding-with-LINQ-to-SQL
ASKER
Thanks all, but I don't need examples. I am asking about the best way.
Dear FernandoSoto
Is the EF good for multiusers environment?
Dear FernandoSoto
Is the EF good for multiusers environment?
Hi Almatrodi;
Entity Framework as well as Linq to SQL are built on top of ADO.Net and both have methods to handle conflicts. So yes Entity Framework can be used in a multiuser environment.
Entity Framework as well as Linq to SQL are built on top of ADO.Net and both have methods to handle conflicts. So yes Entity Framework can be used in a multiuser environment.
http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/cd530d4f-44b6-4c05-ac7c-bbf6061ea01d
http://www.c-sharpcorner.com/UploadFile/mahesh/data-binding-in-wpf/