public override void Execute() { JDatabaseResolver.Resolve <SqlConnection>() .DbExecutor(db => { Result = db.Delete(_removeObj) > 0; }); }
public override void Execute() { #if __SQLKATA__ #if __MYSQLKATA__ JDatabaseResolver.Resolve <MySqlConnection>() .DbExecuteKata((db, query) => { var todo = query.Query("TODO").Where("ID", Request).First <TODO>(); if (todo.xIsNotEmpty()) { Result = query.Query("TODO").Where("ID", todo.ID).Delete() > 0; } }); #else JDatabaseResolver.Resolve <SqlConnection>() .DbExecuteKata(db => { var todo = db.Query("TODO").Where("ID", Request).First <TODO>(); if (todo.xIsNotEmpty()) { Result = db.Query("TODO").Where("ID", todo.ID).Delete() > 0; } }); #endif #else JDatabaseResolver.Resolve <SqlConnection>() .DbExecute((db, tran) => { var exists = db.Query <TODO>(m => m.ID == this.Request).First(); if (exists.xIsNotNull()) { this.Result = db.Delete <TODO>(exists) > 0; } }); #endif }
public override void Execute() { JDatabaseResolver.Resolve <SqlConnection>() .DbExecuteKata((db, q) => { this.Result = q.Query("USER").Where("USER_ID", this.Request).FirstOrDefault <USER>(); }); }
public override void Execute() { #if __SQLKATA__ #if __MYSQLKATA__ JDatabaseResolver.Resolve <MySqlConnection>() .DbExecuteKata((db, query) => { this.Result = query.Query("TODO") .WhereStarts("TODO_TEXT", this.Request.xSafe(), true)//WHERE TODO_TEXT LIKE '[TEXT]%' .Get <TODO>(); }); #else JDatabaseResolver.Resolve <SqlConnection>() .DbExecuteKata((db, query) => { this.Result = db.Query("TODO") .WhereStarts("TODO_TEXT", this.Request.xValue(), true)//WHERE TODO_TEXT LIKE '[TEXT]%' .Get <TODO>(); }); #endif #else //redb db JDatabaseResolver.Resolve <SqlConnection>() .DbExecute((db, tran) => { this.Result = db.QueryAll <TODO>().Where(m => m.TODO_TEXT.Contains(Request)).ToList(); //Result = db.GetList<TODO>($"WHERE TODO_TEXT LIKE '%{Request}%'"); }); #endif }
public override void Execute() { JDatabaseResolver.Resolve <SqlConnection>() .BeginTran() .DbExecuteKata((db, q) => { this.Result = q.Query("USER").Where("ID", this.Request).Delete() > 0; }); }
public override async Task ExecuteAsync() { var sql = string.Empty; await JDatabaseResolver.Resolve <SqlConnection>() .DbExecutorAsync(async con => { await InitDatabaseAsync(con); await InitTableAsync(con); var r = await IsExistsTableAsync(con); Result = r > 0; }); }
public override void Execute() { var sql = string.Empty; JDatabaseResolver.Resolve <SqlConnection>() .DbExecutor(con => { InitDatabase(con); InitTable(con); Result = IsExistsTable(con); }); }
public override void Execute() { JDatabaseResolver.Resolve <SqlConnection>() .DbExecutor(db => { if (_exists.xIsNotNull()) { Result = db.Update(Request); } Result = db.Insert(Request).Value; }); }
public override void Execute() { JDatabaseResolver.Resolve <SqlConnection>() .DbExecutor(con => { var compiler = new SqlServerCompiler(); var db = new QueryFactory(con, compiler); var weathers = db.Query("dbo.WEATHER_FORECAST").Get <WEATHER_FORECAST>(); weathers.xForEach(item => { item.TEMPERATURE_F = 32 + (int)(item.TEMPERATURE_C / 0.5556); }); Result = weathers; }); }
public override void Execute() { JDatabaseResolver.Resolve <SqlConnection>() .BeginTran() .DbExecuteKata((db, q) => { if (_exists.xIsNotNull()) { this.Result = q.Query("USER").Where("ID", this.Request.USER_ID) .Update(this.Request.xToDictionary()); } this.Result = q.Query("TODO").InsertGetId <int>(this.Request.xToDictionary()); }); }
public override void Execute() { //use sqlkata var query = new Query("WEATHER_FORECAST").Where("ID", Request.ID).Select("*"); JDatabaseResolver.Resolve <SqlConnection>() .DbExecutor(con => { var compiler = new SqlServerCompiler(); var db = new QueryFactory(con, compiler); var weather = db.Query("dbo.WEATHER_FORECAST").Where("ID", Request.ID) .FirstOrDefault <WEATHER_FORECAST>(); weather.TEMPERATURE_F = 32 + (int)(weather.TEMPERATURE_C / 0.5556); Result = weather; }); }
public override void Execute() { JDatabaseResolver.Resolve <SqlConnection>() .DbExecuteKata((db, q) => { var query = q.Query("USER"); if (this.Request.USER_ID.xIsNotNullOrEmpty()) { query = query.WhereLike("USER_ID", this.Request.USER_ID); } if (this.Request.USER_NM.xIsNotNullOrEmpty()) { query = query.WhereLike("USER_NM", this.Request.USER_NM); } this.Result = query.Get <USER>(); }); }
public override void Execute() { this.Result = new List <TODO>(); var sql = "SELECT * FROM TODO"; JDatabaseResolver.Resolve <SqlConnection>() .BeginTran() .DbExecute((c, t) => { this.Result.AddRange(c.ExecuteQuery <TODO>(sql, transaction: t)); JDatabaseResolver.Resolve <MySqlConnection>() .BeginTran() .DbExecute((c1, t1) => { this.Result.AddRange(c1.ExecuteQuery <TODO>(sql, transaction: t1)); }); }); }
public override void Execute() { #if __SQLKATA__ #if __MYSQLKATA__ JDatabaseResolver.Resolve <MySqlConnection>() .DbExecuteKata((db, query) => { this.Result = query.Query("TODO").Where("ID", Request).FirstOrDefault <TODO>(); }); #else JDatabaseResolver.Resolve <SqlConnection>() .DbExecuteKata(db => { this.Result = db.Query("TODO").Where("ID", Request).FirstOrDefault <TODO>(); }); #endif #else JDatabaseResolver.Resolve <SqlConnection>() .DbExecute((db, tran) => { this.Result = db.Query <TODO>(m => m.ID == this.Request).First(); }); #endif }
public override void Execute() { #if __SQLKATA__ #if __MYSQLKATA__ JDatabaseResolver.Resolve <MySqlConnection>() .DbExecuteKata((db, query) => { if (_exists.xIsNotNull()) { var effectedRow = query.Query("TODO").Where("ID", _exists.ID).Delete(); if (effectedRow > 0) { this.Result = query.Query("TODO").InsertGetId <int>(new { TODO_TEXT = this.Request.TODO_TEXT, W_DATE = DateTime.Now, M_DATE = DateTime.Now }); } } else { this.Result = query.Query("TODO").InsertGetId <int>(new { TODO_TEXT = this.Request.TODO_TEXT, W_DATE = DateTime.Now, M_DATE = DateTime.Now }); } }); #else JDatabaseResolver.Resolve <SqlConnection>() .DbExecuteKata(db => { if (_exists.xIsNotNull()) { var effectedRow = db.Query("TODO").Where("ID", _exists.ID).Delete(); if (effectedRow > 0) { this.Result = db.Query("TODO").InsertGetId <int>(new { TODO_TEXT = this.Request.TODO_TEXT, W_DATE = DateTime.Now, M_DATE = DateTime.Now }); } } else { this.Result = db.Query("TODO").InsertGetId <int>(new { TODO_TEXT = this.Request.TODO_TEXT, W_DATE = DateTime.Now, M_DATE = DateTime.Now }); } }); #endif #else JDatabaseResolver.Resolve <SqlConnection>() .DbExecute((db, tran) => { if (_exists.xIsNotNull()) { if (db.Delete(_exists) > 0) { Result = db.Insert <TODO, int>(Request); } } else { Result = db.Insert <TODO, int>(Request); } }); #endif }