static void Main(string[] args)
{
string typeName = Assembly.GetEntryAssembly().GetTypes().ToList().SingleOrDefault(x => x.Name == "Client").FullName;
Type entityType = Type.GetType(typeName);
string hauConnectionString = @"Data Source=ADMIN\SQLEXPRESS;Initial Catalog=dam;Integrated Security=True";
//string haiConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=dam;Integrated Security=True";
IDatabase database = DAMFactory.GetDAMFactory(DatabaseType.Sql).InitDatabase(hauConnectionString);
DAMEntity clientEntity = DAMFactory.GetDAMFactory(DatabaseType.Sql).InitDAMEntity(database, "Client");
Console.WriteLine("Total client in Database before Add: ");
List <object> clients = (List <object>)(Object) clientEntity.ToList();
Console.WriteLine(clients.Count.ToString());
Console.WriteLine("Add Client To DB: ");
Client client = new Client();
client.Username = "******";
client.Password = "******";
if (clientEntity.Add(client) > 0)
{
Console.WriteLine("Add Client To DB Successful. ");
}
Console.WriteLine("Total client in Database after Add: ");
List <object> clientsAfterAdd = (List <object>)(Object) clientEntity.ToList();
Console.WriteLine(clientsAfterAdd.Count.ToString());
Console.WriteLine("Update Client in Database:");
Client clientUpdate = clientEntity.FindById(2) as Client;
Console.WriteLine("Client before updated:");
Console.WriteLine("Username: "******", " + "Password: "******"Nguyen Duy Hau Updated";
clientEntity.Update(clientUpdate);
Console.WriteLine("Client after updated:");
Console.WriteLine("Username: "******", " + "Password: "******"Total client in Database before Delete: ");
List <object> clientsAfterDelete = (List <object>)(Object) clientEntity.ToList();
Console.WriteLine(clientsAfterDelete.Count.ToString());
Console.ReadKey();
}
static void Main(string[] args)
{
string thanhhaiConnectionString = @"Data Source=DESKTOP-2GTF1EB\SQLEXPRESS; Initial Catalog = dam; Integrated Security = True";
string hauConnectionString = @"Data Source=ADMIN\SQLEXPRESS;Initial Catalog=dam;Integrated Security=True";
//string haiConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=dam;Integrated Security=True";
//IDatabase database = DAMFactory.GetDAMFactory(DatabaseType.Sql).InitDatabase(hauConnectionString);
IDatabase database = DAMFactory.GetDAMFactory(DatabaseType.Sql).InitDatabase(hauConnectionString);
DAMEntity clientEntity = DAMFactory.GetDAMFactory(DatabaseType.Sql).InitDAMEntity(database, "Client");
Client client = new Client();
client.Username = "******";
client.Password = "******";
clientEntity.Add(client);
List <object> clients = clientEntity.ToList();
Console.WriteLine("HELLO");
Console.ReadKey();
}
