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()); }