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