Welcome to Sol 3 Sign in | Join | Help

ASPInsiders

Aggregation of ASPInsiders and Microsoft ASP.NET team member blogs.

Browse by Tags

All Tags » LINQ   (RSS)
Using the LINQ Keyword "First"
All day I was stumped on why there wasn't a simple way to grab the first object in a sequence other than using: .Take(1).Single Then I discovered the keyword First. I'm still a little puzzled as to why .Single would throw an exception if more than a single Read More...
LINQ to SQL and MS Small Business Server 2008 Talks at .NET Valley
The next .NET Valley User Group event will be on June 18th at Scranton University in Scranton, Pennsylvania. There will be two talks that evening. The first will begin at 6pm and will be presented by Michael Murphy. Michael will talk about the ins and Read More...
Performance Tip: Return Only Necessary Columns Using LINQ
I was running into an issue where one of my webmethods was taking a large amount of time to return a small set (5-10 objects). I was using LINQ to SQL. I noticed that the LINQ to SQL query was returning all of the rows. After looking into the table a Read More...
A circular reference was detected while serializing an object of type 'XXX'
I ran into an issue earlier when trying to return an entity class through a web service for use in an AJAX page. After some quick research, I came across a post by Darren Neimke that referenced Rick Strahl's post about LINQ to SQL and Serialization . Read More...
New Features in Silverlight 2 Beta 2
Bill Gates and S. Somasegar announced several new features at TechEd for Silverlight Beta 2 that are great additions to the existing functionality.  Here's a list of the highlights in Beta 2: UI Framework: Beta 2 includes improvements in animation Read More...
Desert Code Camp Is This Saturday (May 31st)
Arizona's Desert Code Camp is this Saturday (May 31st) at the University of Advanced Computing building.  Here's the address: University of Advancing Technology 2625 W. Baseline Road ( map ) Tempe, Arizona 85283 It looks like there are a lot of great Read More...
Retrieving SQL Type Image Using LINQ
LINQ views the Image type in SQL Server as Binary. So, there are a few options that we have. We can either (a) modify our LINQ to SQL class and change the property to Byte() instead of Binary or we can (b) convert the Binary to an array. To do the latter, Read More...
Using "Like" in LINQ to SQL
I've recently discovered that LINQ and VB can be confusing. I was attempting to pull the top 10 rows of a table where the column started with 'W'. You'd think after I typed that, I'd figure out the solution. That's not the case. Instead, I struggled. Read More...
May 20th Links: ASP.NET, ASP.NET AJAX, .NET, Visual Studio, Silverlight, WPF
Apologies for the sparseness of my posting the last few weeks - work and life have been busy here lately.  Below is a new post in my link-listing series to help kick things up a little.  Also check out my ASP.NET Tips, Tricks and Tutorials page Read More...
Using LINQ to SQL and ConnectionStrings in a Class Library
I was looking to separate my LINQ to SQL data layer from the rest of my application. So, I decided to move the files to a class library. This way, when my application builds, all of my LINQ files are found in MyApp.DL or something similar. However, I Read More...
Obtain the Identity of a New Row Using LINQ
It's actually pretty easy and user friendly to obtain the value of the identity column using LINQ. After you create your object and insert it on submit, you can call the identity column's property on your object. For instance: Dim db As New BlogDataContext() Read More...
Working with the GridView and the System.Data.Linq.Binary Type
I'm working with a database table that has a RowVersion field defined as a TimeStamp data type.  The TimeStamp field is there to add concurrency into the application to ensure a row hasn't changed while a user is trying to update or delete it.  Read More...
Service Pack 1 Beta Released for Visual Studio 2008 and the .NET Framework 3.5
Microsoft just released the SP1 beta for Visual Studio 2008 and the .NET Framework 3.5 and it includes a huge number of new features and enhancements.  Check out Scott Guthrie's blog for details but here's a quick list of what's included: ASP.NET Read More...
The Weekly Source Code 26 - LINQ to Regular Expressions and Processing in Javascript
I've been getting more and more interested in how folks extend their applications using plugins and things. In my new ongoing quest to read source code to be a better developer , Dear Reader, I present to you twenty-sixth ( half a year! ) in a infinite Read More...
Using LINQ to Perform "WHERE IN (Value1,Value2)" Queries
I recently needed to select a few products from a database where the product ID matched up with a list of IDs.  That's easy to do with a normal SQL statement since you can use the "WHERE IN (Value1,Value2)" clause to find what you need.  Read More...
More Posts Next page »