How to request a timestamp in SQL Server 2008 with Linq-to-Entities?

Question

I have a column timestampin SQL Server 2008.

Now I need to query this column using a date that selects from the calendar server management.

We assume that I have a DateTime dt object;

I need to filter this datetime object, which returns all records registered on that date (dt).

   var a = DateTime.Now.ToString();
   var IsDone = from d in _le.diets
                 where d.log_time.Contains(a)
                 select d.done;

_le is a frame object of a private object.

This code has a problem:

Error 3 'bytes []' does not contain the definition of 'Contains' and the best overload of the extension method 'System.Linq.ParallelEnumerable.Contains (System.Linq.ParallelQuery, TSource)' has some invalid arguments f: \ tests \ diet \ diet \ DataTier \ DietMovieRepository.cs 30 32 diet

2 'string', f:\\\\DataTier\DietMovieRepository.cs 30 26

1 'System.Func' 1 f:\tests\diet\diet\DataTier\DietMovieRepository.cs 30 26

4 : 'byte []' 'System.Linq.ParallelQuery' f:\tests\diet\diet\DataTier\DietMovieRepository.cs 30 32

EF, !

UPDATE

EF cs

   public static diet Creatediet(global::System.Int64 id, global::System.Boolean done, global::System.Byte[] log_time)
        {
            diet diet = new diet();
            diet.id = id;
            diet.done = done;
            diet.log_time = log_time;
            return diet;
        }

Answer 1

SQL Server ( " " , "rowversion" ).

" ", . , , :

DateTime start = date.Date, end = start.AddDays(1);

...
where row.log_time >= start && row.log_time < end
...

, , log_time . , , , .

Answer 2

, ? - :

   var a = DateTime.Now;
   var isDone = from d in _le.diets
                 where d.log_time.Date == a.Date
                 select d.done;