DotNetShoutout - Stories tagged with Linq
6
Shouts

Entity Framework: Queries involving many to many relationship tables « Mehroz’s Experiments

published 1054 days, 19 hours, 21 minutes ago posted by mehrozmehroz 1055 days, 16 hours, 52 minutes ago
Wednesday, June 30, 2010 12:37:34 PM GMT Tuesday, June 29, 2010 3:06:42 PM GMT
Entity framework handles tables participating in Many to Many relationship in a nice manner. If the junction table (sometimes called bridge table, association table, link table, etc) only consists of the foreign keys and no other columns, then that table is abstracted by EF and the two sides get a navigational property exposing a collection of the other side. If the junction table contains other fields as well (e.g. the table has its own primary key column), then that junction table is included in the mo... (more)
category: Architecture | clicked: 2 | comment | | source: smehrozalam.wordpress.com
tags: Query, Linq To SQL, Entity Framework, Linq
7
Shouts

Connected Show #32 - CoApp: Do EPIC Schtuff!

published 1059 days, 21 hours, 49 minutes ago posted by plaudatiplaudati 1060 days, 5 hours, 25 minutes ago
Friday, June 25, 2010 10:09:22 AM GMT Friday, June 25, 2010 2:32:59 AM GMT
In this episode, guest Garrett Serack from the Microsoft Open Source Technology Center joins Peter to discuss CoApp, a new package manager for the Windows platform. Garrett tells us how CoApp will help make it easier for developers and users to build and install open source software on Windows. (Interview starts at 34:15) Also, Dmitry and Peter rap about Windows Phone 7, WCF, Outlook PST files, Visual Studio 2010 Power Tools, and IQueryable killing his cat. (more)
category: Podcast | clicked: 0 | comment | | source: www.connectedshow.com
tags: CoApp, Windows Phone 7, WCF, Linq
7
Shouts

Range Operator in Linq.

published 1060 days, 21 hours, 52 minutes ago posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1062 days, 12 hours, 30 minutes ago
Thursday, June 24, 2010 10:06:19 AM GMT Tuesday, June 22, 2010 7:27:45 PM GMT
Linq is almost providing all the functionalities and i have found one another great operator called range operator which will return a sequence of integer number from start point to number of count. Here is the signature of range operator in Linq. public static IEnumerable (more)
category: Web Dev | clicked: 0 | comment | | source: jalpesh.blogspot.com
tags: Range, Linq
6
Shouts

Compiling LINQ queries for improved performance

published 1060 days, 21 hours, 52 minutes ago posted by deanomachinodeanomachino 1062 days, 15 hours, 47 minutes ago
Thursday, June 24, 2010 10:06:19 AM GMT Tuesday, June 22, 2010 4:11:28 PM GMT
Compiling LINQ queries for improved performance I've been using Linq to Sql for quite a while now, and here and there I have heard of compiling your Linq queries mentioned. Now I know that this feature has been around for a while in terms of .net, but I have never actually got round to using it. I started to look into it and found out that it is actually really easy, and it really does improve the performance of your query. So this is how you would write a standard linq query: But if we wante... (more)
category: Data | clicked: 0 | comment | | source: www.deanhume.com
tags: 3.5, C#, SQL, Performance, Improve Performance, Linq
7
Shouts

Zip operator in Linq with .NET 4.0

published 1062 days, 21 hours, 30 minutes ago posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1065 days, 18 hours, 40 minutes ago
Tuesday, June 22, 2010 10:27:47 AM GMT Saturday, June 19, 2010 1:18:00 PM GMT
Microsoft .NET framework 4.0 is having many features that make developers life very easy. Its also provides some enhancement to Linq also. I just found a great operator called Zip which merge the sequence of two entities. Here is the explanation of Zip Operator from MSDN. “The method merges each element of the first sequence with an element that has the same index in the second sequence. If the sequences do not have the same number of elements, the method merges sequences until it reaches the end of on... (more)
category: Web Dev | clicked: 3 | comment | | source: jalpesh.blogspot.com
tags: C#.NET, Linq, .Net4.0, ASP.NET
4
Shouts

Sum and Concat Operator operators in Linq.

published 1065 days, 19 hours, 11 minutes ago posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1066 days, 11 minutes ago
Saturday, June 19, 2010 12:47:38 PM GMT Saturday, June 19, 2010 7:47:31 AM GMT
Linq contains lots useful operators and i have found more two operators that can be help full in our day to day programming life. Here are explanation. Concat Operator: Concat operator concats two entities into single entities its very use full when we are doing some string operator where need to do string operations like concatenation. Here in example i have taken two arrays and concat into single entity. Sum Operator: When we are developing application like shopping cart and other stuff this operat... (more)
category: Web Dev | clicked: 0 | comment | | source: jalpesh.blogspot.com
tags: Linq, ASP.NET
5
Shouts

Take,Skip and Reverse Operator in Linq

published 1066 days, 18 hours, 24 minutes ago posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1067 days, 1 hour, 28 minutes ago
Friday, June 18, 2010 1:34:10 PM GMT Friday, June 18, 2010 6:30:17 AM GMT
I have found three more new operators in Linq which is use full in day to day programming stuff. Take,Skip and Reverse. Here are explanation of operators how it works. Take Operator: Take operator will return first N number of element from entities. Skip Operator: Skip operator will skip N number of element from entities and then return remaining elements as a result. Reverse Operator: As name suggest it will reverse order of elements of entities. Here is the examples of operators where i have taken ... (more)
category: Web Dev | clicked: 0 | comment | | source: jalpesh.blogspot.com
tags: C#.NET, Linq, ORM, ASP.NET
5
Shouts

Union,Except and Intersect operator in Linq

published 1066 days, 18 hours, 24 minutes ago posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1067 days, 11 hours, 47 minutes ago
Friday, June 18, 2010 1:34:10 PM GMT Thursday, June 17, 2010 8:11:13 PM GMT
While developing a windows service using Linq-To-SQL i was in need of something that will intersect the two list and return a list with the result. After searching on net i have found three great use full operators in Linq Union,Except and Intersect. Here are explanation of each operator. Union Operator: Union operator will combine elements of both entity and return result as third new entities. Except Operator: Except operator will remove elements of first entities which elements are there in second e... (more)
category: Web Dev | clicked: 0 | comment | | source: jalpesh.blogspot.com
tags: C#.NET, Linq, ASP.NET
5
Shouts

Silverlight Tip: Using LINQ to Select the Largest Available Webcam Resolution - Pete Brown

published 1068 days, 21 hours, 15 minutes ago posted by jantujantu 1069 days, 18 hours, 29 minutes ago
Wednesday, June 16, 2010 10:42:58 AM GMT Tuesday, June 15, 2010 1:29:31 PM GMT
Sometimes in Silverlight, you just want to get the largest possible webcam resolution. This snippet shows how to obtain that using LINQ. view sourceThat will pick the format with the highest total pixel count. You can modify the statement to pick just the largest width, or the largest size that will fit within a given box, etc. (more)
category: Metro | clicked: 0 | comment | | source: 10rem.net
tags: .NET, Silverlight, Linq
8
Shouts

Using LINQPad to Query Stack Overflow - Nick Berardi's Coder Journal

published 1070 days, 21 hours, 20 minutes ago posted by http://www.managedfusion.com/http://www.managedfusion.com/ 1071 days, 8 hours, 54 minutes ago
Monday, June 14, 2010 10:38:05 AM GMT Sunday, June 13, 2010 11:03:50 PM GMT
In case you haven’t read, Stack Overflow and the rest of the Stack Exchange sites are now able to be queried using OData.  This is great because as Jeff points out in the blog post: …if you just want to play with the data, it’s kind of tedious: you have to download the entire 700 plus megabyte archive, import it into some kind of database system — and only then can you even begin thinking about how to query out the results you’re looking for. This hurdle has stopped me from performing some basic querie... (more)
category: Web Dev | clicked: 5 | comment | | source: coderjournal.com
tags: LinqPad, Stackoverflow; Stack Exchange, Linq, OData
7
Shouts

Understanding LINQ to SQL (10) Implementing LINQ to SQL Provider - Dixin's Blog

published 1073 days, 21 hours, 39 minutes ago posted by jrspinellajrspinella 1074 days, 15 hours, 38 minutes ago
Friday, June 11, 2010 10:18:48 AM GMT Thursday, June 10, 2010 4:20:20 PM GMT
[LINQ via C# series] So far LINQ to SQL data CRUD (Creating / Retrieving / Updating / Deleting) has been explained. This post takes a deeper look at the internal implementation of LINQ to SQL query.The provider model Unlike IEnumerable / IEnumerable (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: SQL, Linq
5
Shouts

Building a Dynamic LINQ to Entities Compiler (Part 2)

published 1074 days, 23 hours, 1 minute ago posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1075 days, 15 hours, 59 minutes ago
Thursday, June 10, 2010 8:56:59 AM GMT Wednesday, June 09, 2010 3:58:50 PM GMT
In this article I will continue to explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the Ado.net Entity Framework.  See part 1 of building a dynamic linq to entities compiler for background information. This part of the series will cover using the .Net CodeDom Compiler to dynamically execute LINQ queries against an EF model. We are working on a dynamic LINQ query mechanism for the next major release of VistaDB.  Our goal is to provide a dynamic LINQ executi... (more)
category: Data | clicked: 9 | comment | | source: infinitecodex.com
tags: LinqPad, Entity Framework, VistaDB, Linq
5
Shouts

Building a Dynamic LINQ to Entities Compiler (Part 1)

posted by http://vistadb.myopenid.com/http://vistadb.myopenid.com/ 1077 days, 2 hours, 6 minutes ago
Tuesday, June 08, 2010 5:52:07 AM GMT
In this article I will explain how to build a dynamic LINQ to Entities compiler for any database provider that supports the Ado.net Entity Framework. Due to the wide range of technologies used this article, it will be broken up into two parts as listed below. We are working on a dynamic linq query mechanism for the next major release of VistaDB.  Our goal is to provide a LinqPad type of environment in Data Builder for users to write LINQ queries against the database without having to first build an EF m... (more)
category: Data | clicked: 0 | comment | | source: infinitecodex.com
tags: SQL Server, Entity Framework, VistaDB, SQL, Linq
3
Shouts

Adding schemaLocation attribute to XElement in LINQ to XML

posted by viperguynazviperguynaz 1078 days, 12 hours, 16 minutes ago
Sunday, June 06, 2010 7:42:31 PM GMT
Developer Ramblings in C# .NET Development Tips from Falcon Web Technologies Home Archive ContactLog inHome » .NET | WindowsAdding schemaLocation attribute to XElement in LINQ to XML3. June 2010by viperguynaz0 Comments The MSDN library has a good section on working with XML Namespaces in LINQ to XML. XML names are definitely a source of complexity in XML programming. An XML name consists of an XML namespace (also called ... (more)
category: Web Dev | clicked: 2 | comment | | source: falconwebtech.com
tags: XML, Linq
5
Shouts

Understanding LINQ to SQL (7) Data Changing - Dixin's Blog

published 1084 days, 21 hours, 18 minutes ago posted by rajuraju 1086 days, 15 hours, 31 minutes ago
Monday, May 31, 2010 10:39:44 AM GMT Saturday, May 29, 2010 4:27:01 PM GMT
[LINQ via C# series] After understanding how to retrieve data with LINQ to SQL, now take a look at data change (create (insert) / update / delete).Object Identity When changing data queried by LINQ to SQL, one common confusion for LINQ to SQL beginners is the object identity. Identity of entity objects The models working in LINQ to SQL are mappings of SQL Server database stuff, like one .NET entity object in the mummery is the mapping of one record in the database table, etc. Generally speaking, withi... (more)
category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net
tags: .NET, Linq To SQL, C#, LINQ via C# Series, TSQL, Visual Studio, Linq
5
Shouts

LINQ: Where are my extension methods? « Mehroz’s Experiments

published 1089 days, 21 hours, 39 minutes ago posted by mehrozmehroz 1090 days, 17 hours, 17 minutes ago
Wednesday, May 26, 2010 10:18:44 AM GMT Tuesday, May 25, 2010 2:40:53 PM GMT
The powerful Extension Methods due to LINQ have made our development really simple and easy. However in some cases these methods are not available. This post will list a few such scenarios and will describe how to get those extension methods by converting IEnumerable to IEnumerable<T>. (more)
category: How To | clicked: 1 | comment | | source: smehrozalam.wordpress.com
tags: IEnumerable, Cast, extension method, oftype, Linq
2
Shouts

Portland CodeCamp Downloads: Demos and Slides

posted by http://mkennedy66996693.myopenid.com/http://mkennedy66996693.myopenid.com/ 1091 days, 13 hours, 35 minutes ago
Monday, May 24, 2010 6:22:52 PM GMT
Thanks to everyone who came to my two sessions at the Portland CodeCamp this weekend. The NoSQL Movement, LINQ, and MongoDB - Oh My! Panel Discussion: NoSQL vs. RDBMS You can download the slides, demo code, and the mongoctx code snippet for Visual Studio here: NoSQL + MongoDB + LINQ: http://www.michaelckennedy.com/Talks/Downloads/PortlandCodeCamp/Kennedy-PdxCodeCamp-2010-MongoDB-NoRM-LINQ.zip NoSQL vs. RDBMS Panel: http://www.michaelckennedy.com/Talks/Downloads/PortlandCodeCamp/Kennedy-PdxCo... (more)
category: Architecture | clicked: 2 | comment | | source: www.michaelckennedy.net
tags: CodeCamp, WebCast, MongoDB, Linq, DevelopMentor, NoSQL
7
Shouts

Responsible Extension Methods

published 1095 days, 20 hours, 23 minutes ago posted by KodefuGuruKodefuGuru 1096 days, 18 hours, 5 minutes ago
Thursday, May 20, 2010 11:35:34 AM GMT Wednesday, May 19, 2010 1:53:03 PM GMT
In LINQ is Better Than ForEach, I described how to use the reduce chain refactoring to better describe the functionality of the code. By encapsulating what we were doing, the calling code became more declarative, and the the functionality was more reusable. This didn’t sit well with one reader (more)
category: Agile | clicked: 0 | comment | | source: www.kodefuguru.com
tags: Extension Methods, CSharp, Linq
4
Shouts

How to: Show Twitter search and status updates with C# and Linq2XML

published 1096 days, 18 hours, 35 minutes ago posted by jphellemonsjphellemons 1097 days, 21 hours, 57 minutes ago
Wednesday, May 19, 2010 1:22:43 PM GMT Tuesday, May 18, 2010 10:01:27 AM GMT
shows you how to display a twitter search result set and a post overview of a twitter member with linq2xml the linq results can be bind to a datalist or something :) (more)
category: Web Dev | clicked: 0 | comment | | source: www.jphellemons.nl
tags: C#. linq to xml, Linq, Twitter
12
Shouts

IQueryable Can Kill Your Dog, Steal Your Wife, Kill Your Will To Live, etc. – weirdlover - I make love to asp.net mvc, c#, vb, legos, ladies, etc.

published 1099 days, 18 hours, 29 minutes ago posted by evannevann 1103 days, 4 hours, 53 minutes ago
Sunday, May 16, 2010 1:29:28 PM GMT Thursday, May 13, 2010 3:04:48 AM GMT
If you take a quick detour over to StackOverflow, you’ll realize very, very quickly that, when it comes to wholly and full-heartedly screwing up your Linq to SQL statements, the screw-up almost always involves a... (more)
category: Web Dev | clicked: 6 | comment | | source: www.weirdlover.com
tags: IQueryable Linq C# .Net3.5, Linq, MVC