Client objClient = new Client();
                    objClient.Nom="Vialatte";
                    objClient.Prenom="Philippe";
                    objClient.Save();
                

<configuration>
...
    <configSections>
    ...
        <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" 
          allowDefinition="MachineToApplication" restartOnExternalChanges="true" requirePermission="false"/>
    ...
  </configSections>

<connectionStrings>
  <add name="AdventureWorks" 
   connectionString="Data Source=(local)\sqlexpress;Initial Catalog=AdventureWorks;Integrated Security=True"/>
</connectionStrings> 
		 

<SubSonicService defaultProvider="AdventureWorks">
		<providers>
			<clear/>
			<add name="AdventureWorks" type="SubSonic.SqlDataProvider, SubSonic" 
					connectionStringName="AdventureWorks" />
		</providers>
	</SubSonicService>

<SubSonicService defaultProvider="AdventureWorks">
		<providers>
			<clear/>
			<add name="AdventureWorks" type="SubSonic.SqlDataProvider, SubSonic" generatedNamespace="AdventureWorks.DB"
					connectionStringName="AdventureWorks" />
		</providers>
	</SubSonicService>

    <compilation debug="true" >
      <buildProviders>
        <add extension=".abp" type="SubSonic.BuildProvider, SubSonic"/>
      </buildProviders>
    </compilation>

C:\Program Files\SubSonic\SubSonic 2.1 Final\SubCommander\sonic.exe generate /out Generated

  Product objProduct = Product.FetchById(1);

  ProductController controller = new ProductController();
  Product objProduct = controller.FetchByID(1);

            Product objProduct = new Product(712);
            Product objProduct = new Product(Product.Columns.Name, "AWC Logo Cap");

ProductCollection products = new ProductCollection().Load();
ProductCollection products = new ProductController().FetchAll().

     ProductCollection products = new ProductCollection()
         .Where(Product.Columns.Color, "red")
         .Load();

     ProductCollection products = new ProductCollection()
            .Where(Product.Columns.Color, "red")
            .OrderByAsc(Product.Columns.Name)
            . Load ();

     ProductCollection products = new ProductCollection()
            .Load()
            .Where(Product.Columns.Color, "red")
            .OrderByAsc(Product.Columns.Name);

    objProduct.Save();

     new ProductController().Insert(namespace, ProductNumber...

public void Insert(string Name,string ProductNumber,string Color,
      decimal StandardCost,decimal ListPrice,string Size,decimal? Weight,
      int? ProductCategoryID,int? ProductModelID,DateTime SellStartDate,
      DateTime? SellEndDate,DateTime? DiscontinuedDate,byte[] ThumbNailPhoto,
      string ThumbnailPhotoFileName,Guid Rowguid,DateTime ModifiedDate){
            Product item = new Product();		    
            item.Name = Name;            
            item.ProductNumber = ProductNumber;            
            item.Color = Color;            
            item.StandardCost = StandardCost;            
            item.ListPrice = ListPrice;            
            item.Size = Size;            
            item.Weight = Weight;            
            item.ProductCategoryID = ProductCategoryID;            
            item.ProductModelID = ProductModelID;            
            item.SellStartDate = SellStartDate;            
            item.SellEndDate = SellEndDate;            
            item.DiscontinuedDate = DiscontinuedDate;            
            item.ThumbNailPhoto = ThumbNailPhoto;
            item.ThumbnailPhotoFileName = ThumbnailPhotoFileName;            
            item.Rowguid = Rowguid;            
            item.ModifiedDate = ModifiedDate;            	    
            item.Save(UserName);
	    }

    item.MarkOld();
    item.IsLoaded = true;

    objProduct.Save("pvialatte");

   new ProductController().Delete(712);

   Product.Delete(712);
   Product.Delete(Product.Columns.Name, "AWC Logo Cap");

   Product.Destroy(712);
   Product.Destroy(Product.Columns.Name, "AWC Logo Cap");

     ProductCollection products = new ProductCollection()
            .Load()
            .Where(Product.Columns.Color, "red")
            .OrderByAsc(Product.Columns.Name);
      while(products.Count > 0){
                products.RemoveAt(0); // RemoveItem() gets called
      }

      products.SaveAll(); // supprime tous les objets, et sauvegarde les modifications
      products.BatchDelete(); // supprime tous les objets dans une transaction, ne sauve pas les autres objets
            

    DB.Select("Champ1","Champ2","Champ3").
        From("Table").
        Where("Champ1").
        IsEqualTo(1).
        And("Champ2").
        IsEqualTo(2);

int records = new DB.Select("productID").
                 From("Products").GetRecordCount();

int records = new DB.Select(Product.ProductIDColumn).
                From<Product>().GetRecordCount();

            int records = new DB.Select(Product.Columns.ProductID).
                From<Product>().GetRecordCount();

Product p = new DB.Select().From<Product>().
               Where("ProductID").IsEqualTo(1).ExecuteSingle<Product>();

            Product p = new Select().From<Product>().
               Where(Product.Columns.ProductID).
               IsEqualTo(1).ExecuteSingle<Product>();

   ProductCollection products = DB.Select().From<Product>()
                    .Where(Product.Columns.Category).IsEqualTo(5)
                    .And(Product.Columns.ProductID).IsGreaterThan(50)
                    .ExecuteAsCollection<ProductCollection>();

CustomerCollection customersByCategory = new Select()
    .From<Customer>()
    .InnerJoin<Order>()
    .InnerJoin(OrderDetail.OrderIDColumn, Order.OrderIDColumn)
    .InnerJoin(Product.ProductIDColumn, OrderDetail.ProductIDColumn)
    .Where("CategoryID").IsEqualTo(5)
    .ExecuteAsCollection<CustomerCollection>();

new Insert().Into<Region>().Values("test1").Execute();
new Update<Region>().Set("UnitPrice").EqualTo("test2").Where("regiondescription").IsEqualTo("test1").Execute()
new Delete().From(<Region>().Where("regiondescription").Like("test%").Execute();

   double result = new
        Select(Aggregate.Sum("UnitPrice*Quantity", "ProductSales"))
        .From<OrderDetail>()
        .ExecuteScalar<double>();

  double result = new
        Select(Aggregate.Avg(Product.UnitPriceColumn))
        .From<Product>()
        .ExecuteScalar<double>();

  double result = new
        Select(Aggregate.Max(Product.UnitPriceColumn))
        .From<Product>()
        .ExecuteScalar<double>();

   double result = new
        Select(Aggregate.Min(Product.UnitPriceColumn))
        .From<Product>()
        .ExecuteScalar<double>();

            List<Insert> queries = new List<Insert>();
            queries.Add(new Insert().Into(Region.Schema).Values("test1"));
            queries.Add(new Insert().Into(Region.Schema).Values("test2"));

            SubSonic.SqlQuery.ExecuteTransaction(queries);

  using(TransactionScope scope = new TransactionScope()){
                new Insert().Into(Region.Schema).Values("test1");
                new Insert().Into(Region.Schema).Values("test2");
                new Insert().Into(Region.Schema).Values("test3");
  }