Entity Framework prevent insert date between two dates-CodePudding

Home > Software engineering > Entity Framework prevent insert date between two dates

Entity Framework prevent insert date between two dates

Time：01-16

In my project user can select 2 dates startDate and endDate. The selected startDate must be greater than the largest endDate stored in SQL Server:

How can I check this using an Entity Framework Linq statement?

 _context.tableName.where(p => p.startDate >= ??);

CodePudding user response：

Something like this could work for you, adapt it to your needs

if (startDate > _context.tableName.Max(p => p.endDate))

Page link：https//www.codepudding.com/Softwareengineering/673151.html

Prev:How can I change selected textBox in windowsForms app

Next:How to convert base64 mpeg to AudioClip in Unity?

Tags：

c#entity-frameworklinq

Links：
CodePudding