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());
}
static void Main(string[] args)
{
esProviderFactory.Factory = new EntitySpaces.Loader.esDataProviderFactory();
// Add a connection
esConnectionElement conn = new esConnectionElement();
conn.Provider = "EntitySpaces.SqlClientProvider";
conn.DatabaseVersion = "2012";
conn.ConnectionString = "User ID=sa;Password=blank;Initial Catalog=Northwind;Data Source=localhost";
esConfigSettings.ConnectionInfo.Connections.Add(conn);
AddLoadSaveDeleteSingleEntity();
StreamlinedDynamicQueryAPI();
CollectionLoadAll();
SaveEntity();
UpdateEntity();
DeleteEntity();
CollectionSave();
CollectionSave_BulkInsert();
CollectionSaveHierarchical();
GetTheCount();
GroupBy();
Concatenation();
Paging();
WhereExists();
CorrelatedSubQuery();
CorrelatedSubQueryEmbeddedSubQuery();
SelectAllExcept();
SelectDistinctTop();
AliasColumn();
AndOr();
Filter();
Query_Join();
Subquery();
CaseWhenThenEnd();
HavingClause();
SumOver();
OverAndAliasQuerySimple();
OverAndAliasQuery();
OverMashup();
GetEmployees(1, 2);
}
// Sql Connection
public static void SetSqlConnection()
{
string cnString = @"Password=Kx09a32x;Persist Security Info=True;User ID=sa;Initial Catalog=PARTDB;Data Source=DBSERVER";
esConnectionElement conn = new esConnectionElement();
conn.ConnectionString = cnString;
conn.Name = "PARTDB";
conn.Provider = "EntitySpaces.SqlClientProvider";
conn.ProviderClass = "DataProvider";
conn.SqlAccessType = esSqlAccessType.DynamicSQL;
//conn.ProviderMetadataKey = "esDefault";
esConfigSettings.ConnectionInfo.Connections.Add(conn);
// Assign the Default Connection
esConfigSettings.ConnectionInfo.Default = "PARTDB";
}
// Set Access Connection with File Path
public static void SetAccessConection(string path)
{
Weaselware.Knoodle.Properties.Settings.Default.dataPath = path;
Weaselware.Knoodle.Properties.Settings.Default.Save();
string cnString = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" + @path;
esConnectionElement conn = new esConnectionElement();
conn.ConnectionString = cnString;
conn.Name = "MSaccess";
conn.Provider = "EntitySpaces.MSAccessProvider";
conn.ProviderClass = "DataProvider";
conn.SqlAccessType = esSqlAccessType.DynamicSQL;
conn.ProviderMetadataKey = "esDefault";
esConfigSettings.ConnectionInfo.Connections.Add(conn);
// Assign the Default Connection
esConfigSettings.ConnectionInfo.Default = "MSaccess";
}
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();
}
private static void InitializeEntitySpaces()
{
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();
}
}