Wednesday, November 30, 2011

TRANSACTION implementation in LINQ

LINQ is become one of most popular. But Based on our business logic we need to Use Transaction in LINQ.
LINQ Transaction is much more smart. You do not need to rollback. If it fail to complete any query it automatically rollback.

To use transaction You have to add a .NET dll name  "System.Transaction" in reference of your application.

.

Now in your DataAccess Layer you can use like

  public void UpdateSaleDetailsTable(ESalesReturn aSalesReturn)  
     {  
       using(System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required))  
       {  
         UpdateSaleDetailsTableData(aSalesReturn);  
         UpdateSaleTable(aSalesReturn);  
         UpdateCurrentProductTable(aSalesReturn);  
         InsertIntoSalesReturnTable(aSalesReturn);  
         scope.Complete();  
       }  
     }  

C# print file on LAN Printer

If you want to print any file on network printer then you can try with this code block // Change Default Printer System.Ma...