• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1376
  • Last Modified:

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.
Abdurahman Almatrodi
Abdurahman Almatrodi
1 Solution
Fernando SotoRetiredCommented:
Hi Almatrodi;

I think you will find that Linq to Entity Framework will be a better technology to use over Linq to SQL. Please see this web site for some tutorials, Get Started with Entity Framework (EF).
Kalpesh ChhatralaSoftware ConsultantCommented:
Abdurahman AlmatrodiBusiness DevelopmentAuthor Commented:
Thanks all, but I don't need examples. I am asking about the best way.

Dear FernandoSoto

Is the EF good for multiusers environment?
Fernando SotoRetiredCommented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now