public void TestPagination()
{
//UseOracleSQLCompatibility("11");
using var db = new UC2Context(new DbContextOptions <UC2Context>());
var query = from o in db.BASE_LOCATION
orderby o.BASE_LOCATION_ID descending
select o;
var skipQuery = query.Skip(0).Take(10);
var resultQuery = skipQuery.ToList();
}
public void Add()
{
var options = new DbContextOptions <UC2Context>();
using var db = new UC2Context(options);
var query = $"SELECT {Sequences.BASE_LOCATION_SEQ.ToString()}.NEXTVAL AS ID FROM DUAL;";
var id = db.EntityIdentified.FromSqlRaw(query).ToList();
var entity = db.BASE_LOCATION.Where(q => q.BASE_LOCATION_ID == 111).SingleOrDefault();
//var id = db.GetNextVal(Sequences.NAVIGATION_SEQ);
//var entity = new BASE_NAVIGATION();
//entity.NAVIGATION_ID = db.GetNextVal(Sequences.NAVIGATION_SEQ);
//var id = db.ENTITY_IDENTIFY.GetNextVal(Sequences.NAVIGATION_SEQ);
//entity.USER_ID = 0;
//entity.NAVIGATION_NAME = "test";
//entity.NAVIGATE_URL = "urltest";
//db.BASE_NAVIGATION.Add(entity);
//db.SaveChanges();
}
