Ramco Ramco

Ramco Ramco

  • 475
  • 2.6k
  • 376.5k

How to link Classes

Jul 5 2021 9:31 AM

Hi

  I have 3 tables. How to create Classes & link them . All will be used in 1 View. I am using Ado.Net.

1. OrderHeader

[No] [nvarchar](20) NOT NULL,
    [DocDate] [datetime] NULL,
    [Gross_Amount] [decimal](18, 2) NULL,
    [Tax_Amount] [decimal](18, 2) NULL,
    [Others] [decimal](18, 2) NULL,
    [Net_Amount] [decimal](18, 2) NULL,
    [Status] [nvarchar](3) NULL,

2. OrderLines

[DocumentNo] [nvarchar](20) NOT NULL,
    [ItemCode] [nvarchar](25) NOT NULL,
    [Quantity] [decimal](18, 2) NOT NULL,
    [Uom] [nvarchar](5) NOT NULL,
    [PricePerUnit] [decimal](18, 2) NULL,
    [GrossAmount] [decimal](18, 2) NULL,
    [NetAmount] [decimal](18, 2) NULL

No & DocumentNo are link between the tables. 

3. Item

[Id] [nvarchar](25) NOT NULL,
    [Description] [nvarchar](100) NULL,

Thanks

 


Answers (2)