public void Save(string connectionString) { try { IDataServer ds = new DataServer(connectionString); ds.RunTransaction(delegate { ds.CreateAdapter <ColumnDomainTableAdapter>().Update(this.ColumnDomain); ds.CreateAdapter <DomainTableTableAdapter>().Update(this.DomainTable); ds.CreateAdapter <FontTableAdapter>().Update(this.Font); ds.CreateAdapter <IdGroupTableAdapter>().Update(this.IdGroup); ds.CreateAdapter <EntityTypeTableAdapter>().Update(this.EntityType); ds.CreateAdapter <ThemeTableAdapter>().Update(this.Theme); ds.CreateAdapter <LayerTableAdapter>().Update(this.Layer); ds.CreateAdapter <SysIdTableAdapter>().Update(this.SysId); ds.CreateAdapter <PropertyTableAdapter>().Update(this.Property); ds.CreateAdapter <SchemaTableAdapter>().Update(this.Schema); ds.CreateAdapter <TemplateTableAdapter>().Update(this.Template); ds.CreateAdapter <SchemaTemplateTableAdapter>().Update(this.SchemaTemplate); ds.CreateAdapter <EntityTypeSchemaTableAdapter>().Update(this.EntityTypeSchema); ds.CreateAdapter <ZoneTableAdapter>().Update(this.Zone); }); } finally { AcceptChanges(); } }
/// <summary> /// Loads the domain table from the database /// </summary> /// <param name="connectionString">The connection string for the database holding domain data.</param> /// <returns>A index of the domain table, keyed by the short value</returns> Dictionary <string, string> LoadDomainTable(string connectionString) { IDataServer ds = new DataServer(connectionString); Dictionary <string, string> result = new Dictionary <string, string>(); DataTable table = ds.ExecuteSelect("SELECT [ShortValue], [LongValue] FROM " + TableName); foreach (DataRow row in table.Select()) { string key = row[0].ToString(); string val = row[1].ToString(); result.Add(key, val); } return(result); }
public void Load(string connectionString) { IDataServer ds = new DataServer(connectionString); ds.RunTransaction(delegate { ColumnDomainTableAdapter columnDomain = ds.CreateAdapter <ColumnDomainTableAdapter>(); DomainTableTableAdapter domainTable = ds.CreateAdapter <DomainTableTableAdapter>(); FontTableAdapter font = ds.CreateAdapter <FontTableAdapter>(); IdGroupTableAdapter idGroup = ds.CreateAdapter <IdGroupTableAdapter>(); EntityTypeTableAdapter entity = ds.CreateAdapter <EntityTypeTableAdapter>(); ThemeTableAdapter theme = ds.CreateAdapter <ThemeTableAdapter>(); LayerTableAdapter layer = ds.CreateAdapter <LayerTableAdapter>(); SysIdTableAdapter sysid = ds.CreateAdapter <SysIdTableAdapter>(); PropertyTableAdapter prop = ds.CreateAdapter <PropertyTableAdapter>(); SchemaTableAdapter schema = ds.CreateAdapter <SchemaTableAdapter>(); TemplateTableAdapter template = ds.CreateAdapter <TemplateTableAdapter>(); SchemaTemplateTableAdapter schemaTemplate = ds.CreateAdapter <SchemaTemplateTableAdapter>(); EntityTypeSchemaTableAdapter entityTypeSchema = ds.CreateAdapter <EntityTypeSchemaTableAdapter>(); ZoneTableAdapter zone = ds.CreateAdapter <ZoneTableAdapter>(); columnDomain.Fill(this.ColumnDomain); domainTable.Fill(this.DomainTable); font.Fill(this.Font); idGroup.Fill(this.IdGroup); entity.Fill(this.EntityType); theme.Fill(this.Theme); layer.Fill(this.Layer); sysid.Fill(this.SysId); prop.Fill(this.Property); schema.Fill(this.Schema); template.Fill(this.Template); schemaTemplate.Fill(this.SchemaTemplate); entityTypeSchema.Fill(this.EntityTypeSchema); zone.Fill(this.Zone); }); }