public Setup(string conn) { InitDbs(conn); db = base.Database; DBSchemaProvider provider = db.GetSchemaProvider(); tables = provider.GetAllTables(); }
private void toolStripButton2_Click(object sender, EventArgs e) { ClientConnection con = new ClientConnection(); if (con.ShowDialog(this) == DialogResult.OK) { database = DBDatabase.Create(con.ConnectionString, con.ProviderName); provider = database.GetSchemaProvider(); this.LoadSchemaTree(); } }
/// <summary> /// /// </summary> /// <returns></returns> public List <string> GetTables() { List <DBSchemaItemRef> tables; List <string> tbls = new List <string>(); DBSchemaProvider provider = db.GetSchemaProvider(); tables = provider.GetAllTables().ToList(); foreach (DBSchemaItemRef s in tables) { tbls.Add(s.Name); } return(tbls); }
private bool ChooseConnection() { ClientConnection con = new ClientConnection(); if (con.ShowDialog() == DialogResult.OK) { database = DBDatabase.Create(con.ConnectionString, con.ProviderName); provider = database.GetSchemaProvider(); return(true); } else { return(false); } }
public void AddEmployeeNoAliasField() { DBSchemaProvider provider = db.GetSchemaProvider(); DBSchemaTable table = provider.GetTable("sys_User"); var fld = table.Columns.Where(x => x.Name.ToLower() == "oldemployeeno").FirstOrDefault(); if (fld == null) { string tblschema = "ALTER TABLE sys_User ADD oldemployeeno varchar(255) NULL"; try { int r = db.ExecuteNonQuery(tblschema); } catch (System.Exception ex) { // throw new Exception.TableSchemaException(this.Table, fields, Exception.OperaitonType.addkey, ex.Message); } } // DBSchemaItemRef table = tables.Where(x => x.Name.ToLower() == ).FirstOrDefault(); }
public static bool CheckFieldExist(string tbName, string fieldName, string conn) { DataBase db = new DataBase(); db.InitDbs(conn); DBSchemaTable tables; DBSchemaProvider provider = db.Database.GetSchemaProvider(); tables = provider.GetTable(tbName); var fd = tables.Columns.Where(x => x.Name.ToLower() == fieldName.ToLower()).FirstOrDefault(); if (fd == null) { return(false); } else { return(true); } }
/// <summary> /// /// </summary> /// <param name="tbName"></param> /// <returns></returns> public DBSchemaTable GetTable(string tbName) { DBSchemaProvider provider = db.GetSchemaProvider(); return(provider.GetTable(tbName)); }
public void Install() { DBSchemaProvider provider = db.GetSchemaProvider(); tables = provider.GetAllTables(); DBSchemaItemRef table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozSchema.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozSchema.Table) .Add(Builder.Schema.TalentozSchema.ComponentID) .Add(Builder.Schema.TalentozSchema.ComponentName) .Add(Builder.Schema.TalentozSchema.Category) .Add(Builder.Schema.TalentozSchema.ComponentType) .Add(Builder.Schema.TalentozSchema.Title) .Add(Builder.Schema.TalentozSchema.PrimaryKeys) .Add(Builder.Schema.TalentozSchema.TableName) .Add(Builder.Schema.TalentozSchema.IsGlobal) .Add(Builder.Schema.TalentozSchema.ComponentState) .Add(Builder.Schema.TalentozSchema.EntityKey) .Add(Builder.Schema.TalentozSchema.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchema.ComponentID.Name, Builder.Schema.TalentozSchema.Table); } else { throw new System.Exception(Builder.Schema.TalentozSchema.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozSchemaInfo.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozSchemaInfo.Table) .Add(Builder.Schema.TalentozSchemaInfo.ComponentID) .Add(Builder.Schema.TalentozSchemaInfo.FieldID) .Add(Builder.Schema.TalentozSchemaInfo.AttributeName) .Add(Builder.Schema.TalentozSchemaInfo.DisplayName) .Add(Builder.Schema.TalentozSchemaInfo.IsRequired) .Add(Builder.Schema.TalentozSchemaInfo.IsUnique) .Add(Builder.Schema.TalentozSchemaInfo.IsCore) .Add(Builder.Schema.TalentozSchemaInfo.IsReadOnly) .Add(Builder.Schema.TalentozSchemaInfo.IsSecured) .Add(Builder.Schema.TalentozSchemaInfo.IsNullable) .Add(Builder.Schema.TalentozSchemaInfo.ISPrimaryKey) .Add(Builder.Schema.TalentozSchemaInfo.IsAuto) .Add(Builder.Schema.TalentozSchemaInfo.LookUpID) .Add(Builder.Schema.TalentozSchemaInfo.AttributeType) .Add(Builder.Schema.TalentozSchemaInfo.Length) .Add(Builder.Schema.TalentozSchemaInfo.DefaultValue) .Add(Builder.Schema.TalentozSchemaInfo.FileExtension) .Add(Builder.Schema.TalentozSchemaInfo.LookupComponent) .Add(Builder.Schema.TalentozSchemaInfo.ComponentLookupDisplayName) .Add(Builder.Schema.TalentozSchemaInfo.RegExp) .Add(Builder.Schema.TalentozSchemaInfo.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaInfo.ComponentID.Name + "," + Builder.Schema.TalentozSchemaInfo.FieldID.Name , Builder.Schema.TalentozSchemaInfo.Table); } else { throw new System.Exception(Builder.Schema.TalentozSchemaInfo.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozSchemaClientInfo.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozSchemaClientInfo.Table) .Add(Builder.Schema.TalentozSchemaClientInfo.ClientID) .Add(Builder.Schema.TalentozSchemaClientInfo.ComponentID) .Add(Builder.Schema.TalentozSchemaClientInfo.FieldID) .Add(Builder.Schema.TalentozSchemaClientInfo.AttributeName) .Add(Builder.Schema.TalentozSchemaClientInfo.DisplayName) .Add(Builder.Schema.TalentozSchemaClientInfo.IsRequired) .Add(Builder.Schema.TalentozSchemaClientInfo.IsUnique) .Add(Builder.Schema.TalentozSchemaClientInfo.IsCore) .Add(Builder.Schema.TalentozSchemaClientInfo.IsReadOnly) .Add(Builder.Schema.TalentozSchemaClientInfo.IsSecured) .Add(Builder.Schema.TalentozSchemaClientInfo.IsNullable) .Add(Builder.Schema.TalentozSchemaClientInfo.ISPrimaryKey) .Add(Builder.Schema.TalentozSchemaClientInfo.IsAuto) .Add(Builder.Schema.TalentozSchemaClientInfo.LookUpID) .Add(Builder.Schema.TalentozSchemaClientInfo.AttributeType) .Add(Builder.Schema.TalentozSchemaClientInfo.Length) .Add(Builder.Schema.TalentozSchemaClientInfo.DefaultValue) .Add(Builder.Schema.TalentozSchemaClientInfo.FileExtension) .Add(Builder.Schema.TalentozSchemaClientInfo.LookupComponent) .Add(Builder.Schema.TalentozSchemaClientInfo.ComponentLookupDisplayName) .Add(Builder.Schema.TalentozSchemaClientInfo.RegExp) .Add(Builder.Schema.TalentozSchemaClientInfo.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaClientInfo.ClientID.Name + "," + Builder.Schema.TalentozSchemaClientInfo.ComponentID.Name + "," + Builder.Schema.TalentozSchemaClientInfo.FieldID.Name , Builder.Schema.TalentozSchemaClientInfo.Table); } else { throw new System.Exception(Builder.Schema.TalentozSchemaClientInfo.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozView.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozView.Table) .Add(Builder.Schema.TalentozView.ViewID) .Add(Builder.Schema.TalentozView.CoreComponent) .Add(Builder.Schema.TalentozView.Name) .Add(Builder.Schema.TalentozView.Catgory) .Add(Builder.Schema.TalentozView.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozView.ViewID.Name , Builder.Schema.TalentozView.Table); } else { throw new System.Exception(Builder.Schema.TalentozView.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozViewSchema.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozViewSchema.Table) .Add(Builder.Schema.TalentozViewSchema.ViewID) .Add(Builder.Schema.TalentozViewSchema.ComponentID) .Add(Builder.Schema.TalentozViewSchema.ChildComponentID) .Add(Builder.Schema.TalentozViewSchema.ComponentAlias) .Add(Builder.Schema.TalentozViewSchema.LastUPD); //.Add(TzAccount.Client.ServerID) .Add(Builder.Schema.TalentozSchema.OrganizationName); db.ExecuteNonQuery(create); // CreatePrimaryKeys(Builder.Schema.TalentozViewSchema.ViewID.Name //, Builder.Schema.TalentozView.Table); } else { throw new System.Exception(Builder.Schema.TalentozViewSchema.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozViewSchemaRelation.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozViewSchemaRelation.Table) .Add(Builder.Schema.TalentozViewSchemaRelation.ViewID) .Add(Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation) .Add(Builder.Schema.TalentozViewSchemaRelation.ParentField) .Add(Builder.Schema.TalentozViewSchemaRelation.RelatedField) .Add(Builder.Schema.TalentozViewSchemaRelation.Parent) .Add(Builder.Schema.TalentozViewSchemaRelation.Child) .Add(Builder.Schema.TalentozViewSchemaRelation.LastUPD); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozViewSchemaRelation.ViewID.Name + "," + Builder.Schema.TalentozViewSchemaRelation.ViewSchemaRelation.Name , Builder.Schema.TalentozViewSchemaRelation.Table); } else { throw new System.Exception(Builder.Schema.TalentozViewSchemaRelation.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozTemplate.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozTemplate.Table) .Add(Builder.Schema.TalentozTemplate.ClientID) .Add(Builder.Schema.TalentozTemplate.TemplateID) .Add(Builder.Schema.TalentozTemplate.Name) .Add(Builder.Schema.TalentozTemplate.TemplateCode) .Add(Builder.Schema.TalentozTemplate.ViewFields) .Add(Builder.Schema.TalentozTemplate.TemplateType) .Add(Builder.Schema.TalentozTemplate.PivotColumn) .Add(Builder.Schema.TalentozTemplate.Category) .Add(Builder.Schema.TalentozTemplate.ViewID) .Add(Builder.Schema.TalentozTemplate.LastUPD); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaClientInfo.ClientID.Name + "," + Builder.Schema.TalentozTemplate.TemplateID.Name , Builder.Schema.TalentozTemplate.Table); } else { throw new System.Exception(Builder.Schema.TalentozTemplate.Table + " table Name exist"); } table = tables.Where(x => x.Name.ToLower() == Builder.Schema.TalentozImportLog.Table.ToLower()).FirstOrDefault(); if (table == null) { DBQuery create; create = DBQuery.Create.Table(base.Schema, Builder.Schema.TalentozImportLog.Table) .Add(Builder.Schema.TalentozImportLog.ImportID) .Add(Builder.Schema.TalentozImportLog.ClientID) .Add(Builder.Schema.TalentozImportLog.ImportSchema) .Add(Builder.Schema.TalentozImportLog.ActionBy) .Add(Builder.Schema.TalentozImportLog.Step) .Add(Builder.Schema.TalentozImportLog.LastUPD); db.ExecuteNonQuery(create); CreatePrimaryKeys(Builder.Schema.TalentozSchemaClientInfo.ClientID.Name + "," + Builder.Schema.TalentozImportLog.ImportID.Name , Builder.Schema.TalentozImportLog.Table); } else { throw new System.Exception(Builder.Schema.TalentozImportLog.Table + " table Name exist"); } }