1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
class DatabaseEntities
{
private Entities _entities;
public List<Account> CacheAccount = new List<Account>();
#region Singleton
private static readonly DatabaseEntities instance = new DatabaseEntities();
static DatabaseEntities() { }
private DatabaseEntities()
{
_entities = new Entities();
_entities.Database.Connection.ConnectionString = ConnectionString;
}
public static DatabaseEntities Instance
{
get
{
return instance;
}
}
#endregion
private static string ConnectionString
{
get
{
// Specify the provider name, server and database.
string providerName = "MySql.Data.MySqlClient";
string metaData = "res://*/DataObject.Model1.csdl|res://*/DataObject.Model1.ssdl|res://*/DataObject.Model1.msl";
// Initialize the EntityConnectionStringBuilder.
EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
//Set the provider name.
entityBuilder.Provider = providerName;
// Set the provider-specific connection string.
entityBuilder.ProviderConnectionString = "server=localhost;user id=root;password=root;database=testdb";
entityBuilder.Metadata = metaData;
return entityBuilder.ToString();
}
}
public void Load()
{
foreach (var e in _entities.Account)
this.CacheAccount.Add(e);
}
} |