A colleague and I were talking about some LINQ features yesterday and one of the topics that came up was how to implement an IN clause. Ya know, similar to how SQL statements can use an IN clause in the WHERE clause like this: SELECT city FROM Customers WHERE state IN ('FL', 'NY'

There are several things to consider before you sit down to write a book. But here are 10 I wanted to share because I think they are either very important or not spoken of enough.I've gone down this road many times, but I took a long break between books and instead focused on other areas. Of cou

I'll be heading to Miramar, FL on July 8th [http://fladotnet.com/] for the local .NET User Group meeting to speak to the group about the Entity Framework and LINQ. I "hope" the final bits are released by then, but not on July 8th, please (yikes!). I went through a major overhaul of my

I've decided to at least try to put all of the code sample in my Data Access with Silverlight 2 book [https://www.johnpapa.net/all/silverlight-2-book-cover-mock-up/] in both VB and C#. While VB was once my main language, C# has long since been the primary language I use.  Thankfully, there is th

I've prepared dozens of articles and presentations on the Entity Framework over the past year and a half and the questions always start with "Why would I want to use this instead of XYZ?" LINQ to SQL, a variety of ORM tools, straight up ADO.NET, custom data layers, CSLA.NET and this li