Database

public class SqlDataContext : DbContext
{
    private string _connectionString = "";

    public DbSet<UserEntity> Users { get; set; }

    public SqlDataContext()
    {
        // This will be moved to the controller later on
        _connectionString = @"Server=MAROIS_KEVIN_1\SQLEXPRESS;Database=Test1;Trusted_Connection=true;Encrypt=false;";
    }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer(_connectionString, options => options.EnableRetryOnFailure());
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<UserEntity>(entity =>
        {
            /* Users */
            entity.ToTable("Users", "dbo");

            entity.HasKey(e => e.UserId)
                    .HasName("PrimaryKey_UserId");
        });
    }
}

SELECT Orders.OrderId, Orders.ClientId, Orders.OrderTotal, OrderPymts.Terms, (SELECT MAX(OrderPymts.PaymentDate)) AS PaymentDate, OrderPymts.PrevBal, OrderPymts.Payment, OrderPymts.Balance 
					FROM OrderPymts
                    JOIN Orders ON OrderPymts.OrderId = Orders.OrderId 
                    WHERE (Balance >= 0.01)
					ORDER BY Orders.OrderId, PaymentDate

UserEntity? user = dc.Users
                     .Where(x => x.UserName.CompareTo(entity.UserName) == 0)
                     .FirstOrDefault();

Microsoft.Data.SqlClient.SqlException: 'Invalid column name 'FullName'.'

entity.Property(e => e.Notes)
        .HasColumnName("Notes")
        .HasColumnType("varchar");

SELECT 
    commission_summary.project_no,
    commission_summary.EC, 
    commission_summary.TC, 
    CONVERT(CHAR(10), commission_summary.startup_check_date, 120) AS StartDate, 
    CONVERT(CHAR(10), commission_summary.finished_check_date, 120) AS StopDate      
FROM commission_summary
WHERE CAST(commission_summary.startup_check_date AS SMALLDATETIME) >= CAST('2022-01-01 00:00:00' AS SMALLDATETIME)
ORDER BY commission_summary.startup_check_date DESC 

SELECT 
    commission_summary.project_no,
    commission_summary.EC, 
    commission_summary.TC, 
    CONVERT(CHAR(10), commission_summary.startup_check_date, 120) AS StartDate, 
    CONVERT(CHAR(10), commission_summary.finished_check_date, 120) AS StopDate,
    project.Status, 
    project.Sales_no,
    project.swan_job, 
    employee.Employee_ID, 
    employee.FName, 
    employee.LName, 
    customer.Customer_no, customer.LName, 
    customer.FName, 
    customer.City 
FROM commission_summary 
JOIN project on commission_summary.project_no = project.project_no 
JOIN employee on commission_summary.employee_id = employee.Employee_Id 
JOIN customer on customer.Customer_No = project.Customer_no 
WHERE CAST(commission_summary.startup_check_date AS SMALLDATETIME) >= CAST('2022-01-01 00:00:00' AS SMALLDATETIME)
AND project.status = 'construction' OR project.status = 'finished' 
ORDER BY commission_summary.startup_check_date DESC 

SELECT 
commission_summary.project_no, 
commission_summary.EC, 
commission_summary.TC, 
CONVERT(CHAR(10), 
commission_summary.startup_check_date, 120) AS StartDate, 
CONVERT(CHAR(10), commission_summary.finished_check_date, 120) AS StopDate, 
project.Status, 
project.Sales_no, 
project.swan_job, 
employee.Employee_ID, 
employee.FName, 
employee.LName, 
customer.Customer_no, 
customer.LName, 
customer.FName, 
customer.City 
FROM commission_summary 
JOIN project on commission_summary.project_no = project.project_no 
JOIN employee on commission_summary.employee_id = employee.Employee_Id 
JOIN customer on customer.Customer_No = project.Customer_no 
WHERE (CAST(commission_summary.startup_check_date AS SMALLDATETIME) >= CAST('2022-01-01 00:00:00' AS SMALLDATETIME)) 
AND project.status = 'construction' OR project.status = 'finished' 
AND commission_summary.employee_id = '91' 
ORDER BY commission_summary.startup_check_date DESC