Esempio n. 1
0
        public void Create(ICollection <HtmlElements> items)
        {
            using (SqliteModel db = new SqliteModel())
            {
                //db.HtmlElements.AddRange(items);
                //db.SaveChanges();

                //foreach (var item in items)
                //{
                //    db.HtmlElements.Add(item);
                //    db.SaveChanges();
                //}
                try
                {
                    long maxId = 0;

                    var elementWitMaxId = db.HtmlElements.OrderByDescending(u => u.Id).FirstOrDefault();

                    if (elementWitMaxId != null)
                    {
                        maxId = elementWitMaxId.Id;
                    }

                    maxId++;

                    foreach (var item in items)
                    {
                        db.HtmlElements.Add(new HtmlElements()
                        {
                            Id      = maxId++,
                            Url     = item.Url,
                            Html    = item.Html,
                            TypeId  = item.TypeId,
                            Content = item.Content,
                        });
                        db.SaveChanges();
                    }
                }
                catch (DbEntityValidationException e)
                {
                    List <string> list = new List <string>();

                    foreach (var eve in e.EntityValidationErrors)
                    {
                        list.Add(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
                                               eve.Entry.Entity.GetType().Name, eve.Entry.State));
                        foreach (var ve in eve.ValidationErrors)
                        {
                            list.Add(string.Format("- Property: \"{0}\", Error: \"{1}\"",
                                                   ve.PropertyName, ve.ErrorMessage));
                        }
                    }
                    throw;
                }
            }
        }
Esempio n. 2
0
 public void Delete(int id)
 {
     using (SqliteModel db = new SqliteModel())
     {
         var found = db.HtmlElements.Find(id);
         if (found != null)
         {
             db.HtmlElements.Remove(found);
             db.SaveChanges();
         }
     }
 }
Esempio n. 3
0
        static void Main(string[] args)
        {
            var myEntity = new MyEntity {
                Name = "Test Name"
            };

            using (var model = new SqliteModel())
            {
                model.MyEntities.Add(myEntity);
                model.SaveChanges();
                myEntity = model.MyEntities.First();
                Console.WriteLine($"Sqlite Data: myEntity[Id:{myEntity.Id},Name:{myEntity.Name}]");
            }
            using (var model = new SqlServerModel())
            {
                model.MyEntities.Add(myEntity);
                model.SaveChanges();
                myEntity = model.MyEntities.First();
                Console.WriteLine($"SqlServer Data: myEntity[Id:{myEntity.Id},Name:{myEntity.Name}]");
            }
            Console.WriteLine("Test Completed!");
            Console.ReadKey();
        }