No announcements
Found 2075977 threads
-
0 VotesFrom SQL syntax into LINQ
I'm sorry. I thought this problem was just a difference in syntax. The SQL one was SELECT TOP 1 <columnName> FROM <database table> ...Unanswered | 5 Replies | 364 Views | Created by MRM256 - Friday, October 19, 2018 6:05 PM | Last reply by Kareninstructor - Saturday, October 20, 2018 12:38 AM
-
0 Votes
LINQ Group By Count in VB
Hi, our group is using Entity Framework and LINQ and are all finding it a little hard to wrap our heads around the LINQ syntax when we're so used to SQL ...Answered | 2 Replies | 759 Views | Created by KimFromPA - Friday, November 6, 2015 12:31 PM | Last reply by Fred Bao - Monday, November 9, 2015 1:34 AM -
0 Votes
Linq to DB: Using Linq as general DB Language
(insert into select from, select into) - TempTables (insert * into #tempTable from custumers) - calling stored procedures - ...Answered | 1 Replies | 4325 Views | Created by Esrever - Tuesday, January 5, 2010 10:26 AM | Last reply by Michael Sun [MSFT] - Thursday, January 7, 2010 9:59 AM -
0 Votes
-
0 Votes
SQL ROW_NUMBER() in LINQ Query Syntax
to return IQueryable Object, I would suggest that you put your SQL statement into SQL view. and retrieve the records from view, like ...Unanswered | 3 Replies | 2305 Views | Created by HGR User - Wednesday, July 13, 2016 9:11 AM | Last reply by Zhanglong Wu - Monday, July 18, 2016 6:08 AM -
0 Votes
is Linq good for reporting ?
NorthwindModel dataModel = new NorthwindModel(); ObjectQuery<Customer> Customers = dataModel.Customers; As you will see, the SQL-like ...Answered | 1 Replies | 2770 Views | Created by sdnd2000 - Thursday, March 29, 2012 1:58 PM | Last reply by Rahul Kumar (Rahul Vairagi) - Thursday, March 29, 2012 2:12 PM -
0 Votes
Help with LINQ query
of to update with other metrics later. My reporting database and this view are brought in as an entity to my project. I need to translate the following SQL into a ...Answered | 2 Replies | 761 Views | Created by UOgod619 - Monday, June 3, 2013 3:44 PM | Last reply by Chester Hong - Tuesday, June 4, 2013 6:37 PM -
1 Votes
Linq to SQL Method syntax
query syntax? No difference in runtime efficiency/performance, it is just language features; query syntax will be turned into the same method calls by the compiler. Query ...Answered | 4 Replies | 6704 Views | Created by crew54 - Thursday, September 9, 2010 8:48 PM | Last reply by KristoferA - Thursday, September 16, 2010 12:53 AM -
1 Votes
How to translate query designer SEQUAL syntax into vb LINQ to SQL
Hello there, I want to convert a piece of SEQUAL code (that was produced from within the query designer built into VB2010 express) into LINQ to SQL ...Answered | 3 Replies | 5663 Views | Created by Paul Anthony Samson - Friday, September 24, 2010 8:17 AM | Last reply by Fernando Soto - MCSD - Saturday, March 5, 2011 9:32 PM -
0 Votes
linq building dynamic tree
-part-1-using-the-linq-dynamic-query-library.aspx And as you mentioned, Linq-to-Sql, is a framework actually. I guess what you think better ...Answered | 3 Replies | 3090 Views | Created by MarcGrenoble - Thursday, August 22, 2013 9:31 AM | Last reply by MarcGrenoble - Thursday, August 29, 2013 1:20 PM -
4 Votes
What is LINQ?
Hello Geof, Thanks for your post. And thanks to Amir and darnold's good explaination. Here is another from Microsoft in MSDN ...Answered | 3 Replies | 3529 Views | Created by Geof MCSD MCSE - Monday, September 19, 2011 6:26 AM | Last reply by Jackie-Sun - Tuesday, September 20, 2011 1:55 AM -
0 Votes
DLINQ/LINQ to SQL Weaknesses
you will end up with 2n SQL select queries. It's nuts. However, if you stick to LINQ to SQL's syntax, this can be made in one query:Answered | 2 Replies | 3152 Views | Created by Parker Hillius - Axvius - Wednesday, December 10, 2008 7:01 PM | Last reply by Parker Hillius - Axvius - Wednesday, December 10, 2008 8:00 PM -
0 Votes
Preprocess Query on a View
Any help would be fab... In my project I have built a SqL view that combines a number tables for an MI report which I have imported into Lightswitch. This new ...Unanswered | 1 Replies | 689 Views | Created by acgt1008 - Monday, March 16, 2015 6:27 PM | Last reply by Thomas Steen - Thursday, March 19, 2015 10:43 PM -
0 Votes
vb sql syntax or linq
Add NewAnswered | 3 Replies | 3264 Views | Created by Frazzle_david - Thursday, January 20, 2011 2:40 AM | Last reply by Frazzle_david - Saturday, January 22, 2011 12:52 PM -
1 Votes
Linq to SQL 3 way join with a sum
the Group By syntax in LINQ would only perform with columns after the Group(in your case, it should be columns in Projects), from your provided sql ...Answered | 2 Replies | 698 Views | Created by Jowalski - Friday, November 28, 2014 8:20 AM | Last reply by Jowalski - Monday, December 1, 2014 6:54 AM -
0 Votes
LINQ syntax in VB.NET
as such. VB programmers are smart enough to catch on and understand a new syntax. There's no reason to keep LINQ syntax simple and "familiar" by making it match ...Answered | 19 Replies | 14160 Views | Created by Klaus Even Enevoldsen DK - Tuesday, November 1, 2005 8:06 AM | Last reply by Fleming Ho - Saturday, February 17, 2007 2:42 AM -
0 Votes
Linq Sql Converter
experiment with differnt Linq syntax and see how it converts to SQL. Hope it helps. Nilay.Answered | 2 Replies | 10684 Views | Created by Mattaniah - Tuesday, November 4, 2008 1:12 PM | Last reply by NS_NET - Tuesday, November 4, 2008 2:29 PM -
0 Votes
LINQ to SQL Class Syntax
LINQ to "request" some data from the object-pool .) the object pools queries the database with the LINQ-Query and checks which of the result ...Unanswered | 4 Replies | 5411 Views | Created by Bernd Podhradsky - Friday, May 30, 2008 3:00 PM | Last reply by Pedro Rainho - Saturday, May 31, 2008 7:54 AM -
0 Votes
Join Order Affects SQL Output for Linq-to-Entity Self-Referencing Group (Left) Joins
JOIN. If the self-referencing LEFT JOIN clause, with the EXACT same syntax, was the LAST Linq Group Join, SQL Profiler reported an LEFT JOIN.Unanswered | 3 Replies | 2845 Views | Created by Ffud - Wednesday, August 1, 2012 4:16 PM | Last reply by Glenn Condron - Thursday, August 2, 2012 8:54 PM -
0 Votes
LINQ syntax
executes fine.If the query works fine in sql then create that as store procedure and call the same inside linq and pass the parameter ...Unanswered | 1 Replies | 4618 Views | Created by Philippe M. Caron - Thursday, November 6, 2008 3:57 PM | Last reply by venziar - Friday, November 7, 2008 6:55 AM - Items 1 to 20 of 2075977 Next ›
No announcements
