static public Contact SelectOne(int idContact)
{
using (DBContactEntities enitites = new DBContactEntities())
{
return(enitites.Contacts.Where(co => co.IdContact == idContact).First());
}
}
public static void Update2(Contact c)
{
using (DBContactEntities entities = new DBContactEntities())
{
//Classe de performances
Stopwatch sw = new Stopwatch();
sw.Start();
//Pour les performances desactiver Le tracking pourpasser en self
entities.Configuration.AutoDetectChangesEnabled = false;
entities.Contacts.Attach(c);
Console.WriteLine(entities.Entry(c).State);
c.Adresse = "NEW ADRESS";
Console.WriteLine(entities.Entry(c).State);
entities.SaveChanges();
//Affiche les performances
sw.Stop();
Console.WriteLine(sw.Elapsed.TotalMilliseconds.ToString());
}
}
public static void AfficheUnContact2()
{
Stopwatch sw = new Stopwatch();
sw.Start();
using (DBContactEntities entities = new DBContactEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
Contact c = entities.Contacts.First();
/*IQueryable<Contact> c = from co in entities.Contacts
* select co;*/
string result = c.ToString();
//remonte une collection de navigation (cote many)
entities.Entry(c).Collection("Telephones").Load();
foreach (Telephone item in c.Telephones)
{
Console.WriteLine(item.numero);
}
//Comptage de donnees en memoires
Console.WriteLine(entities.Contacts.Local.Count);
sw.Stop();
Console.WriteLine(sw.Elapsed.Milliseconds);
}
}
public static void ContactParTelephone()
{
Stopwatch sw = new Stopwatch();
sw.Start();
using (DBContactEntities entities = new DBContactEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
IQueryable <Telephone> t = entities.Telephones.Where(te => te.idContact == 2);
/*IQueryable<Telephone> t = from te in entities.Telephones
* where te.idContact == 2
* select te;*/
foreach (Telephone tels in t)
{
//remonte un element de navigation (cote one)
entities.Entry(tels).Reference("Contact").Load();
Console.WriteLine("Id contact : {0}, numero : {1}", tels.Contact.IdContact, tels.numero);
}
}
sw.Stop();
Console.WriteLine(sw.Elapsed.Milliseconds);
}
public static void AddTel(Contact c, string numero)
{
using (DBContactEntities entities = new DBContactEntities())
{
entities.Contact.Attach(c);
c.Telephone.Add(new Telephone()
{
numero = numero
});
entities.SaveChanges();
}
}
public static void Affiche()
{
using (DBContactEntities entities = new DBContactEntities())
{
//Execurte une requete SQL
List <Contact> lstContact = entities.Contacts.SqlQuery(@"SELECT * FROM Contact").ToList <Contact>();
foreach (Contact item in lstContact)
{
Console.WriteLine(item.IdContact);
}
}
}
static public void UpdateContact(Contact c)
{
using (DBContactEntities entities = new DBContactEntities())
{
entities.Entry(c).State = System.Data.Entity.EntityState.Modified;
Console.WriteLine(entities.Entry(c).State);
Console.WriteLine("DataBase Values :");
PrintProp(entities.Entry(c).GetDatabaseValues());
Console.WriteLine("Current Values :");
PrintProp(entities.Entry(c).CurrentValues);
entities.SaveChanges();
}
}
static void Main(string[] args)
{
using (_entities = new DBContactEntities())
{
_repContact = new REPContact(_entities);
Contact c = new Contact();
c.Nom = "gasquet";
c.Prenom = "Nicolas";
c.DateNaiss = new DateTime(1981, 06, 21);
c.Cp = "85";
c.Email = "*****@*****.**";
_repContact.AddContact(c);
}
}
public static void AfficheUnContact()
{
Stopwatch sw = new Stopwatch();
sw.Start();
using (DBContactEntities entities = new DBContactEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
Contact c = entities.Contacts.Include("Telephones").First();
foreach (Telephone item in c.Telephones)
{
Console.WriteLine(item.numero);
}
sw.Stop();
Console.WriteLine(sw.Elapsed.Milliseconds);
}
}
public static void ListerContactTel()
{
Stopwatch sw = new Stopwatch();
sw.Start();
using (DBContactEntities entities = new DBContactEntities())
{
foreach (Contact contacts in entities.Contact)
{
Console.WriteLine("Nom : {0}", contacts.Nom);
foreach (Telephone telephones in contacts.Telephone)
{
Console.WriteLine("Numero : {0}", telephones.numero);
}
}
}
sw.Stop();
Console.WriteLine(sw.ElapsedMilliseconds);
}
static void Main(string[] args)
{
StringBuilder sb = new StringBuilder();
using (DBContactEntities enitites = new DBContactEntities())
{
_repContact = new REPContact(enitites);
Console.WriteLine("Valeur du filtre Contact");
_repContact.ExtractValueConditionalMapping();
foreach (Contact co in _repContact.SelectAllContact())
{
sb.Append(string.Concat(co.Nom, " "));
sb.Append(string.Concat(co.Cp, " "));
sb.Append(string.Concat(co.Ville, " "));
sb.Append(string.Concat(co.DateNaiss, " "));
sb.AppendLine();
}
Console.WriteLine(sb);
}
}
static void Main(string[] args)
{
using (DBContactEntities entities = new DBContactEntities())
{
//Appel de procédure simple de lecture
foreach (string item in entities.SelectionContactNom("G"))
{
Console.WriteLine(item);
}
//Insert de client
entities.InsertContact("GERARDO", "Pierre", DateTime.Now);
Console.WriteLine(entities.InsertContactAndReturn("ZORRO", "DEl la Vega", DateTime.Now).FirstOrDefault());
//Appel de function scalaire
Contact co = entities.Contact.Where(c => c.Nom == Contact.ReturnNomContact(15)).First();
Console.WriteLine(co.Nom);
//TVFs appel
foreach (AllContact_Result item in entities.AllContact())
{
Console.WriteLine(item.Nom);
}
//TVFs appel avec parametre et complexe type specifique ID 15
OneContact_Result complexContact = entities.OneContact(15).FirstOrDefault();
foreach (PropertyInfo item in typeof(OneContact_Result).GetProperties())
{
Console.WriteLine("{0} : {1}", item.Name, item.GetValue(complexContact));
}
}
}
public static void AfficheTout()
{
Stopwatch sw = new Stopwatch();
sw.Start();
using (DBContactEntities entities = new DBContactEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
foreach (Contact contacts in entities.Contacts)
{
StringBuilder sb = new StringBuilder();
sb.Append(contacts.Nom);
sb.Append(" ");
sb.Append(contacts.Prenom);
sb.Append(" ");
sb.Append(contacts.DateNaiss.ToString("dddd MMM yyyy"));
sb.Append(Environment.NewLine);
sb.Append("phone(s) Number : ");
foreach (Telephone telephones in contacts.Telephones)
{
sb.Append(Environment.NewLine);
sb.Append(telephones.Contact.IdContact);
sb.Append(" - ");
sb.Append(telephones.numero);
}
Console.WriteLine(sb);
}
sw.Stop();
Console.WriteLine(sw.Elapsed.Milliseconds.ToString());
}
}
public REPContact(DBContactEntities enitites)
{
_enitites = enitites;
}
