How to link Classes

Question

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

Sachin Singh · Answer

It depends upon which type of relation do you want b/w classes for example classA has many classB means a class having list of object of another class. Like Department have many employees, so inside DepartmentEmployeeVM you will have a Department property and List of Employee property. Then only you will be able to display All department on a dropdown and respective employees on ddl change.

sara vanan · Answer

Hi, Create a separate Class that includes all the columns and assign the value from using Dataset Or dataReader. Like below Class for wrapper all the table. Public Class OrderWrapperModel { [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, [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 }

How to link Classes

Answers (2)