private string GetInsertSql<T>(T dto, string tableOwnerSchema)
{
string sqlTemplate = @"INSERT INTO [{0}].[{1}] ({2}) values ({3});";
string columnName = string.Empty;
string columnVal = string.Empty;
var propList = typeof(T).GetProperties();
foreach (PropertyInfo prop in propList)
{
if (prop.Name != "columnNameA" && prop.Name != "columnNameB")
{
columnName += "[" + prop.Name + "],";
columnVal += "@" + prop.Name + ",";
}
}
columnVal.Remove(columnVal.Length - 1, 1);//del ,
return string.Format(sqlTemplate, tableOwnerSchema, typeof(T)
{
string sqlTemplate = @"INSERT INTO [{0}].[{1}] ({2}) values ({3});";
string columnName = string.Empty;
string columnVal = string.Empty;
var propList = typeof(T).GetProperties();
foreach (PropertyInfo prop in propList)
{
if (prop.Name != "columnNameA" && prop.Name != "columnNameB")
{
columnName += "[" + prop.Name + "],";
columnVal += "@" + prop.Name + ",";
}
}
columnVal.Remove(columnVal.Length - 1, 1);//del ,
return string.Format(sqlTemplate, tableOwnerSchema, typeof(T)