which ASP.NET to MYSQL database access should i use?
i'm writing an ASP.NET ot MYSQL e-commerce site where the clients can choose products from a product list by categories.
in each category the user can choose a sub category , for example, in TV category, the user will choose : LCD or plasma sub categories, screen size sub category, manufacturer sub category and so on....

The basic things i'll be doing with the data is Query it using C# and databind it to datagrids.
what is the way you recommend for extracting the data from the database using c# and ASP.NET?

i thought about Extracting all tables as datasets using dataadapters, keep the tables in the cache and query them using linq to datasets. but i think this is an old fashion way.

what about SQL Entity framework ? 
should i use the ASP.NET sqldatasource tags too? 
How would you do it ? 
which ASP.NET to MYSQL database access should i use?
===

i'm writing an ASP.NET ot MYSQL e-commerce site where the clients can choose products from a product list by categories.
in each category the user can choose a sub category , for example, in TV category, the user will choose : LCD or plasma sub categories, screen size sub category, manufacturer sub category and so on....

The basic things i'll be doing with the data is Query it using C# and databind it to datagrids.
what is the way you recommend for extracting the data from the database using c# and ASP.NET?

i thought about Extracting all tables as datasets using dataadapters, keep the tables in the cache and query them using linq to datasets. but i think this is an old fashion way.

what about SQL Entity framework ? 
should i use the ASP.NET sqldatasource tags too? 
How would you do it ? 