C# (CSharp) Sharp.Data Dialect.GetDeleteSql Examples

GetDeleteSql() public method

public GetDeleteSql ( string table ) : string
table	string
return	string

Example #1

File: DataClient.cs Project: lenerson/sharpmigrations

        public virtual int DeleteSql(string table, Filter filter)
        {
            string sql = Dialect.GetDeleteSql(table);

            if (filter != null)
            {
                string   whereSql   = Dialect.GetWhereSql(filter, 0);
                object[] pars       = filter.GetAllValueParameters();
                In[]     parameters = Dialect.ConvertToNamedParameters(0, pars);
                return(Database.ExecuteSql(sql + " " + whereSql, parameters));
            }

            return(Database.ExecuteSql(sql));
        }