CODEWITHSUNDEEP
c#sqlasp.netweb-applicationslinq-to-sql
Salivan
Salivan

Reputation: 1903

Best practise for SQL in .NET project

I'm a very beginner in .NET and now I'm developing a little project (web API) using NancyFX framework. In my project, I need to use SQL database for some very basic tasks like storing registered users' details or getting some user information. I'd like to know what is the most popular, convenient and modern way of using SQL in .NET for beginners? I mean, should I use LINQ or just pure SQLClient functionality or are there any good libraries for working with SQL on .NET? I've tried to implement LINQ to SQL pattern but ended up with huge chunks of unused auto generated code and even bigger mess in my head...

Upvotes: 1

Views: 180

Answers (1)

Ran Sasportas
Ran Sasportas

Reputation: 2266

For a framework to communicate with you're database I would recommend using Entity framework, its very convenient and easy and has the Code first approach which you should read about. More over i suggest you follow the repository pattern,

https://msdn.microsoft.com/en-us/library/ff649690.aspx

This basically means - each object you save in the db, will have a repository which will contain all the object of its kind and that will be you're entry point to reading/inserting/updatibg/and deleting rows from the db, while abstracting away all details of implementation - in our case I recommend entity framework as I mentioned before.

Good luck

Upvotes: 4

Related Questions