Thread: Update product mapping via SQL update

I need to update all of our products to be mapped to two customer levels. Since we have thousands of products I prefer not to do this manually, and I'm thinking a SQL update would be the easiest way to do it.

Can anyone offer me an example of what kind of SQL update to run to map ALL of my products to a customer level (or even better, both customer levels at the same time)?

Thanks!

Code:

insert dbo.ProductCustomerLevel (ProductID, CustomerLevelID)
	select p.ProductID, 1 from dbo.Product p
	
insert dbo.ProductCustomerLevel (ProductID, CustomerLevelID)
	select p.ProductID, 2 from dbo.Product p

To avoid damaging my database...

Should I change the "1" and "2" in that statement to the corresponding customer levels that I need the items mapped to? Currently the customers levels we need all products mapped to would be 4 and 5.

I may not be understanding exactly how the statement works.

Bump for clarification please

Yep 1 and 2 represent the CustomerLevelIDs of the customer levels you need to map the products to. So in your case it would be

Code:

insert dbo.ProductCustomerLevel (ProductID, CustomerLevelID)
	select p.ProductID, 4 from dbo.Product p
	
insert dbo.ProductCustomerLevel (ProductID, CustomerLevelID)
	select p.ProductID, 5 from dbo.Product p

Since the release of LINQ to SQL and the Entity Framework, many questions have been raised about the future plans for the technologies and how they will relate to each other long term.

During this week of PDC we are now at a point, with the announcement of Visual Studio 10
and the .NET Framework 4.0, that we can provide more clarity on our direction.

Here's an article we wrote that will likely help you out:

Using LINQ as an Alternative to AspDotNetStorefront Data Access Layer

Let us know if you have any questions or if there's anything we can help with.

Thanks.