Select IQueryable rows where datatime is null in the database
up vote
0
down vote
favorite
I have an IQueryable that is supplied data from a SQL connection. There is a DateTime column in this which can contain nulls. I basically need to be able to get all the rows that have a null datetime value but nothing I am trying seems to work.
This is something like my latest attempt but it just simply fails trying to convert the "null" string to a DateTime format:
IQueryable dataByDate = allData.Where("DateTimeColumnName" + " == @0", (dateValueVariableAsString == null) ? "NULL" : dateValueVariableAsString );
If dateValueVariableAsString has a string with of a valid DateTime format then the I do get the results I expect - however I just cant seem to be able to get the rows where the dateColumn has nulls.
c# datetime null iqueryable
asked Nov 19 at 11:22
CJH
320315
add a comment |
up vote
0
down vote
favorite
I have an IQueryable that is supplied data from a SQL connection. There is a DateTime column in this which can contain nulls. I basically need to be able to get all the rows that have a null datetime value but nothing I am trying seems to work.
This is something like my latest attempt but it just simply fails trying to convert the "null" string to a DateTime format:
IQueryable dataByDate = allData.Where("DateTimeColumnName" + " == @0", (dateValueVariableAsString == null) ? "NULL" : dateValueVariableAsString );
If dateValueVariableAsString has a string with of a valid DateTime format then the I do get the results I expect - however I just cant seem to be able to get the rows where the dateColumn has nulls.
c# datetime null iqueryable
asked Nov 19 at 11:22
CJH
320315
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have an IQueryable that is supplied data from a SQL connection. There is a DateTime column in this which can contain nulls. I basically need to be able to get all the rows that have a null datetime value but nothing I am trying seems to work.
This is something like my latest attempt but it just simply fails trying to convert the "null" string to a DateTime format:
IQueryable dataByDate = allData.Where("DateTimeColumnName" + " == @0", (dateValueVariableAsString == null) ? "NULL" : dateValueVariableAsString );
If dateValueVariableAsString has a string with of a valid DateTime format then the I do get the results I expect - however I just cant seem to be able to get the rows where the dateColumn has nulls.
c# datetime null iqueryable
asked Nov 19 at 11:22
CJH
320315
I have an IQueryable that is supplied data from a SQL connection. There is a DateTime column in this which can contain nulls. I basically need to be able to get all the rows that have a null datetime value but nothing I am trying seems to work.
This is something like my latest attempt but it just simply fails trying to convert the "null" string to a DateTime format:
IQueryable dataByDate = allData.Where("DateTimeColumnName" + " == @0", (dateValueVariableAsString == null) ? "NULL" : dateValueVariableAsString );
If dateValueVariableAsString has a string with of a valid DateTime format then the I do get the results I expect - however I just cant seem to be able to get the rows where the dateColumn has nulls.
c# datetime null iqueryable
c# datetime null iqueryable
asked Nov 19 at 11:22
CJH
320315
asked Nov 19 at 11:22
CJH
320315
edited Nov 19 at 14:16
asked Nov 19 at 11:22
CJH
320315
asked Nov 19 at 11:22
CJH
320315
asked Nov 19 at 11:22
CJH
320315
320315
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
I finally got this sorted with the following alteration to my example above:
IQueryable dataByDate = allData.Where("DateTimeColumnName == null", null);
answered Nov 19 at 15:10
CJH
320315
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
I finally got this sorted with the following alteration to my example above:
IQueryable dataByDate = allData.Where("DateTimeColumnName == null", null);
answered Nov 19 at 15:10
CJH
320315
add a comment |
up vote
1
down vote
I finally got this sorted with the following alteration to my example above:
IQueryable dataByDate = allData.Where("DateTimeColumnName == null", null);
answered Nov 19 at 15:10
CJH
320315
add a comment |
up vote
1
down vote
up vote
1
down vote
I finally got this sorted with the following alteration to my example above:
IQueryable dataByDate = allData.Where("DateTimeColumnName == null", null);
answered Nov 19 at 15:10
CJH
320315
I finally got this sorted with the following alteration to my example above:
IQueryable dataByDate = allData.Where("DateTimeColumnName == null", null);
answered Nov 19 at 15:10
CJH
320315
answered Nov 19 at 15:10
CJH
320315
answered Nov 19 at 15:10
CJH
320315
answered Nov 19 at 15:10
CJH
320315
320315
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53373581%2fselect-iqueryable-rows-where-datatime-is-null-in-the-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
