ASP.NET MVC Storefront Part 5: Globalization

I realize this is a little late in the series to ask, but why use IQueryable rather than IEnumerable? Is there a reason, or is it just because IQueryable is the more explicit interface for queryable objects?

Hi. Rob Conery has a blog in which he wrote a post for every episode in this series. All comments, questions and answers seem to be happening there.

http://blog.wekeroad.com/

Some quick responses to your video.

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?

Hi jthaniassis, thanks for the thoughts - let's see if I can help...

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 :)

Good lesson. I need to know how to upload photos to database and format

size before uploading . Regards