Devart Forums

Code: Select all

[Table(Name = "OBJ$GROUPS")]
    public class Group
    {
        long _No;
        [Column(Name = "NO", Storage = "_No", IsPrimaryKey = true)]
        public long No { get { return _No; } }
    }

Code: Select all

public class Result
    {
        public long No { get; set; }
        public long? TypeNo { get; set; }

    }

Code: Select all

[ProviderAttribute(typeof(Devart.Data.Oracle.Linq.Provider.OracleDataProvider))]
    public class TypeTreeDataContext : DataContext
    {
        public TypeTreeDataContext(OracleConnection conn) : base(conn) { ObjectTrackingEnabled = false; }

        public Table<Group> Group => GetTable<Group>();

    }

Code: Select all

static void Main(string[] args)
{
     OracleConnection conn = new OracleConnection("Pooling=false") { UserId = Login, Password = Password, Server = 					 
                                                                                                                       Server, Direct = false };
     conn.Open();
     
      var data = new TypeTreeDataContext(conn);

            var res= data.Group
                .Where(g => g.No >= 1000000 && g.No <= 1050000)
                .Select(g => new Result{
                    No = g.No,
                    TypeNo = 10                     
                })
                .ToList();
 }