How to create database in Microsoft SQL Server usi

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.