public static SqlCommand Create(Type type, params string[] columnValue) { string[] columns = new string[columnValue.Length / 2]; string[] values = new string[columnValue.Length / 2]; int j = 0; for (int i = 0; i < columnValue.Length; i = i + 2) { columns[j] = columnValue[i]; if (columnValue[i + 1] == null) { values[j] = ""; } else { values[j] = columnValue[i + 1]; } j++; } SqlCommand result = new SqlCommand(); result.CommandText = CreateCommandText(columns, type); CommonCommandMaker <T> .AddParameters(columns, values, result); return(result); }
public static SqlCommand Create(T obj) { SqlCommand result = new SqlCommand(); result.CommandText = CreateCommandText(obj); CommonCommandMaker <T> .AddParameters(obj, result); return(result); }