How to create database in Microsoft SQL Server using linq2db by code first approach in .NET CORE 2.2

Question

Created new project in .net core 2.2 and installed nuget package linq2db.sqlserver using this package i am able to do CRUD with database first approach but i need to know how to do CRUD using code first approach.

Answer 1

Linq2Db has a link https://linq2db.github.io/index.html which provides more information about how to create a POCO and create a table based on it.

As per the page, a simple POCO can go like this:

using System;
using LinqToDB.Mapping;

[Table(Name = "Products")]
public class Product
{
  [PrimaryKey, Identity]
  public int ProductID { get; set; }

  [Column(Name = "ProductName"), NotNull]
  public string Name { get; set; }

  // ... other columns ...
}

Then you need to configure the connection strings.