public static void InitializeFromConfigSection()
{
// Initialize only once
if (initalisationCompleted)
{
return;
}
esConfigSection configSection = (esConfigSection)System.Configuration.ConfigurationManager.GetSection("EntitySpaces");
esConfigConnectionInfoElement connInfo = configSection.connectionInfo;
if (connInfo == null)
{
return;
}
foreach (esConfigConnectionElement connElement in connInfo.Connections)
{
esConnectionElement esCon = new esConnectionElement();
esCon.Name = connElement.Name;
esCon.Provider = connElement.Provider;
esCon.ProviderMetadataKey = connElement.ProviderMetadataKey;
esCon.SqlAccessType = esSqlAccessType.DynamicSQL;
esCon.Provider = connElement.Provider;
esCon.ProviderClass = connElement.ProviderClass;
esCon.Schema = connElement.Schema;
esCon.ConnectionString = connElement.ConnectionString;
esConfigSettings.ConnectionInfo.Connections.Add(esCon);
}
esConfigSettings.ConnectionInfo.Default = connInfo.DefaultConnection;
initalisationCompleted = true;
}
public void Remove(esConnectionElement connection)
{
if (BaseIndexOf(connection) >= 0)
{
BaseRemove(connection.Provider);
}
}
static void Main()
{
esProviderFactory.Factory = new EntitySpaces.Loader.esDataProviderFactory();
//// Just make sure we have a hard reference to the VistaDB Compact Framework Library
//VistaDB.TriggerAction t = TriggerAction.AfterDelete;
string cnString = ("Data Source = " + (System.IO.Path.GetDirectoryName
(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) +
"\\ForeignKeyTest_35.sdf;"));
// What the heck let's register a second connection
esConnectionElement conn = new esConnectionElement();
conn.ConnectionString = cnString;
conn.Name = "SqlCE";
conn.Provider = "EntitySpaces.SqlServerCeProvider.CF";
conn.ProviderClass = "DataProvider";
conn.SqlAccessType = esSqlAccessType.DynamicSQL;
conn.ProviderMetadataKey = "esDefault";
esConfigSettings.ConnectionInfo.Connections.Add(conn);
// Assign the Default Connection
esConfigSettings.ConnectionInfo.Default = "SqlCE";
Application.Run(new Form1());
}
public void Remove(esConnectionElement connection)
{
if (!this.hash.ContainsKey(connection.Name))
{
this.list.Remove(connection);
this.hash.Remove(connection.Name);
}
}
public void Add(esConnectionElement connection)
{
if (!this.hash.ContainsKey(connection.Name))
{
this.hash[connection.Name] = connection;
this.list.Add(connection);
}
}
public esConnectionElement this[string name]
{
get
{
esConnectionElement element = null;
if (this.hash.ContainsKey(name))
{
element = this.hash[name];
}
return(element);
}
}
protected override void Setup()
{
var conn = new esConnectionElement();
conn.ConnectionString = @"Data Source=.;Initial Catalog=PerformanceTest;Integrated Security=True;Pooling=True;MultipleActiveResultSets = true";
conn.Name = "PerformanceTest";
conn.Provider = "EntitySpaces.SqlClientProvider";
conn.ProviderClass = "DataProvider";
conn.SqlAccessType = esSqlAccessType.DynamicSQL;
conn.ProviderMetadataKey = "esDefault";
conn.DatabaseVersion = "2005";
esConfigSettings.ConnectionInfo.Connections.Add(conn);
esConfigSettings.ConnectionInfo.Default = "PerformanceTest";
esProviderFactory.Factory = new EntitySpaces.LoaderMT.esDataProviderFactory();
var simplests = new SimplestsCollection();
simplests.LoadAll();
simplests.MarkAllAsDeleted();
simplests.Save();
}
protected void InitEntitySpacesConnection()
{
if (esConfigSettings.ConnectionInfo.Default != "SiteSqlServer")
{
esConfigSettings ConnectionInfoSettings = esConfigSettings.ConnectionInfo;
foreach (esConnectionElement connection in ConnectionInfoSettings.Connections)
{
//if there is a SiteSqlServer in es connections set it default
if (connection.Name == "SiteSqlServer")
{
esConfigSettings.ConnectionInfo.Default = connection.Name;
return;
}
}
//no SiteSqlServer found grab dnn cnn string and create
string dnnConnection = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString;
// Manually register a connection
esConnectionElement conn = new esConnectionElement();
conn.ConnectionString = dnnConnection;
conn.Name = "SiteSqlServer";
conn.Provider = "EntitySpaces.SqlClientProvider";
conn.ProviderClass = "DataProvider";
conn.SqlAccessType = esSqlAccessType.DynamicSQL;
conn.ProviderMetadataKey = "esDefault";
conn.DatabaseVersion = "2005";
// Assign the Default Connection
esConfigSettings.ConnectionInfo.Connections.Add(conn);
esConfigSettings.ConnectionInfo.Default = "SiteSqlServer";
// Register the Loader
esProviderFactory.Factory = new EntitySpaces.LoaderMT.esDataProviderFactory();
}
}
public void Remove(esConnectionElement connection)
{
if (BaseIndexOf(connection) >= 0)
{
BaseRemove(connection.Provider);
}
}
public void Add(esConnectionElement connection)
{
BaseAdd(connection);
}
public int IndexOf(esConnectionElement connection)
{
return BaseIndexOf(connection);
}
public void Add(esConnectionElement connection)
{
BaseAdd(connection);
}
public int IndexOf(esConnectionElement connection)
{
return(BaseIndexOf(connection));
}
private void InitDatabaseConnection()
{
try
{
if (conn == null)
{
conn = new esConnectionElement();
conn.Name = "VistaDB4";
conn.ConnectionString = @"Data Source=C:\Content\Database\CoreDB.vdb4;Open Mode=NonexclusiveReadWrite;";
conn.Provider = "EntitySpaces.VistaDB4Provider";
conn.ProviderClass = "DataProvider";
conn.SqlAccessType = esSqlAccessType.DynamicSQL;
conn.ProviderMetadataKey = "esDefault";
//conn.DatabaseVersion = "2005";
// --- Assign the Default Connection ---
esConfigSettings.ConnectionInfo.Connections.Add(conn);
esConfigSettings.ConnectionInfo.Default = "VistaDB4";
}
}
catch (Exception ex)
{
}
}
