get date part only from datetime value using entity framework

28,544

With entity framework 6 and update use

context.tblvalue.Any(x => DbFunctions.TruncateTime(x.date) == data.Date);
Share:
28,544
Safeena
Author by

Safeena

Updated on October 26, 2020

Comments

  • Safeena
    Safeena over 3 years

    I want to get date part only from database 'date time' value I m using the below code..but it is getting date and time part.

    using (FEntities context = new FEntities())
    {
        DateTime date = DateTime.Now;
        if (context.tblvalue.Any(x => x.date == date))
        {    
        }
    }