This example demonstrates how to load description, vendor and type properties from the SQL database using the Entity Framework Core.

• Add-in read the value of PartNo property and looks up the data in the SQL table.
• Add-in writes the values to the corresponding properties

use the script below to create SQL table.

CREATE TABLE [dbo].[Parts](	[Id] [int] IDENTITY(1,1) NOT NULL,	[PartNumber] [varchar](10) NULL,	[Description] [varchar](250) NULL,	[Vendor] [varchar](25) NULL,	[Type] [varchar](50) NULL ) ON [PRIMARY]

Specify the connection string and the part number property as conttants in the

private const string PART_NO_PRP = "PartNo"; private const string SQL_CONNECTION_STRING = "Server=localhost;Database=data;Trusted_Connection=True;";