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(); }