private static string BuildSql(this IDbConfig dbConfig) { var sql = dbConfig.CreateSqlBuilder().Delete <Person>() .OnSchema() .Where(x => x.WP(item => item.Id)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig) { var sql = dbConfig.CreateSqlBuilder().Delete <EventContract>() .OnTable(Tables.EventTable) .OnSchema() .Where(x => x.WP(item => item.Id)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig) { var sql = dbConfig.CreateSqlBuilder().Insert <EventContract>() .OnTable(Tables.EventTable) .OnSchema() .Fields(x => x.FP(item => item.Id)) .Fields(x => x.FP(item => item.Event)) .Fields(x => x.FP(item => item.Stop)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig) { var sql = dbConfig.CreateSqlBuilder().Update <Person>() .OnSchema() .Fields(x => x.FP(item => item.Alive)) .Fields(x => x.FP(item => item.Username)) .Fields(x => x.FP(item => item.Password)) .Where(x => x.WP(item => item.Id)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig, out DynamicParameters @params) { @params = new DynamicParameters(); @params.Add(nameof(Person.Alive), dbConfig.CreateParameterResolver().WithBooleanParameterValue(true)); var sql = dbConfig.CreateSqlBuilder().Select() .OnSchema() .Count() .Fields <Person>(x => x.F(item => item.Id)) .Where <Person>(x => x.WP(item => item.Alive)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig) { var sql = dbConfig.CreateSqlBuilder().Select() .OnSchema() .Fields <Person>(x => x.F(item => item.Id)) .Fields <Person>(x => x.F(item => item.SequenceNumber)) .Fields <Person>(x => x.F(item => item.Alive)) .Fields <Person>(x => x.F(item => item.Username)) .Fields <Person>(x => x.F(item => item.Password)) .Where <Person>(x => x.WP(item => item.Id)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig) { var parameterResolver = dbConfig.CreateParameterResolver(); var sql = dbConfig.CreateSqlBuilder().Insert <Person>() .OnSchema() .Fields(x => x.FP(item => item.Id)) .Fields(x => x.FV(item => item.SequenceNumber, parameterResolver.WithNextTableSequence <Person>(), ignoreFormat: true)) .Fields(x => x.FP(item => item.Alive)) .Fields(x => x.FP(item => item.Username)) .Fields(x => x.FP(item => item.Password)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig, Guid[] ids, out DynamicParameters @params) { @params = new DynamicParameters(); var inSelections = dbConfig.CreateParameterResolver().AddArrayParameter(@params, Columns.Id, ids); var sql = dbConfig.CreateSqlBuilder().Select() .OnSchema() .From <EventContract>(Tables.EventTable) .Fields <EventContract>(x => x.F(item => item.Id)) .Fields <EventContract>(x => x.F(item => item.Event)) .Fields <EventContract>(x => x.F(item => item.Stop)) .Where <EventContract>(x => x.WP(item => item.Id, inSelections)) .Build(); return(sql); }
private static string BuildSql(this IDbConfig dbConfig, Guid[] ids, out DynamicParameters @params) { @params = new DynamicParameters(); var inSelections = dbConfig.CreateParameterResolver().AddArrayParameter(@params, nameof(Person.Id), ids); var sql = dbConfig.CreateSqlBuilder().Select() .OnSchema() .Fields <Person>(x => x.F(item => item.Id)) .Fields <Person>(x => x.F(item => item.SequenceNumber)) .Fields <Person>(x => x.F(item => item.Alive)) .Fields <Person>(x => x.F(item => item.Username)) .Fields <Person>(x => x.F(item => item.Password)) .Where <Person>(x => x.WP(item => item.Id, inSelections)) .Build(); return(sql); }