[Discussion] - Best class to CRUED

Question

Hey guys I'm new in C# programing which means I'm still learning it. Now i'm looking for best class which i can use for basic CRUED operations ( Insert Update Delete ) on MS SQL server. If you have some class you use i would love to see how you make it. For now as best solution i have so far is from this link https://dotnetdaily.net/web-development/tutorials/ado-net-tutorial-create-update-delete-operations Is it a good habbit to use property for each table field ?? Or it would be better to pass those values through parameters collections . ? Anyway i would love to see classes you use as example. Thanks in advance

Vighnesh Gadekar · Answer

Hi Anel I visited that site you provided above CRUD operations are explained very well over there but they did it in simple way using stored procedure is the best practices while doing stuff with database as stored procedure is precompiled queries so time required for execution is less as compared to normal execution time. refer this site for learning CRUD operation using stored procedure. https://www.codeproject.com/Articles/438259/Insert-Update-Search-and-Delete-CRUD-operation-usi Hope this will help.

Nitin Sontakke · Answer

Another problem with the article is there is no data access layer which should be there. You don't keep on opening connection and execute queries. This should all be encapulated in yet another class called DataAccess.cs. This class have methods like ExecuteScalar ExecuteReader ExecuteNonQuery etc. This class will encapsulate opening connection etc.

Nitin Sontakke · Answer

I think everything is fine with the link you have provided except one major thing - no stored procedures are used which is not quite good. From sql injection performance abstraction reusability point of view it is highly recommended that you use stored procedures. One down side of stored procedures is binding (commitment) to a specific vendor / database system. You should definitely have property for every field but this just a guideline not hard and fast rule. Apply logic and decide. Any more question(s) please do let us know.