No announcements
Found 2284044 threads
-
0 VotesLINQ Error When using DefaultIfEmpty
I am trying to pull down the NULLS of the contacts and I am using DefaultIfEmpty toAnswered | 4 Replies | 8551 Views | Created by CrazyeD1583 - Saturday, August 27, 2011 1:59 AM | Last reply by JonM3 - Monday, June 29, 2015 10:54 PM
-
0 Votes
Query Result and DefaultIfEmpty
The only 'default' that L2S supports in translation to SQL is the default default (null/nothing). You get this default default by using the overload of DefaultIfEmpty that has ...Answered | 2 Replies | 5907 Views | Created by AdrianParker - Monday, October 27, 2008 6:13 PM | Last reply by Matt Warren - MSFT - Monday, October 27, 2008 10:05 PM -
0 Votes
DefaultIfEmpty and counts
r.TaskId == t.TaskIdAnswered | 2 Replies | 4685 Views | Created by michaelloveusa - Tuesday, April 13, 2010 5:34 PM | Last reply by michaelloveusa - Thursday, April 15, 2010 4:23 AM -
0 Votes
DefaultIfEmpty Returns Empty Date.
Fred Thanks for the code, but it doesn't work for me. Yes, I'm using LinqToSQL. I still get 1/1/0001 using your AsEnumerable. Apparently ...Answered | 6 Replies | 2506 Views | Created by DallasSteve - Wednesday, December 11, 2013 7:30 PM | Last reply by Brian Bu - Thursday, December 19, 2013 3:06 PM -
0 Votes
DefaultIfEmpty and SQL joins
DefaultIfEmpty() but just cannot get it to work on 3 tables, the example only had 2 tables. Could someone please try and provide me with the LINQ to do ...Answered | 2 Replies | 4493 Views | Created by Sarel j - Tuesday, May 13, 2008 6:47 PM | Last reply by Sarel j - Monday, May 19, 2008 7:29 PM -
2 Votes
DefaultIfEmpty(), RepeatUntilEmpty()
subscriber... In general I tend now to use Create/CreateWithDisposable() when it feels to be simpler than using the existing operators. I have sent myself many hours ...Discussion | 6 Replies | 6801 Views | Created by Andreas Köpf - Monday, August 2, 2010 5:43 AM | Last reply by Dave Sexton - Tuesday, August 3, 2010 10:52 PM -
0 Votes
Integer? being assigned results of LINQ query .FirstOrDefault - can't get a NULL value? (always 0)
Integer? (I'm using VB) thinking that would allow a nullable integer and I even set it to NOTHING but LINQ still returns 0. I'd really ...Answered | 2 Replies | 11201 Views | Created by Ars_Maxer - Tuesday, May 6, 2008 1:37 PM | Last reply by LINQ_live.com - Tuesday, May 6, 2008 7:03 PM -
0 Votes
Alternative to defaultifempty with this?
new { ... }; The problem is that PaymentListings can be empty. In linq to sql you could use DefaultIfEmpty(), but in ...Answered | 2 Replies | 3951 Views | Created by Adviner - Friday, November 13, 2009 6:47 AM | Last reply by Yichun_Feng - Thursday, November 19, 2009 2:40 AM -
0 Votes
DefaultIfEmpty returning first row in table?
Hi folks Is it right that with a left outer join in a Linq To Entities query that DefaultIfEmpty returns the first row from the joined table when there is ...Answered | 2 Replies | 4172 Views | Created by SterlingCooper - Thursday, February 3, 2011 7:19 PM | Last reply by Michael Sun [MSFT] - Monday, February 7, 2011 7:55 AM -
0 Votes
GroupBy With a DefaultIfEmpty Query
//LINQ to SQL ar result = from entry in yourtable where entryAnswered | 2 Replies | 5205 Views | Created by oufan222 - Monday, August 8, 2011 10:36 PM | Last reply by oufan222 - Wednesday, August 17, 2011 12:52 PM -
0 Votes
DefaultIFEmpty Domain Service
# doesn't work in VB and this particular project has to be completed in VB When I do a function import and link the stored procedure to an entity that has exactly the same ...Unanswered | 3 Replies | 3159 Views | Created by technettePAR - Monday, August 23, 2010 11:53 AM | Last reply by technettePAR - Sunday, August 29, 2010 2:41 AM -
0 Votes
DefaultIfEmpty - Test for empty result set?
Hi Fernando, I tried using test.Count() but not in conjunction with test.First()...does that mean DefaultIfEmpty will always return at least one object but that ...Answered | 4 Replies | 6933 Views | Created by jabberpunch - Tuesday, November 29, 2011 3:27 PM | Last reply by Allen_MSDN - Thursday, December 1, 2011 2:52 AM -
0 Votes
DefaultIfEmpty with join
Hi himo; Below are the two queries you posted with what Linq translated them into T-SQL. The first query I have no issues with the second query by just adding this line to ...Answered | 2 Replies | 5702 Views | Created by himo - Thursday, May 26, 2011 2:57 PM | Last reply by Fernando Soto - MCSD - Thursday, May 26, 2011 5:59 PM -
0 Votes
LINQ - error
Hey guys, I have problem with instalation of LINQ. I'd love to using LINQ but i cant instal it =7 Here is my error: ...Answered | 2 Replies | 4269 Views | Created by mikE____ - Wednesday, June 7, 2006 2:38 PM | Last reply by mikE____ - Wednesday, June 7, 2006 5:48 PM -
0 Votes
LINQ to XML error in vb.net when reading using XDOCUMENT.
You might want to post an XML sample and explain to us which data you want to read out, then we can help with LINQ code to extract it. As for your current code, if the ...Answered | 2 Replies | 5484 Views | Created by Ramanjaneya.N - Thursday, August 4, 2011 8:19 AM | Last reply by Hubery Yuan - Wednesday, August 17, 2011 6:49 AM -
0 Votes
DefaultIfEmpty() and referencing null object.
when looking at a LINQ to SQL query you should not try to think of its execution plan as if it is a LINQ to objects query.Answered | 7 Replies | 9626 Views | Created by Ellis_ - Saturday, December 29, 2007 9:56 AM | Last reply by Ellis_ - Tuesday, January 1, 2008 5:24 AM -
0 Votes
application architecture when using Linq ? plz guide
hello, I am new to Linq. Please guide me what should be architecture of of class libraries using Linq using Linq to Entities or ...Answered | 2 Replies | 4401 Views | Created by Haansi - Friday, April 2, 2010 4:46 AM | Last reply by Friendly Dog II - Saturday, April 3, 2010 12:30 AM -
0 Votes
DefaultIfEmpty changing order of returned items
I noticed a strange thing in one of the queries: if I use a DefaultIfEmpty method on my LINQ query with orderby clausule - it just flips back to no ...Answered | 8 Replies | 3731 Views | Created by Alen Jovic - Friday, July 16, 2010 7:05 PM | Last reply by Alen Jovic - Thursday, July 22, 2010 1:12 PM -
0 Votes
how to set default value in Dictonary by using DefaultIfEmpty in C#
x.CityId, x => x.Name).DefaultIfEmpty(_noRecord).First(); return pair;Answered | 3 Replies | 2906 Views | Created by santosh jha - Saturday, March 29, 2014 9:37 AM | Last reply by Magnus (MM8) - Saturday, March 29, 2014 2:29 PM -
0 Votes
Error when exposing LINQ to SQL entities
Are there any plans to provide an implementation of IUpdatable for LINQ-to-SQL?Answered | 2 Replies | 4303 Views | Created by Andy Stephens - Tuesday, September 23, 2008 1:10 PM | Last reply by Matt___B - Thursday, September 25, 2008 2:27 PM - Items 1 to 20 of 2284044 Next ›
No announcements
