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