<a rel="nofollow" target="_new" href="http://blog.wekeroad.com/">http://blog.wekeroad.com/</a>

1. UnitPrice should not be in ProductCultureDetail table. You must find another way to handle/show parities of the same price in different currencies.

2. Generally speaking descriptions should be in text not in n/varchar. Don't forget that in a real case scenario the product description contains html.

I'm sure that there are many other issues concerning your database design.

Anyway for a test database we can overcome these issues.

I'm new to LINQ so I have some questions/comments regarding what I saw in this video.

1. What about left outer joins. Does LINQ support these type of joints?

2. I think you must use a single LINQ query in method GetCategories of your SQLCatalogRepository class.

3. In your last method SQLCatalogRepository_ShouldReturn...

of your CatalogIntegrationTest class (lines 25..27) you expect a full list of categories and then you filter out the category you like.This pattern of design will kill your database. I've seen a couple of other videos of yours and you always do the same thing. You first fetch all data and then filter. I'm I wrong?

Re unit price - this is there for the times when Euros don't match dollars...

Use of "text" is a sledge hammer (I think you mean "ntext" right?) - nvarchar(MAX) does the same thing without using the disc to file a page. Either way HTML can be stored in both types.

Yes, LINQ supports left-outers

In GetCategories there is a single query - IQueryable uses delayed execution so it's only one. The grouping happens only when the categories are returned.

Finally - I'm not very worried about perf in a test class - it's only a test :)

size before uploading . Regards

that was very interesting