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);
});
}
