private static string CreateCommandText(string [] columns, Type type)
{
StringBuilder commandText = new StringBuilder();
var tableName = '\"' + type.Name + '\"';
var where = CommonCommandMaker <T> .WhereConditionCreate(columns);
commandText.Append($"SELECT * FROM {tableName} {where}");
return(commandText.ToString());
}
private static string CreateCommandText(T obj)
{
StringBuilder commandText = new StringBuilder();
var tableName = '\"' + obj.GetType().Name + '\"';
var columns = CreateValuesString(obj);
string[] columnValues = { "Id" };
var where = CommonCommandMaker <T> .WhereConditionCreate(columnValues);
commandText.Append($"UPDATE {tableName} SET {columns} {where}");
return(commandText.ToString());
}