[Discussion] - Best class to CRUED

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.

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.

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.