Modify asp.net web site classes based on SQL Table definition
Posted on 2013-01-22
Hello EE, big question for you.
I have a web site in my company in .NET with C#.
the site is architectured with BLL, DAL, SqlClient classes and so forth.
Not all employees knows .NET and let's say we add a column to a SQL table, let's say table A, well we need to go change at at least 2-3 places like the class Customer (that has get set Properties, the sqlClient parameters for the update and insert statements, the CustomerDetails DataReader ...
Is there a way to create/recreate the customer.cs (get set properties) based on the SQL table definition ? That way no one would need to get modify it would help me so much.
same thing for the other classes... any ideas on that ?
I know there is a limit to do nothing...I dont mind to do changes if I want to lets say add a asp:Label from the new column thats ok to go manually add it in the Web Form page...