Database

Code: 1292 SQL State: 22007 --- Incorrect datetime value: '2023-06-31 23:59:00' for column 'date' at row 1

SELECT 
	DATE(`Date`) AS `Date`, 
	COUNT(`Date`) AS `Record count` 
FROM tbl_Pw
WHERE `Date` BETWEEN '2023-01-01 00:00:00' AND '2023-03-31 23:59:00'
GROUP BY DATE(`Date`)
ORDER BY `Date`;

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");