using Microsoft.EntityFrameworkCore;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

namespace WebApplication2

{

    public class DataDBContext : DbContext

    {

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            optionsBuilder.UseOracle(@"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.10.113)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));Persist Security Info=True;User ID=zhzepp;Password=citms", b => b.UseOracleSQLCompatibility(""));

        }

        public DbSet<ASSETSEntity> OrderInfos { get; set; }//实体

       static public void test()

        {

            using (var db = new DataDBContext())

            {

                var count = db.OrderInfos.Where(x => x.ASSETSID != null).ToList();

            }

        }

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

using System.Threading.Tasks;

namespace WebApplication2

{

    [Table("ASSETS")]

    public class ASSETSEntity

    {

        /// <summary>

        /// 主键

        /// </summary>

        [Key]

        public string ASSETSID { get; set; }

        /// <summary>

        /// TAGS

        /// </summary>

        [Column("TAGS"), MaxLength()]

        public string TAGS { get; set; }

    }

}