public static IStatementInsert Columns(this IStatementInsert q, Func <IColumnsListSimple, IColumnsListSimple> f)
{
f.Invoke(q.Columns);
return(q);
}
public static IStatementInsert Values(this IStatementInsert q, params string[] values)
{
q.Values.Append(values);
return(q);
}
public static IStatementInsert Values(this IStatementInsert q, Func <ValueList, ValueList> f)
{
f.Invoke(q.Values);
return(q);
}
public static IStatementInsert Columns(this IStatementInsert q, params string[] columns)
{
q.Columns.Append(columns);
return(q);
}
public static string GetSQLInsertForDapperInt(IStatementInsert sql) =>
sql.GetSql() + Environment.NewLine + $"SELECT * FROM {sql.TableName} WHERE id=LAST_INSERT_ID();";
public static string GetSQLInsertForDapperGuid(IStatementInsert sql) =>
"SET @uuid = UUID();" + Environment.NewLine + sql.GetSql() + Environment.NewLine + $"SELECT * FROM {sql.TableName} WHERE id=@uuid;";
