A while back, Scott Guthrie posted in the comments, that LINQ didn't support, or had trouble with Many to Many relationships. I'm not sure if the code-base has changed, or I haven't considered a full scope, but I've managed to get it to work, and it's slick! I'll jump straight to the magic here. I've...

Just a quick plug to the community. I've gotten to the Alpha release of my AuctionSite Starterkit and have published a release on Codeplex http://www.codeplex.com/auctionsk It's designed and produced in .net 3.5 utilizing some cool features like LINQ, the new Listview, the .NET membership, full CSS design...

This is odd. Have a test table with an id and name field no primary key was set as it was a quick test hack. Pulled the table into the LINQ Designer and noticed none of the validation partial methods were there. There was no OnnameChanged. Nowhere. After banging my head I made ID a primary key and boom...

SOLUTION: Ok fired up SQL profiler and see my problem, the non compiled query seems to not evaluate the query until you actualy use the object. But the Compiled version is hitting the database straight away. And as I was not using this data the non compiled version seemed fast as it never hit the database...

Hello all, I decided to implement tagging on my video library. My first solution was to use one table for the tags. Containing the videoid and tagname. When I loaded in 1,000,000 test tags this became slow to generate my tag cloud data. My new solution was to split up the tags into two tables. One containing...

I am beggining to really like to ease of using LINQ, On a project I am working on now I am storing configuration in an XML file like so: <sites> <site id="1" sitename="foo"> <domains> <domain url="www.foo.com" /> </domains> <settings> <setting key="foo" value="foo...

Some time ago I decided to move my community (worked on Invision Power Board) to Community Server 2007 and create blogs for all users. But I didn't find any converter software. So, I wrote converter by myself. In this project i used LINQ for Community Server MSSQL database and Mysql LINQ Provider for...

Hi All, Have run into some issues with using default values in my SQL database with LINQ. I set AutoGenerated in the LINQ Designer to true which made use of my default values but this did not let me update this manually as it would throw an exception. I got a good suggestion from Young Joo to keep autogenerated...

Good deal: 3 free e-books from Microsoft Press! Go to http://csna01.libredigital.com/?urvs5cn3s8 sign with your Windows Live ID and get the full complete books free chapters and the full complete LINQ book! Introducing Microsoft LINQ by Paolo Pialorsi and Marco Russo Complete!! Introducing Microsoft...

Hey All, Had a query which I was paging on the front end. I knew that a certain product was meant to be in my display but could not see it. But on page 2 a product would repeat itself. Odd, got into profiler and looked at the queries. The first page would get a select top 9 which would not do any orderby...