/// <summary> /// 删除视图。 /// </summary> /// <param name="type">指定对象类型。</param> /// <param name="name">操作对象名称。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase DropView(Type type, DbName name = null) { if (name == null) { var View = _Metadata.Table(type); name = DbName.Create(View.Name, View.Schema); } return(new DbDropObjectOperate(_Context, type, EOperateType.DropView, name)); }
/// <summary> /// 创建视图。 /// </summary> /// <param name="type">指定对象类型。</param> /// <param name="content">视图内容。</param> /// <param name="name">指定视图名。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase CreateView(Type type, string content, DbName name = null) { if (name == null) { var table = _Metadata.Table(type); name = DbName.Create(table.Name, table.Schema); } return(new DbCreateViewOperate(_Context, type, name, content)); }
/// <summary> /// 创建视图。 /// </summary> /// <param name="type">指定对象类型。</param> /// <param name="query">查询内容。</param> /// <param name="name">指定视图名。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase CreateView(Type type, IQueryable query, DbName name = null) { if (name == null) { var table = _Metadata.Table(type); name = DbName.Create(table.Name, table.Schema); } return(new DbCreateViewOperate(_Context, type, name, query.Expression)); }
/// <summary> /// 重命名数据表。 /// </summary> /// <param name="type">指定对象类型。</param> /// <param name="newName">操作对象名称。</param> /// <param name="name">操作对象名称。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase RenameTable(Type type, string newName, DbName name = null) { if (name == null) { var table = _Metadata.Table(type); name = DbName.Create(table.Name, table.Schema); } return(new DbRenameObjectOperate(_Context, type, EOperateType.RenameTable, name, newName)); }
/// <summary> /// 判断指定的数据表是否存在。 /// </summary> /// <param name="type">指定对象类型。</param> /// <param name="name">操作对象名称。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase TableIsExsit(Type type, DbName name = null) { if (name == null) { var table = _Metadata.Table(type); name = DbName.Create(table.Name, table.Schema); } return(new DbObjectIsExsitOperate(_Context, type, EOperateType.TableIsExsit, name)); }
/// <summary> /// 判断指定的数据表是否存在。 /// </summary> /// <typeparam name="T">映射的对象类型。</typeparam> /// <param name="name">表名。</param> /// <param name="schema">架构名。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase TableIsExsit <T>(string name = "", string schema = "") { if (name == "") { return(TableIsExsit(typeof(T))); } else { return(TableIsExsit(typeof(T), DbName.Create(name, schema))); } }
/// <summary> /// 删除视图。 /// </summary> /// <typeparam name="T">映射的对象类型。</typeparam> /// <param name="name">视图名。</param> /// <param name="schema">架构名。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase DropView <T>(string name = "", string schema = "") { if (name == "") { return(DropView(typeof(T))); } else { return(DropView(typeof(T), DbName.Create(name, schema))); } }
/// <summary> /// 创建视图。 /// </summary> /// <typeparam name="T">指定对象类型。</typeparam> /// <param name="query">查询内容。</param> /// <param name="name">视图名。</param> /// <param name="schema">架构名。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase CreateView <T>(IQueryable <T> query, string name = "", string schema = "") { if (name == "") { return(CreateView(typeof(T), query)); } else { return(CreateView(typeof(T), query, DbName.Create(name, schema))); } }
/// <summary> /// 删除数据表。 /// </summary> /// <typeparam name="T">映射的对象类型。</typeparam> /// <param name="newName">操作对象名称。</param> /// <param name="name">表名。</param> /// <param name="schema">架构名。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase RenameTable <T>(string newName, string name = "", string schema = "") { if (name == "") { return(RenameTable(typeof(T), newName)); } else { return(RenameTable(typeof(T), newName, DbName.Create(name, schema))); } }
/// <summary> /// 创建数据表变量。 /// </summary> /// <param name="type">指定对象类型。</param> /// <param name="name">指定表名。</param> /// <returns>操作实例。</returns> public DbMaintenanceOperateBase CreateTableVariable(Type type, string name) { return(new DbCreateTableOperate(_Context, type, EOperateType.CreateTableVariable, DbName.Contact(name))); }