Hi,

So you want to use a database to store order info? that could also be done using document types.This comes with the benefit to view them easy and directly in Umbraco  

But if you have a lot of orders a database might be a better approach.Below you find a snippet how to work with Sql against the Umbraco database. I still use normal sql instead of Linq2Sql because in theory this would work on other databases such as Mysql as well. To run this snippet you need to add references to the dll's Umbraco, Cms, BusinessLogic, Interfaces, Umbraco.providers, Umbraco.Datalayer

 
 
List<IParameter> parameters = new List<IParameter>();
parameters.Add(
 
Application.SqlHelper.CreateParameter("@UmbracoMediaId", mediaId));
 
 
string sql = "DELETE FROM CMSImportMediaRelation WHERE UmbracoMediaId = @UmbracoMediaId ";
 
 
Application.SqlHelper.ExecuteScalar<int>(sql, parameters.ToArray());
 

 Umbraco comes with a few commercial Ecommerce extensions that might be worth to checkout

• SuperSimpleWebshop
• Tea Commerce
• Ucommerce

Cheers,

Richard

is working on a reply...