I need a sample project that uses the northwind database. Needs to use the LINQ To SQL class for it.
The only table needed is the Customers.
The project needs to be a console one. When ran; it will print out how many customers where the region is null to the console. Then I have to hit enter to contine (so i can see the results). Cannot use dynamic sql (using executecommand or executequery) because if those 2 things are used; then intellisense is lost. Plus cannot use the .ToList first either (where i have to create an entire list first). The purpose of this project is I have found cases where i need to search for nulls using linq to sql and I cannot get the nullable(Of string) to work at all.
The source code only to show the linq to sql query to find columns that are nulls that are string. Must use Visual Basic with Visual Studio 2008 for this. Must use straight linq to sql (no dynamic queries or converting to a list to use linq to objects).