Category Archives: LINQ to SQL

SQL CE 3.5 with LINQ to SQL Revisited

Leave a comment
Posted on March 11, 2008 by Matthew

A few days ago I made a post about using SQL CE 3.5 with LINQ to SQL.   I described a way to use connection pooling with SQL CE. A gracious blog reader (Mike Brown)  pointed out a way I could … Continue reading →

Posted in LINQ to SQL, SQL CE | Leave a comment

SQL CE 3.5 with LINQ to SQL

Leave a comment
Posted on March 11, 2008 by Matthew

Using LINQ to SQL with SQL CE 3.5 can be a bit of a challenge.  First off, the LINQ to SQL Visual Studio designer doesn’t support SQL CE so you need to run sqlmetal from the command line to create … Continue reading →

Posted in LINQ to SQL, SQL CE | Leave a comment

Generic Insert and Update for LINQ To SQL

Leave a comment
Posted on March 11, 2008 by Matthew

Quick code snippet time! The following are generic methods for inserting and updating a detached entity into a database using LINQ to SQL. 1: /// <summary> 2: /// Updates the database with item. 3: /// </summary> 4: /// <typeparam name=”T”>Type … Continue reading →

Posted in LINQ to SQL | Leave a comment

Intro to LINQ to SQL Optimistic Concurrency

Leave a comment
Posted on March 11, 2008 by Matthew

After some investigation I feel I have a decent understanding on how LINQ to SQL concurrency works. LINQ to SQL uses optimistic concurrency which means that it never takes an exclusive lock on a table.  It caches the information you … Continue reading →

Posted in LINQ to SQL | Leave a comment