Creating Dynamic Predicates Using Predicate Builder

IQueryable SearchProducts (params string[] keywords)
{
  var predicate = PredicateBuilder.False();

  foreach (string keyword in keywords)
  {
    string temp = keyword;
    predicate = predicate.Or (p => p.Description.Contains (temp));
  }
  return dataContext.Products.Where (predicate);
}

see C# in a Nutshell

SQL Server 2008, Table Valued Parameters, and LINQ

Mike Gleason jr's Blog: SQL 2008 TVP (Table Valued Parameters) and LINQ - It is Possible?! (Sorta)

LINQ Equivalent To A T-SQL IN

SELECT * FROM MemberInfomation WHERE @samAccount IN ('adf','asfd','wqewe')

Similarly you can do a IN like filter in LINQ:

 public List GetInformation(String[] samAccounts)
        {
            SomeDataContextdc = new SomeDataContext();
            return dc.MemberInfomation.Where(
                              o => samAccounts.Contains(o.samaccount)
                                         ).ToList(); 
        }

Got help from here.

Visual Studio 2010 Overview

Visual Studio 2010 and .NET Framework 4 Training Course

Enum, LINQ, and Lookup Tables in C#/SQL Server

Three options:

1. Auto generate ENUM from a lookup table (still have to compile). Here's some helpful links:

• Enum Support With LINQ To SQL And SqlMetal



• Using Enums With LINQ To SQL



• Enum Code Generator

2. Just use a dataset object directly (but is a bit ambiguous when coding).

3. Use something that implements IDictionary. This is not as nice as an Enum, but you get the dynamic benefit and it's not as ambiguous when you code. Here's an example:

//put this in a static class, singleton, abstract class, or whatever fits your need

private SortedList _CriteriaItem;

//get data from database and iterate over the dataset to populate the list
public void Add(object Key, object Value)
{
       _CriteriaItem.Add(Key, Value);
}

public String GetDescriptionByCode(String key)
{
       if (_Item.ContainsKey(key))
       {
              return _Item[key].ToString();
       }

       return "";
}


public String GetCodeByDescriptionBy(String description)
{
       if (_Item.ContainsValue(description))
       {
              foreach (String key in _Item.Keys)
              {
                     if (_Item[key].ToString() == description)
                     {
                            return key.ToString();
                     }
              }
       }

       return "";
}