static void Ef6() { var fixture = new Fixture(); var item = fixture.CreateMany <Product>(10000); Stopwatch stopwatch = new Stopwatch(); Console.WriteLine("Iniciando comparación"); Console.WriteLine("==ENTITY FRAMEWORK 6=="); Console.WriteLine("Insertando {0} registros", item.Count()); using (var transactionScope = new TransactionScope()) { CatalogEntities ctx = new CatalogEntities(); stopwatch.Start(); ctx.Product.AddRange(item); ctx.SaveChanges(); stopwatch.Stop(); Console.WriteLine("Duracion {0} ms ", stopwatch.ElapsedMilliseconds); Console.WriteLine("Duracion {0} se ", stopwatch.Elapsed.Seconds); Console.WriteLine("Duracion {0} mi ", stopwatch.Elapsed.Minutes); stopwatch.Reset(); Console.WriteLine("Obteniendo TODO los registros"); stopwatch.Start(); var reponse = ctx.Product; stopwatch.Stop(); Console.WriteLine("Se obtuvo {0} en una duracion de {1} ms", reponse.Count(), stopwatch.ElapsedMilliseconds); Console.WriteLine("Se obtuvo {0} en una duracion de {1} se", reponse.Count(), stopwatch.Elapsed.Seconds); Console.WriteLine("Se obtuvo {0} en una duracion de {1} mi", reponse.Count(), stopwatch.Elapsed.Minutes); } }
public static void Pdf(int StudentID, int GrupaID, int Semestru, string FileName) { //Creating iTextSharp Table from the DataTable data using (var context = new CatalogEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { var tabel = context.usp_catalog_sesiunea_x(StudentID, GrupaID, Semestru); // var tabel = from a in context.CATALOG_CU_NOTE_TEMPORAR // select a; // context.CATALOG_CU_NOTE_TEMPORAR.ToString(); // Console.Out.WriteLine(query.Count); //Console.Out.WriteLine(query[0].NumeMaterie.ToString()); //PdfPTable pdfTable = new PdfPTable(query.Count);//nr of collumns //pdfTable.DefaultCell.Padding = 3; //pdfTable.WidthPercentage = 30; //pdfTable.HorizontalAlignment = Element.ALIGN_LEFT; //pdfTable.DefaultCell.BorderWidth = 1; //for ( int i=0; i< query.Count; i++) //{ // PdfPCell cell = new PdfPCell(new Phrase(query.ElementAt(i).)); // pdfTable.AddCell(cell); //} //foreach (var post in query) //{ //} context.SaveChanges(); dbContextTransaction.Commit(); } catch (Exception) { dbContextTransaction.Rollback(); } } } }
public ActionResult Register(User user) { if (ModelState.IsValid) { CatalogEntities dc=new CatalogEntities(); dc.Users.Add(user); dc.SaveChanges(); ModelState.Clear(); user = null; ViewBag.Message = "Registration done successfully"; } return View(user); }
public ActionResult Register(User user) { if (ModelState.IsValid) { CatalogEntities dc = new CatalogEntities(); dc.Users.Add(user); dc.SaveChanges(); ModelState.Clear(); user = null; ViewBag.Message = "Registration done successfully"; } return(View(user)); }