No announcements
Found 2891423 threads
-
0 VotesOptimization / Linq to SQL / First & Count
, where there is one record only). The above are much faster than .First() and .Count(). The replies to the question seem to indicate that ...Answered | 9 Replies | 7241 Views | Created by Alex Barimo - Thursday, April 22, 2010 6:41 PM | Last reply by Alex Barimo - Friday, April 30, 2010 5:48 PM
-
0 Votes
Get Linq to SQL count
; }; db.Orders.InsertOnSubmit(order); db.SubmitChanges(); count = ...Answered | 1 Replies | 885 Views | Created by Pure Deal - Monday, November 25, 2013 9:19 PM | Last reply by Fred Bao - Tuesday, November 26, 2013 9:22 AM -
0 Votes
linq to sql count error
I have the following linq to sql statement that I want to use in a C# 2008 application that connects to a sql server 2008 r2 ...Answered | 1 Replies | 2083 Views | Created by wendy elizabeth - Friday, October 5, 2012 3:39 AM | Last reply by Michael Samteladze - Friday, October 5, 2012 8:31 AM -
0 Votes
Linq to objects - query optimization
I have a linq query with an orderby. I'm expecting linq to optimize the code, so the orderby descending and the a call to First() are optimized against ...Answered | 1 Replies | 4466 Views | Created by georgepolevoy - Sunday, November 23, 2008 6:18 PM | Last reply by David Buchanan - Wednesday, November 26, 2008 7:21 PM -
0 Votes
Using LINQ to first TAKE and then COUNT
500 or or the first 100 records and count records > 500? Also please post the schema ofAnswered | 1 Replies | 4693 Views | Created by ImaNewbee - Saturday, March 19, 2011 2:34 AM | Last reply by Fernando Soto - MCSD - Saturday, March 19, 2011 3:05 AM -
0 Votes
Count == 1 optimization?
You don't ~need~ to do that, as running it in parallel should give you the same behavior, with a slight overhead cost. There are some optimizations in PLINQ that will force sequential ...Answered | 1 Replies | 4675 Views | Created by John P. Cronan - Thursday, July 22, 2010 3:34 PM | Last reply by Reed Copsey, Jr - Thursday, July 22, 2010 4:39 PM -
0 Votes
LINQ Query Optimization
What error do you get when you remove .AsEnumerable()? I would expect it to work - it translates to the following SQL: WHERE ...Answered | 6 Replies | 7058 Views | Created by KevinBurton - Thursday, July 2, 2009 2:22 PM | Last reply by KevinBurton - Thursday, July 2, 2009 2:46 PM -
0 Votes
linq to sql using a count statment
i would like to know how to use a count statement that you would use in a standard sql statement. Can you tell me how to modify or use a different example ...Answered | 1 Replies | 2571 Views | Created by jazz_dog - Sunday, September 9, 2012 8:06 PM | Last reply by sqlguy - Sunday, September 9, 2012 9:40 PM -
1 Votes
SQL Optimization
The following article deals with optimization: http://www.sqlusa.com/articles/query-optimization/ You have to makeAnswered | 2 Replies | 2487 Views | Created by SQL Person - Thursday, March 22, 2012 6:04 AM | Last reply by Shamas Saeed - Thursday, March 22, 2012 7:35 AM -
0 Votes
Azure SQL Data Sync, LINQ optimization bug
Ok ... sorry for wasting your time... it does seem to be a Entity Framework Extended problem, which is not able to cope with the optimized LINQ Query.Answered | 2 Replies | 2119 Views | Created by Marcel Buesing - Wednesday, October 15, 2014 12:21 PM | Last reply by Marcel Buesing - Wednesday, October 15, 2014 4:06 PM -
0 Votes
linq optimization and dataloadoptions
shared some of my ideas about using stored procedures to load the relationships in LINQ to SQL,Answered | 7 Replies | 4571 Views | Created by magmo - Saturday, November 7, 2009 2:05 PM | Last reply by Michael Sun [MSFT] - Monday, November 16, 2009 7:04 AM -
0 Votes
C++ AMP: short vector types optimization
Hi Arnaud, Thanks very much for sharing your kernel. As Daniel explained, in this release, the C++ AMP SVT implementation is not mapped to the HLSL SVT ...Answered | 3 Replies | 5261 Views | Created by Arnaud Faucher - Sunday, February 19, 2012 3:56 PM | Last reply by Zhu, Weirong - Wednesday, February 22, 2012 3:52 AM -
1 Votes
Quick little optimization question for AMP kernel
Hi folks. Does anyone see how the following can possibly be optimized (by replacing the conditional branch with something else)? It's cropping up everywhere in my AMP kernels and I'm ...Answered | 3 Replies | 1698 Views | Created by LKeene - Monday, December 31, 2012 5:25 PM | Last reply by Hystaspes - Monday, December 31, 2012 8:56 PM -
0 Votes
Count rows in LINQ
loginId.me_login_name == this.me_login_name && loginId.me_pkey != this.me_pkey select loginId; I want to count ...Answered | 4 Replies | 3869 Views | Created by Ghanshyam Thakkar - Thursday, October 13, 2011 5:05 AM | Last reply by darnold924 - Thursday, October 13, 2011 12:11 PM -
2 Votes
Performance optimization tips for generic Linq to SQL code
For further concerns, suggest that you post in the LINQ to SQL Forum. Thanks.Leo Liu [MSFT] MSDN Community Support |Answered | 3 Replies | 4971 Views | Created by snkar - Friday, April 29, 2011 5:52 AM | Last reply by Leo Liu - MSFT - Wednesday, May 4, 2011 8:18 AM -
0 Votes
Databinding to the count of a LINQ to SQL result.
You can use Count() in linq querry and SQL Profiler will create select count(*) for you properlyAnswered | 5 Replies | 7487 Views | Created by Joakim Rosendahl - Thursday, August 2, 2007 8:16 PM | Last reply by Jarzi - Tuesday, January 26, 2010 9:03 PM -
0 Votes
Linq Count versus select count(*) from....
If you're using Linq to SQL, then the SQL expression is built from your Linq query. So "select count" would normally result in the ...Answered | 2 Replies | 22372 Views | Created by Okan Sarıca - Monday, January 25, 2010 11:48 AM | Last reply by NET Junkie - Monday, January 25, 2010 2:48 PM -
0 Votes
Is there reference count optimization ?
-- ??? here the question } } As we see DoSome function just make some local action on reference copy of ...Answered | 2 Replies | 3102 Views | Created by NewbTom - Tuesday, October 18, 2011 2:47 PM | Last reply by Karel Zikmund - Thursday, October 20, 2011 1:33 AM -
0 Votes
Linq Query Optimization
Hi All Im using this linq query to retrieve data from an sql server via wcf web service: DataClasses1DataContext db = new ...Answered | 10 Replies | 26418 Views | Created by MSDN_Forums_User - Thursday, January 8, 2009 2:14 PM | Last reply by John J. Hughes II - Sunday, January 11, 2009 2:53 PM -
1 Votes
Count Values from SQL DB Using LINQ 2 SQL
Hi anwar.mustafa, Please refer to the following samples to implement COUNT with GROUP BY in LINQ to SQL: 101 ...Answered | 2 Replies | 4730 Views | Created by anwar.mustafa - Thursday, February 16, 2012 5:22 PM | Last reply by anwar.mustafa - Wednesday, February 22, 2012 3:47 PM - Items 1 to 20 of 2891423 Next ›
No announcements
