public void Update(Weather weather) { try { using (var context = new NewContext()) { var q = from w in context.Weathers where w.Timestamp == weather.Timestamp select w; if (q.Count() > 0) { return; } context.Weathers.Add(weather); context.SaveChanges(); } } catch (DbUpdateException e) { MySqlException innerException = e.InnerException.InnerException as MySqlException; if (innerException == null || innerException.Number != 1062) { throw; } } }
public ActionResult Create(Product product) { try { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(product)); // TODO: Add insert logic here } catch { return(View()); } }
public string Create([Bind(Exclude = "CustomerId")] Customer obj) { string msg; try { if (ModelState.IsValid) { db.Customers.Add(obj); db.SaveChanges(); msg = "Saved Successfully"; } else { msg = "Validation data not successfully"; } } catch (Exception ex) { msg = "Error occured:" + ex.Message; } return(msg); }
public ActionResult AddNew(string FormHead, string FormDescription) { var CurrentDate = DateTime.Now; if ((FormHead != null) && (FormDescription != null)) { db.News.Add(new New { Head = FormHead, Description = FormDescription, Date = CurrentDate }); db.SaveChanges(); int last_id = (from n in db.News select n.NewId).ToList().Last(); WebImage photo = null; photo = WebImage.GetImageFromRequest(); if (photo != null) { photo.FileName = last_id.ToString(); photo.Resize(width: 250, height: 168, preserveAspectRatio: true, preventEnlarge: true); photo.Save(@"~/Content/Images/" + photo.FileName); } } return(RedirectToAction("Index", "Home")); }
public void UpdateSite(int number, string name, double latitude, double longitude) { using (var context = new NewContext()) { long siteId = ResolveSite(context, number); var q = from s in context.Sites where s.Id == siteId select s; Site site = q.First(); site.Name = name; site.Latitude = latitude; site.Longitude = longitude; context.SaveChanges(); } }
static void Main(string[] args) { using (var db = new NewContext()) { Console.WriteLine("请输入Name:"); var name = Console.ReadLine(); var newType = new NewType { Name = name }; db.NewTypes.Add(newType); db.SaveChanges(); Console.WriteLine("Save successfully"); Console.Read(); } }
Task MigrateSite <T>(Func <LegacyContext, DateTime, IEnumerable <T> > query) where T : ISiteRecord { Console.WriteLine(typeof(T).ToString()); SiteMigrator <T> migrator = Container.Resolve <SiteMigrator <T> >(); migrator.MigrateSite(); DateTime last = SiteService.GetLastTimestamp(migrator.Number); if (last != DateTime.MinValue) { last -= new TimeSpan(0, 2, 0, 0); } IEnumerable <T> legacyData; using (var legacyContext = new LegacyContext()) { legacyData = query(legacyContext, last).ToList(); } return(Task.Run(() => { foreach (var l in legacyData) { using (var context = new NewContext()) { context.Configuration.AutoDetectChangesEnabled = false; migrator.MigrateLogs(context, l); context.ChangeTracker.DetectChanges(); context.SaveChanges(); } } })); }
static void Main(string[] args) { Context db = new Context(); Console.WriteLine(db.Database.CanConnect()); NewContext db2 = new NewContext(); Messurement current = new Messurement(); Stopwatch watch = new Stopwatch(); watch.Start(); List <User> users2 = db.Users.Include("Contents.Entries").Include("Contents").Include("Contents").ToList(); List <User> user3 = db2.Users.ToList(); db2.Users.RemoveRange(user3.Take(2)); db2.SaveChanges(); db.Users.RemoveRange(db.Users.Skip(40)); db.SaveChanges(); List <User> users = db.Users.Include(x => x.Contents).ThenInclude(x => x.Entries).Include(x => x.Settings).ToList(); //db.Users.Include(x => x.Contents).Include(x => x.Settings).ToList(); List <Content> contents = db.Contents.Include(x => x.User).ToList(); watch.Stop(); current.TimeRead = watch.Elapsed; current.EntryCount = users.Count + contents.Count; Console.WriteLine((users.Count + contents.Count) + " Werte in " + watch.ElapsedMilliseconds + " ms gelesen"); watch.Restart(); User us = new User() { Name = "Morris Janatzek", Username = "", Type = User.UserType.Manager, Test = 2 }; db.Users.Add(us); User us3 = new User() { Name = "Morris Janatzek", Username = "" }; db2.Users.Add(us3); db2.SaveChanges(); db.SaveChanges(); db.Users.Remove(db.Users.FirstOrDefault()); db.SaveChanges(); Content c = new Content() { Text = "Test", UserId = us.Id }; db.Contents.Add(c); db.ContentEntries.Add(new ContentEntry() { Text = "das ist in set", ContentId = c.Id }); db.Users.Add(new User() { Username = "******", Name = "Test Test" }); db.Users.Add(new User() { Username = "******", Name = "Test Test 2" }); db.Users.Add(new User() { Username = "******", Name = "Test Test 3" }); db.SaveChanges(); watch.Stop(); current.TimeWrite = watch.Elapsed; Console.WriteLine("Werte in " + watch.ElapsedMilliseconds + " ms geschrieben"); db.Messurements.Add(current); db.SaveChanges(); db.Generics.Add(new GenericTest <int>() { Value = 1 }); db.Generics.Add(new GenericTest <int>() { Value = 2 }); db.SaveChanges(); Console.WriteLine(db.Generics.Count()); while (true) { string result = Console.ReadLine(); if (result != "q") { db.Users.Add(new User() { Username = "******", Name = "Test User" }); db.SaveChanges(); continue; } break; } Context db3 = new Context(); Context db4 = new Context(); List <User> users3 = db3.Users.ToList(); db4.Users.Add(new User() { Name = "Morris Janatzek", Username = "******" }); db4.SaveChanges(); users3 = db3.Users.ToList(); Console.WriteLine(db.Users.Count()); db.Users.Add(new User() { Name = "Test", Username = "******" }); db.SaveChanges(); Console.WriteLine(db.Users.Count()); Console.ReadKey(); }
public ActionResult Create(Order ord) { objContext.Orders.Add(ord); objContext.SaveChanges(); return(RedirectToAction("Index")); }