MySql.Data.Entity.DeleteGenerator.GenerateSQL C# (CSharp) Method

GenerateSQL() public method

public GenerateSQL ( System.Data.Common.CommandTrees.DbCommandTree tree ) : string
tree System.Data.Common.CommandTrees.DbCommandTree
return string
    public override string GenerateSQL(DbCommandTree tree)
    {
      DbDeleteCommandTree commandTree = tree as DbDeleteCommandTree;

      DeleteStatement statement = new DeleteStatement();

      statement.Target = commandTree.Target.Expression.Accept(this);
      scope.Add("target", statement.Target as InputFragment);

      statement.Where = commandTree.Predicate.Accept(this);

      return statement.ToString();
    }
  }

Usage Example

Example #1
0
        public override string GenerateProcedureBody(ICollection <DbModificationCommandTree> commandTrees, string rowsAffectedParameter, string providerManifestToken)
        {
            MySqlConnection    con  = new MySqlConnection();
            MigrationStatement stmt = new MigrationStatement();

            _providerManifest = DbProviderServices.GetProviderServices(con).GetProviderManifest(providerManifestToken);

            var          cmdStr    = "";
            SqlGenerator generator = new SelectGenerator();

            foreach (var commandTree in commandTrees)
            {
                switch (commandTree.CommandTreeKind)
                {
                case DbCommandTreeKind.Insert:
                    generator = new InsertGenerator();
                    cmdStr    = generator.GenerateSQL(commandTree);
                    break;

                case DbCommandTreeKind.Delete:
                    generator = new DeleteGenerator();
                    cmdStr    = generator.GenerateSQL(commandTree);
                    break;

                case DbCommandTreeKind.Update:
                    generator = new UpdateGenerator();
                    cmdStr    = generator.GenerateSQL(commandTree);
                    break;

                case DbCommandTreeKind.Query:
                    generator = new SelectGenerator();
                    cmdStr    = generator.GenerateSQL(commandTree);
                    break;

                case DbCommandTreeKind.Function:
                    generator = new FunctionGenerator();
                    cmdStr    = generator.GenerateSQL(commandTree);
                    break;
                }
                stmt.Sql += cmdStr.Replace("dbo.", "") + ";";
            }
            return(stmt.Sql);
        }
All Usage Examples Of MySql.Data.Entity.DeleteGenerator::GenerateSQL
DeleteGenerator