Question

Work with db AdventureWork2012, how could I work with table SalesOrderHeader which have scheme Sales: [Sales].[SalesOrderHeader]

[TableMapping("Sales.SalesOrderHeader")] 
[HierarchyRoot]
    public class SalesOrderHeader : Entity
    {
        [Key]
        [Field]
        public int SalesOrderID { get; private set; }

        [Field]
        public int BillToAddressID { get; set; }

        public SalesOrderHeader(Session session, int salesorderid) :
            base(session, salesorderid)
        { }

    }

Answer 1

Hello IlyaIlyaIlyaIlya

You can't actually work with AdventureWorks2012 database because of some custom types like Name, Phone, OrderNumber and others. They can't be recognized by DataObjects.Net.

AdventureWorks2012 database uses database first approach - design database structure and then try to create some classes to work with tables somehow. DataObjects.Net uses another way of developing databases - code first. Thanks to it there is no need to think in database-related terms like tables, columns and so on. It allows to think in OOP way - just describe what types and relations between them you would like to have and DataObjects.Net will create all needed tables, columns, indexes and so on according to your classes.

If you have some other questions please welcome, I will answer them too.

Subscription:

Related questions