Overview Quick overview on how to connect to an MS SQL Server database with ASP.NET Core 3.x to 5.x with Entity Frameworks. This post will go over which Nuget Packages are needed and how to connect to an existing database. Visual Studios For ASP.NET Core 3.1 and up you should use Visual Studio 2019 16.11.x.
Overview Short example of how to compare the date and time with Entity Framework query. Also, how to truncate the time from a Date Time value, Compare Time With DateTime.Today() for the date and DateTime.Now() for the time. To filter by todays date and an hour or X minutes in the future or back in
Overview Companies that use Windows Servers (IIS) or Azure cloud service will have Active Directory groups, Most W-2 employees in a company will have an account with their unique user name. Everyone should belong to at least one or more Active Directory groups for access. If your application is deployed behind the company firewall (Intranet)