public void AddCustomer() { using var db = new CARGOContext(new DbContextOptions <CARGOContext>()); //var user = new BASE_USERINFO(); //db.Database.ex //user.USER_ID = }
public void Test1() { using var db = new CARGOContext(new DbContextOptions <CARGOContext>()); var seqName = "BASE_ALLIANCE_SEQ"; var query = string.Format("SELECT {0}.NEXTVAL FROM DUAL", seqName); var result = db.ExecuteScalar <decimal>(query); }
public void TestExecuteSqlQuery() { using var db = new CARGOContext(new DbContextOptions <CARGOContext>()); var seqName = "BASE_ALLIANCE_SEQ"; var query = $"SELECT {seqName}.NEXTVAL AS ID FROM DUAL;"; var result = db.EntityIdentified.FromSqlRaw(query).ToList(); }
public void TestMethod1() { using var db = new CARGOContext(new DbContextOptions <CARGOContext>()); var query = from o in db.BASE_COMPANY where o.DELETE_MARK != 1 select new BaseCompany { CompanyId = o.COMPANY_ID, CompanyNameCN = o.COMPANY_NAME_CN, }; var list = query.Take(10).ToList(); }