public int ExecuteNonQuery(ActionContext context) { ITable table = null; Expression expr = DbCommandActionHelper.GetEnumeratorExpression(this.commandTree.Predicate, this.commandTree, context.DbContainer, out table); IQueryable entitiesToDelete = DatabaseReflectionHelper.CreateTableQuery(expr, context.DbContainer.Internal); return(DatabaseReflectionHelper.DeleteEntities(entitiesToDelete, context.Transaction)); }
public int ExecuteNonQuery(ActionContext context) { ITable table = null; Expression expr = DbCommandActionHelper.GetEnumeratorExpression(this.commandTree.Predicate, this.commandTree, context.DbContainer, out table); IQueryable entitiesToUpdate = DatabaseReflectionHelper.CreateTableQuery(expr, context.DbContainer.Internal); Type type = TypeHelper.GetElementType(table.GetType()); // Collect the SetClause DbExpressions into a dictionary IDictionary <string, DbExpression> setClauses = DbCommandActionHelper.GetSetClauseExpressions(this.commandTree.SetClauses); // Collection for collection member bindings IList <MemberBinding> memberBindings = new List <MemberBinding>(); TransformVisitor transform = new TransformVisitor(context.DbContainer.TypeConverter); // Setup context for the predicate ParameterExpression param = Expression.Parameter(type, "context"); using (transform.CreateVariable(param, this.commandTree.Target.VariableName)) { // Initialize member bindings foreach (PropertyInfo property in type.GetProperties()) { Expression setter = null; // Check if member has set clause if (setClauses.ContainsKey(property.Name)) { setter = transform.Visit(setClauses[property.Name]); } // If setter was found, insert it if (setter != null) { // Type correction setter = ExpressionHelper.CorrectType(setter, property.PropertyType); memberBindings.Add(Expression.Bind(property, setter)); } } } Expression updater = Expression.Lambda( Expression.MemberInit(Expression.New(type), memberBindings), param); return(DatabaseReflectionHelper.UpdateEntities(entitiesToUpdate, updater, context.Transaction).Count()); }
public DbDataReader ExecuteDataReader(ActionContext context) { // Find returning fields FieldDescription[] returningFields = DbCommandActionHelper.GetReturningFields(this.commandTree.Returning); List <IDictionary <string, object> > returningValues = new List <IDictionary <string, object> >(); // Find NMemory table ITable table = DbCommandActionHelper.GetTable(this.commandTree, context.DbContainer); // Collect the SetClause DbExpressions into a dictionary IDictionary <string, DbExpression> setClauses = DbCommandActionHelper.GetSetClauseExpressions(this.commandTree.SetClauses); // Collection for collection member bindings IList <MemberBinding> memberBindings = new List <MemberBinding>(); TransformVisitor transform = new TransformVisitor(context.DbContainer.TypeConverter); // Initialize member bindings foreach (PropertyInfo property in table.EntityType.GetProperties()) { Expression setter = null; // Check if member has set clause if (setClauses.ContainsKey(property.Name)) { setter = transform.Visit(setClauses[property.Name]); } // If setter was found, insert it if (setter != null) { // Type correction setter = ExpressionHelper.CorrectType(setter, property.PropertyType); // Register binding memberBindings.Add(Expression.Bind(property, setter)); } } object entity = CreateAndInsertEntity(table, memberBindings, context.Transaction); Dictionary <string, object> entityReturningValues = DbCommandActionHelper.CreateReturningEntity(context, returningFields, entity); returningValues.Add(entityReturningValues); return(new EffortDataReader( returningValues.ToArray(), 1, returningFields, context.DbContainer)); }
public DbDataReader ExecuteDataReader(ActionContext context) { TransformVisitor visitor = new TransformVisitor(context.DbContainer.TypeConverter); visitor.TableProvider = context.DbContainer; // Transform command tree Expression queryExpression = visitor.Visit(this.commandTree.Query); LambdaExpression query = Expression.Lambda(queryExpression, Expression.Parameter(typeof(IDatabase))); // Create a stored procedure from the expression ISharedStoredProcedure procedure = DatabaseReflectionHelper.CreateSharedStoredProcedure(query); // Format the parameter values IDictionary <string, object> parameters = DbCommandActionHelper.FormatParameters( context.Parameters, procedure.Parameters, context.DbContainer.TypeConverter); IEnumerable result = null; if (context.Transaction != null) { result = procedure.Execute( context.DbContainer.Internal, parameters, context.Transaction); } else { result = procedure.Execute( context.DbContainer.Internal, parameters); } List <FieldDescription> fields = GetReturningFields(this.commandTree); return(new EffortDataReader( result, -1, fields.ToArray(), context.DbContainer)); }
public int ExecuteNonQuery(ActionContext context) { // Get the source table ITable table = DbCommandActionHelper.GetTable(this.commandTree, context.DbContainer); // Collect the SetClause DbExpressions into a dictionary IDictionary <string, DbExpression> setClauses = DbCommandActionHelper.GetSetClauseExpressions(this.commandTree.SetClauses); // Collection for collection member bindings IList <MemberBinding> memberBindings = new List <MemberBinding>(); TransformVisitor transform = new TransformVisitor(context.DbContainer.TypeConverter); // Initialize member bindings foreach (PropertyInfo property in table.EntityType.GetProperties()) { Expression setter = null; // Check if member has set clause if (setClauses.ContainsKey(property.Name)) { setter = transform.Visit(setClauses[property.Name]); } // If setter was found, insert it if (setter != null) { // Type correction setter = ExpressionHelper.CorrectType(setter, property.PropertyType); // Register binding memberBindings.Add(Expression.Bind(property, setter)); } } CreateAndInsertEntity(table, memberBindings, context.Transaction); return(1); }
public DbDataReader ExecuteDataReader(ActionContext context) { FieldDescription[] returningFields = DbCommandActionHelper.GetReturningFields(this.commandTree.Returning); IList <IDictionary <string, object> > returningEntities = new List <IDictionary <string, object> >(); ITable table = null; Expression expr = DbCommandActionHelper.GetEnumeratorExpression(this.commandTree.Predicate, this.commandTree, context.DbContainer, out table); IQueryable entitiesToUpdate = DatabaseReflectionHelper.CreateTableQuery(expr, context.DbContainer.Internal); Type type = TypeHelper.GetElementType(table.GetType()); // Collect the SetClause DbExpressions into a dictionary IDictionary <string, DbExpression> setClauses = DbCommandActionHelper.GetSetClauseExpressions(this.commandTree.SetClauses); // Collection for collection member bindings IList <MemberBinding> memberBindings = new List <MemberBinding>(); TransformVisitor transform = new TransformVisitor(context.DbContainer); // Setup context for the predicate ParameterExpression param = Expression.Parameter(type, "context"); using (transform.CreateVariable(param, this.commandTree.Target.VariableName)) { // Initialize member bindings foreach (PropertyInfo property in type.GetProperties()) { Expression setter = null; // Check if member has set clause if (setClauses.ContainsKey(property.Name)) { setter = transform.Visit(setClauses[property.Name]); } // If setter was found, insert it if (setter != null) { // Type correction setter = ExpressionHelper.CorrectType(setter, property.PropertyType); memberBindings.Add(Expression.Bind(property, setter)); } } } Expression updater = Expression.Lambda( Expression.MemberInit(Expression.New(type), memberBindings), param); IEnumerable <object> updatedEntities = DatabaseReflectionHelper.UpdateEntities(entitiesToUpdate, updater, context.Transaction); int affectedRecords = 0; foreach (object entity in updatedEntities) { affectedRecords++; Dictionary <string, object> returningEntity = DbCommandActionHelper.CreateReturningEntity(context, returningFields, entity); returningEntities.Add(returningEntity); } return(new EffortDataReader( returningEntities, affectedRecords, returningFields, context.DbContainer)); }