Browse by Tags
All Tags »
SQL Server (RSS)
I was looking for a quick and easy solution to export data from SQL into an Excel format from within my ASP.NET application. I came across a great video posted by Beth Massi on the asp.net website (Video #7 at the bottom at http://www.asp.net/learn/linq-videos/
Read More...
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...
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...
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...
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...
If you are an MSDN Subscriber (MVP or otherwise), you can go get the RC0 release of Sql Server 2008. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Read More...
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...
This has "bugged" me for awhile. When you log into any version of SQL (2000, 2005, and even 2008) as a user with restricted access to just a single database (or even a few databases), you can still see a complete list of all the databases on
Read More...
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...
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...
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...
This isn't funny, but it is. It should be a daily WTF. Wally just sent me this forum post where someone deleted a little more than anticipated. It sounds like this guy can be in quite a lot of trouble... http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1263379&SiteID=1
Read More...
I found a great post which summarizes aggregate functions in LINQ. It includes examples for Average, Sum, and Count. Check it out at http://www.dev102.com/2008/04/16/how-to-use-aggregate-functions-with-linq-to-sql/ . As always, you can test your functions
Read More...
So I finally got WiX to create an installer for me after many hours of poor documentation, obscure errors and bizarre angle bracket syntax. The latest error I have really annoyed me as there was no obvious indication what the error was and how to resolve
Read More...
Recently, I have been receiving more and more emails asking about the local Microsoft community scene. I noticed more people emailing me directly so I just decided to post up an item to quickly cover it. Essentially, there are a few key groups that you
Read More...