Category Archives: LINQ to SQL
SQL CE 3.5 with LINQ to SQL Revisited
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
2 Comments
SQL CE 3.5 with LINQ to SQL
See updated post: SQL CE 3.5 with LINQ to SQL Revisited 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 … Continue reading
Posted in LINQ to SQL, SQL CE
Leave a comment
Generic Insert and Update for LINQ To SQL
Quick code snippet time! The following are generic methods for inserting and updating a detached entity into a database using LINQ to SQL. /// <summary> /// Updates the database with item. /// </summary> /// <typeparam name=”T”>Type of the item</typeparam> /// … Continue reading
Posted in LINQ to SQL
Leave a comment
Intro to LINQ to SQL Optimistic Concurrency
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
