When we are writing modules for a big project we might find difficult to write the basic class file with stored procedure for function like Insert, Update, Delete and Select. But Imagine how use full that, you are passing the "TABLE NAME", "CLASS NAME", "NAMESPACE" to a SQL script file, That will Generate the entire class file(in c#) with Stored procedure for that.

Their are some basic rules.

• Table should HAVE primary kwy which is int, auto increment by 1

I had used some common Columns for all tables link

• CREATED_BY int
• CREATED_ON datetime (Default value "GETDATE()")
• UPDATED_BY int
• UPDATED_ON datetime (Default value "GETDATE()")
• ISDELETED bit (Default value "0")
• STATUS bit (Default valus "1")