private void Update(DbContext context, bool skipSelect) { var returned = PrepareUpdateSql(skipSelect); var sql = SqlText.ToString(); ExecSqlAndUpdateBack(sql, context, Entity, returned, ParameterValues.ToArray()); }
private async Task UpdateAsync(DbContext context, bool skipSelect) { var returned = PrepareUpdateSql(skipSelect); var sql = SqlText.ToString(); await ExecSqlAndUpdateBackAsync(sql, context, Entity, returned, ParameterValues.ToArray()); }
private void Update(DbContext context) { // _sb.AppendLine("SET NOCOUNT ON;"); PrepareUpdateSql(); var sql = SqlText.ToString(); var tmp = context.Database.ExecuteSqlCommand(sql, ParameterValues.ToArray()); }
public int GetTotalNumberByFilter(ISearchViewModel searchViewModel) { var sqlString = GenerateSqlStringByFilter(searchViewModel, true); // get total number try { var totalNum = DbManager.SqlQuery <int>(sqlString, ParameterValues.ToArray()).First(); return(totalNum); } catch (Exception e) { Console.WriteLine(e); return(0); } }
private void Insert(DbContext context, bool skipSelect) { _parameters = new string[SqlColumns.Count]; // var ts = DateTime.UtcNow; SqlText.AppendLine("SET NOCOUNT ON;"); PrepareInsertSql(); var returned = PrepareSelectSql(skipSelect); ExecSqlAndUpdateBack(SqlText.ToString(), context, Entity, returned, ParameterValues.ToArray()); //Debug.WriteLine(" sql elapsed " + (DateTime.UtcNow - ts).TotalMilliseconds); /* * * string sql = @"SET NOCOUNT ON; * INSERT INTO [RecipeNodes] ([ArticleId], [EnrichedArticleId], [IsActive], [IsDefault], [MigrationSourceId], [Name]) * VALUES (@p0, @p1, @p2, @p3, @p4, @p5); * SELECT [Id] * FROM [RecipeNodes] * WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();"; */ }
private void Insert(DbContext context) { _parameters = new string[SqlColumns.Length]; // var ts = DateTime.UtcNow; SqlText.AppendLine("SET NOCOUNT ON;"); PrepareInsertSql(); var returned = PrepareSelectSql(); if (returned != null) { using (var reader = context.Database.ExecuteReader(SqlText.ToString(), ParameterValues.ToArray())) { while (reader.DbDataReader.Read()) { var v = new object[reader.DbDataReader.FieldCount]; reader.DbDataReader.GetValues(v); for (var index = 0; index < returned.Count; index++) { returned[index].ValueWriter.WritePropertyValue(Entity, v[index]); } break; } } } else { var tmp = context.Database.ExecuteSqlCommand(SqlText.ToString(), ParameterValues.ToArray()); } //Debug.WriteLine(" sql elapsed " + (DateTime.UtcNow - ts).TotalMilliseconds); /* * * string sql = @"SET NOCOUNT ON; * INSERT INTO [RecipeNodes] ([ArticleId], [EnrichedArticleId], [IsActive], [IsDefault], [MigrationSourceId], [Name]) * VALUES (@p0, @p1, @p2, @p3, @p4, @p5); * SELECT [Id] * FROM [RecipeNodes] * WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();"; */ }
protected override IEnumerable <ISearchResultModel> GetResultIsLatestBySqlQuery(string sqlString) { return(DbManager.SqlQuery <SearchResultIsLatest>(sqlString, ParameterValues.ToArray()).ToList()); }
///<summary> ///Executes a stored procedure and returns the result as a DataTable. ///</summary> public static DataTable Execute(string ConnectionName, string Procedure, params object[] ParameterValues) { PSOQuery Q = new PSOQuery(ConnectionName, Procedure, ParameterValues.ToArray()); return(Execute(Q)); }
private void Delete(DbContext context, IReadOnlyDictionary <string, object> keys) { PrepareUpdateSql(keys); var sql = SqlText.ToString(); var tmp = context.Database.ExecuteSqlCommand(sql, ParameterValues.ToArray()); }