No announcements
Found 1724533 threads
-
0 VotesRemove Order By SQL generated statement by .GroupJoin Linq EF
Hi, Could somebody help me to know how use .GroupJoin() without generate the Order By Here is part of the generated ...Unanswered | 4 Replies | 3463 Views | Created by peterposnag - Wednesday, December 12, 2012 3:00 PM | Last reply by SandeepChalke - Monday, January 7, 2013 2:58 PM
-
0 Votes
ORDER BY clause statement
Main use is to order the rows. The standard behavior of a sql select query is to not return rows in a set order without an order by ...Answered | 1 Replies | 799 Views | Created by shah3625 - Sunday, December 29, 2013 5:10 PM | Last reply by Russ Loski - Sunday, December 29, 2013 5:16 PM -
0 Votes
expert order by statement
literals. So it doesn't "know" that it can remove the ORDER BY clause. So it still performs a sort. That is what you can see when you inspect the query ...Answered | 11 Replies | 3134 Views | Created by philliptackett77 - Wednesday, July 13, 2011 11:54 PM | Last reply by Gert-Jan Strik - Thursday, July 14, 2011 9:52 PM -
0 Votes
Order by linq
order by in Linq as parameterised, for the solution. Fernando (MCSD) If a post ...Answered | 4 Replies | 6242 Views | Created by Rushdy Najath - Friday, January 4, 2013 2:02 PM | Last reply by sqlguy - Friday, January 4, 2013 11:19 PM -
0 Votes
how to see sql generated by LINQ
guide me with steps that how to see sql generated by LINQ.Answered | 6 Replies | 526 Views | Created by Mou_kolkata - Tuesday, September 8, 2015 12:41 PM | Last reply by Andy ONeill - Tuesday, September 8, 2015 4:16 PM -
1 Votes
Linq order by Price
Hello there, Is the following possible? I have a linq to SQL query that is returning products ordered by ...Answered | 4 Replies | 3170 Views | Created by Owen Sammut - Friday, May 14, 2010 2:27 PM | Last reply by Owen Sammut - Monday, May 17, 2010 7:52 AM -
0 Votes
Insane SQL Generated by Linq Query
when even a second matters and we could loose a customer's order. Linq to Sql rocked with their query optimization and at times we felt that query generated ...Unanswered | 5 Replies | 4134 Views | Created by RyanLM - Sunday, October 5, 2008 2:48 AM | Last reply by Carl Perry - Tuesday, October 7, 2008 9:37 PM -
0 Votes
I am Use GroupJoin in Linq by EF but generate inner join
outer join. my question is that, why EF Use Association to generate SQL Query, I am not used navigation properties in Linq Query and not see any related ...Answered | 4 Replies | 861 Views | Created by Seyyed Hossein Razzaghi - Monday, December 21, 2015 12:19 PM | Last reply by Matthew LEAN . D - Saturday, December 26, 2015 6:44 AM -
2 Votes
Order by LINQ question
which orders by the class itself (which will be effectively semi-random). You need to order by the specific ...Answered | 6 Replies | 1388 Views | Created by Brian Evans - Monday, January 23, 2012 7:14 PM | Last reply by Brian Evans - Monday, January 23, 2012 8:38 PM -
0 Votes
VB.net Linq Using Variables in Order by Statement
Dynamic LINQ (order by) that what I need . I have read this link httpProposed | 6 Replies | 3847 Views | Created by Ahmadmansoor - Friday, May 18, 2012 1:37 AM | Last reply by Ahmadmansoor - Tuesday, May 22, 2012 8:09 PM -
0 Votes
How to remove some properties generated by EF 5.0
Thanks Chester, your suggestion works for me. I have another question. In my database, I have 2 tables and their relationship is 1-to-1. However, the entity classes ...Answered | 14 Replies | 2386 Views | Created by s liu - Friday, April 26, 2013 9:59 PM | Last reply by Chester Hong - Thursday, May 30, 2013 9:49 PM -
2 Votes
Order By Desc in LINQ
Here is another method that uses lambda for the order by and is another way to write up the statement along with not loading children and not tracking these ...Answered | 4 Replies | 572 Views | Created by Justair07 - Wednesday, August 7, 2019 12:34 PM | Last reply by Justair07 - Wednesday, August 7, 2019 2:17 PM -
0 Votes
Order by.. multiples fields LINQ
Hi maespei, you don't want to order by different columns (that would be a OrderBy with multiple columns). Instead you want to order by ...Answered | 3 Replies | 7260 Views | Created by mj_est - Thursday, December 3, 2009 5:26 AM | Last reply by Dydek - Thursday, December 3, 2009 7:36 AM -
0 Votes
LINQ query order by
var query = from item in ...Answered | 5 Replies | 3164 Views | Created by Shubho_Simple - Thursday, August 2, 2012 6:30 AM | Last reply by Nicolas Castel - Thursday, August 2, 2012 2:54 PM -
5 Votes
LINQ sort by row order
The SQL server doesn't return items in any particular order. The data is stored in hash tables and is multi-threaded so the data does NOT come OUT in ...Answered | 4 Replies | 2495 Views | Created by Corey G DW - Tuesday, September 17, 2013 3:43 PM | Last reply by davidbaxterbrowne - Tuesday, September 17, 2013 6:57 PM -
0 Votes
Linq order list by substring
'strawberry' the result should be: BDW04|Strawberry1 A2kdF|Strawberry2 and not in the reverse ...Answered | 4 Replies | 9540 Views | Created by ysrini - Tuesday, January 14, 2014 5:31 AM | Last reply by Tryndamere.LoL - Wednesday, January 15, 2014 1:31 AM -
0 Votes
custom order by using linq
I am sure I misunderstood the original poster. I thought they wanted to extract those, so you are correct. If he just wanted to order them, could he not just do order by in ...Answered | 10 Replies | 7017 Views | Created by msanjayv - Wednesday, April 10, 2013 6:29 PM | Last reply by PaulLinton - Friday, April 12, 2013 7:00 AM -
1 Votes
PARTITION BY - SQL statement
SELECT * FROM ( SELECT Station.T_Station_Station_Name, Rejects.Name ,ROW_NUMBER() OVER (PARTITION BY Station.T_Station_Station_Name ORDER BYProposed | 4 Replies | 489 Views | Created by DanW90 - Thursday, April 13, 2017 5:26 PM | Last reply by Jonathan Kehayias - Thursday, April 13, 2017 6:54 PM -
1 Votes
linq order by general question
dblListPeakPos _ ' Order By x.dblX _ ' Select x _ ' ).ToList() '========================== ...Answered | 2 Replies | 6392 Views | Created by gofast505 - Thursday, February 4, 2010 8:34 PM | Last reply by jgalley - Thursday, February 4, 2010 9:09 PM -
0 Votes
Linq to EF Paging query with dynamic order by
One option is to create your own OrderBy extension method for the IEnumerable interface where you give the input IEnumerable/IQueryable and then in other parameters the values to create order ...Answered | 3 Replies | 4977 Views | Created by Jitendra Pancholi - Monday, April 16, 2012 7:49 AM | Last reply by Jitendra Pancholi - Monday, April 16, 2012 11:24 AM - Items 1 to 20 of 1724533 Next ›
No announcements
