Browse by Tags

• Programming
• SQL CE
• Visual Studio

SQL CE 3.5 with LINQ to SQL
09 September 08 02:04 PM | MattManela | 2 Comments   

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 the object model (or write it by hand).  Once Read More...

Filed under: C#, Programming, LINQ, SQL CE

Generic Insert and Update for LINQ To SQL
12 August 08 02:46 PM | MattManela | 0 Comments   

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 Read More...

Filed under: C#, LINQ

Intro to LINQ to SQL Optimistic Concurrency
22 May 08 08:40 PM | MattManela | 0 Comments   

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 are working with and Read More...

Filed under: C#, Programming, LINQ

Useful LINQ Method- GetMemberTypeChain
06 March 08 11:18 PM | MattManela | 1 Comments   

Recently, I have been working on a custom LINQ provider in C#. In a later post (when I have more time to write) I will go in depth into what I am worked on and what have I learned about writing a LINQ provider. But for now I will present a simple function Read More...

Filed under: C#, Programming, LINQ

Foray into LINQ
02 December 07 09:12 PM | MattManela | 3 Comments   

With the release of .NET 3.5 I started playing around with one of the cool new technologies called LINQ. LINQ brings SQL like querying syntax for performing operations on data sources like collections into , files or databases into .NET. The LINQ website Read More...

Filed under: C#, Visual Studio, Programming, LINQ