public ICollection <HtmlElements> GetList()
{
using (SqliteModel db = new SqliteModel())
{
return(db.HtmlElements.ToList());
}
}
public HtmlElements GetElement(int id)
{
using (SqliteModel db = new SqliteModel())
{
return(db.HtmlElements.Find(id));
}
}
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;
}
}
}
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();
}
}
}
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();
}
