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;";