How to save DRY stored procedures in C # .NET?

Question

We use stored procedures for each query in the database. It seems unbelievably un <DRY:

• Create a table
• Create SP SP for this table
• Design code (preferably a class) to populate parameters and run CRUD SP

If we add one column or change the data type, we must edit the table, several SPs and several functions in the class in .NET.

What are some tips for reducing duplication?

UPDATE:

Combined with the Vinko idea, I found this . Here is some code (in C #) that I came up with for those who need it:

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MySQLConnString"].ConnectionString);
SqlCommand comm = new SqlCommand("NameOfStoredProcedure", conn);
comm.CommandType = CommandType.StoredProcedure;

conn.Open();
SqlCommandBuilder.DeriveParameters(comm);
conn.Close();

foreach (SqlParameter param in comm.Parameters)
{ /* do stuff */ }

Answer 1

, , , SP, "", .. information_schema.

, , , SP.

SP, , , (colname varchar, type varchar), SP.

, , , , , , .

Answer 2

, NetTiers, CRUD.

Answer 3

, . , SP .

, CRUD, . . , , , , , .

, , SP .NET.

, , . .

Answer 4

, SQL . . ...

Answer 5

. , .

crud:

• , procs .
• # procs.

:

• ()
• , .
• , - , ( , )

, , , , , , , - , proc , .

, SQL Injection, , .... ... ?; -)

Answer 6

"DeriveParameters" , 2 . . Microsoft Access Access SqlHelper , "", . SP- "goo" ..

http://msdn.microsoft.com/en-us/library/cc309504.aspx

Answer 7

, DRY. , № 3 , , . LINQ to SQL - , .

# 2 . , : 1) ( ); 2) ( ); 3) .

Answer 8

, CRUD . , " ", .