LINQ - Loading Database file in C#
Using LINQ, database file can be loaded and queried.

Example: 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Xml.Linq;
using System.Text.RegularExpressions;

namespace ForgetCode
{
    class IntroToLINQ
    {
        static void Main()
        {
            database db = new database(@"c:\northwnd.mdf");

            // Query for customers in London.
            IQueryable<Customer> custQuery =
                from cust in db.Customers
                where cust.City == "London"
                select cust;
        }
    }
}


Here, the customers table is taken in the database 'database'.