public static string MakeParams(this TableInfo table)
{
string columnParams = string.Empty;
string commaPcs = string.Empty;
foreach (TableColumn pcs in table.Columns)
{
columnParams += string.Format("{2}{0} {1}",
InfoSchema.ParseType(pcs.DataType), pcs.Name.WithFirstCharLower() + table.ColumnParamsSuffix, commaPcs);
commaPcs = ",";
}
return(columnParams);
}
public static string MakeParamsNoIdentity(this TableInfo table)
{
string columnParams = string.Empty;
string commaPcs = string.Empty;
foreach (TableColumn column in table.Columns)
{
if (table.HasIdentityPK && table.IsColumnInPrimaryKeys(column))
{
continue;
}
columnParams += string.Format("{2}{0} {1}",
InfoSchema.ParseType(column.DataType), column.Name.WithFirstCharLower() + table.ColumnParamsSuffix, commaPcs);
commaPcs = ",";
}
return(columnParams);
}