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 outs of Microsoft Small Business Server 2008. The...
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 bit further, I noticed that the table included some...
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 . For me, performing the first work-around and setting...
A client of mine located in the Aiken/Columbia South Carolina Area has asked me if I had any friends who are .NET Developers and looking for a job. They are looking for at least one Junior Developer, on Mid-Level Developer and several Senior developers. I know these folks quite well and I can vouch for...
Posted to
Bill's House O Insomnia
(Weblog)
by
William
on
06-06-2008
Filed under: Compact Framework, Data Access, Web Services / WSE, .NET Basics, .NET General, Coding Techniques, Misc Technology, Biztalk, WPF, WCF, .NET 3.0 Framework, WIX, Sql Server Integration Services, SSIS, Silverlight, Sql Server, Sql Server 2008, Sharepoint, LINQ To ADO.NET, .NET 3.5 Framework, LINQ, LINQ Training, ADO.NET 3.5, C# 3.5, Windows Mobile, Job Stuff
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, you can use a lambda expression to obtain the...
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. Here's what I originally...
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 wanted the class library to use the SQL connection...
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() db.BlogPosts.InsertOnSubmit(MyPost...
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 by using LINQPad which is available at http:...
Have just got the link to download the full package of .NET Framework 3.5. This is a 197 MB standalone executable file that contains all the components that are required to deploy to 32-bit and 64-bit platforms on all supporting operating systems. (The .NET Framework 3.5 supports IA64 only on Microsoft...