LINQ 2 Entities , howto check DateTime.HasValue within the linq query

Posted by Snoop Dogg on Stack Overflow See other posts from Stack Overflow or by Snoop Dogg
Published on 2010-05-03T10:45:16Z Indexed on 2010/05/03 10:48 UTC
Read the original article Hit count: 825

Filed under:

linq-to-entities

|

nullable

Hi all ... I have this method that is supposed to get the latest messages posted, from the Table (& EntitySet) called ENTRY

///method gets "days" as parameter, used in new TimeSpan(days,0,0,0);!!

using (Entities db = new Entities())
    {
        var entries = from ent in db.ENTRY
                      where ent.DATECREATE.Value > DateTime.Today.Subtract(new TimeSpan(days, 0, 0, 0))
                      select new ForumEntryGridView()
                      {
                          id = ent.id,
                          baslik = ent.header,
                          tarih = ent.entrydate.Value,
                          membername = ent.Member.ToString()
                      };
        return entries.ToList<ForumEntryGridView>();
    }

Here the DATECREATED is Nullable in the database. I cant place "if"s in this query ... any way to check for that? Thx in advance

© Stack Overflow or respective owner

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LiNQ to Entities, Include less

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this: var temp = from p in myEntities.ClassA.Include("ClassB") where ... select p; You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case… >>> More
Linq to Entities : using ToLower() on NText fields

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using SQL Server 2005, with a case sensitive database.. In a search function, I need to create a Linq To Entities (L2E) query with a "where" clause that compare several strings with the data in the database with these rules : The comparison is a "Contains" mode, not strict compare : easy as… >>> More
deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LINQ To Entities - Items, ItemCategories & Tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags. I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often. I currently… >>> More

Related posts about nullable

Nullable Type implementation without nullable feature of C#

as seen on Stack Overflow - Search for 'Stack Overflow'
How can we implement a nullable type in C# if we didn't have this feature in C#? >>> More
Nullable Enum nullable type question

as seen on Stack Overflow - Search for 'Stack Overflow'
I get the following compilation error with the following source code: Compilation Error: Type of conditional expression cannot be determined because there is no implicit conversion between '' and 'MyEnum' Source Code public enum MyEnum { Value1, Value2, Value3 } public class MyClass { … >>> More
Order by nullable property simultaneously with ordering by not nullable property in HQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a table called Users in my database. Let's assume that User has only 3 properties int ID; string? Name; string Login; If user doesn't specify his name then Login is displayed. Otherwise Name is displayed. I wan't to get list of all users sorted by what is displayed. So if user specified… >>> More
Nullable ToString()

as seen on Stack Overflow - Search for 'Stack Overflow'
I see everywhere constructions like: int? myVar = null; string test = myVar.HasValue ? myVar.Value.ToString() : string.Empty; Why not use simply: string test = myVar.ToString(); Isn't that exactly the same ? At least Reflector says that: public override string ToString() { if (!this… >>> More
LINQ-to-SQL IN/Contains() for Nullable<T>

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to generate this SQL statement in LINQ: select * from Foo where Value in ( 1, 2, 3 ) The tricky bit seems to be that Value is a column that allows nulls. The equivalent LINQ code would seem to be: IEnumerable<Foo> foos = MyDataContext.Foos; IEnumerable<int> values = GetMyValues(); var… >>> More