Obtaining a table by the item type in LINQ to SQL

Question

How can you make something like this generic

return from items in _db.Table
    select items;

I would like to do something like this

public class Data<T> ( where T is the model object )

so the Table will change to the value of T

How would this look as a generic class with a save method for instance

Thanks

Answer 1

... _db.GetTable<MyType> ...

Answer 2

In LINQ-to-SQL, the data-context has GetTable<T>():

var table = _db.GetTable<T>();
etc

Answer 3

Adding to Marc Gravell's answer, you could have a generic update method that looks like this:

public void Update(TEntity entity, TEntity original)
{
    using (DataContext context = CreateContext())
    {
        Table<TEntity> table = context.GetTable<TEntity>();

        table.Attach(entity, original);
        context.SubmitChanges();
    }
}