IIS 7 url rewrite using database variables

Question

I would like to change my urls from http://www.example.com/product.asp?productid=30 to: http://www.example.com/Samsung_LED_UE40D5000

the Samsung_LED_UE40D5000 is the product name + the product model stored in the database and is associated with the productid as the primary key.

how do i write a url rewrite rule to achieve that? Thanks a lot!

O.B

Answer 1

You have to write Custom Rewrite Provider which accesses database to resolve product name + the product model to productId. Then use this Provider in your rewrite rules.

Here is document describing the process.