Browse by Tags

• C# 3.0
• Document Library
• Enterprise Search
• LINQ to DataSet
• LINQ to SQL
• LINQ to XML
• MOSS
• SharePoint

• Select Where In with LINQ

  I can't talk about SharePoint all the time, so I thought I would talk about how to perform a type of query with LINQ. In T-SQL you might have wrote something like this at one point. SELECT Title, Id FROM Table1 WHERE Id IN (SELECT Id FROM Table2)... Posted Jul 01 2008, 05:14 PM by CoreyRoth with | with 2 comment(s) Filed under: LINQ

• Checking for empty EnumerableRowCollections when using LINQ

  After you query something with LINQ, you may want to know if any results were returned before your start enumerating or working with the EnumerableRowCollection (that's most likely the type behind that var you are using in most cases). Consider the... Posted Apr 24 2008, 10:18 AM by CoreyRoth with | with no comments Filed under: LINQ, C# 3.0

• How to: Use the Group Clause in LINQ

  As you know, LINQ is similar in a lot of ways to T-SQL, but as you go to start doing things with grouping or joining, you will find that that there are some syntactical differences. There are two ways you can use the group clause in LINQ, which way you... Posted Mar 26 2008, 09:29 AM by CoreyRoth with | with 1 comment(s) Filed under: LINQ, LINQ to DataSet

• Using LINQ to make Enterprise Search Results more usable

  In my previous post about using the KeywordQuery class, I had one small omission. The fact is that when you add your own managed properties using the SelectProperties collection of the keyword class, the data type you get back is a string[] containing... Posted Mar 25 2008, 09:58 AM by CoreyRoth with | with no comments Filed under: SharePoint, LINQ, MOSS, Enterprise Search

• LINQ to SQL Logging

  The other day I was reading Charlie Calvert's excellent post on LINQ and Deferred Execution and stumbled upon a logging feature inside LINQ to SQL. By setting the Log property to a TextWriter (in this case Console.Out), LINQ to SQL will log the query... Posted Feb 21 2008, 09:24 AM by CoreyRoth with | with no comments Filed under: LINQ, LINQ to SQL

• Making DataSets tolerable using LINQ to DataSet

  Unfortunately, most of us aren't working in a perfect world, so it is bound to happen that you run into a dataset or two. Whatever the reason (the developer was lazy, you're maintaining legacy code, someone didn't know any better, or you're... Posted Feb 18 2008, 10:01 AM by CoreyRoth with | with 1 comment(s) Filed under: LINQ, C# 3.0, LINQ to DataSet

• How I used LINQ to XML to Create Document Library Folders

  I have been doing a lot of document library work lately and in my work I had a need to create a series of subfolders in the document library using a particular custom content type. This meant I was going to need to write a little code. I decided to keep... Posted Jan 17 2008, 05:29 PM by C-Dog's .NET Tip of the Day Filed under: SharePoint, LINQ to XML, Document Library, LINQ