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