Transactions in Databases

Transaction is databases is executing set of database instructions in a sequence which should be accomplished together. Transactions have following properties which are known as ACID (wiki).

• Atomicity : Ensure all operations are completed successfully or in a failure, all operations are rolled back to its previous state
• Consistency : Ensure database properly changes state upon a successful transaction completion
• Isolation : Ensure transactions are operate independently 
• Durability : Ensure result or effect of a committed  transaction persist in a case of a system failure

Transactions in Entity Framework

Whenever you execute SaveChanges(), the framework will wrap that operation in a transaction. Starting with EF6, Database.ExecuteSqlCommand() by default wrap the command in a transaction if one was not already present. Entity framework does not wrap queries in a transaction.

Read below articles for more information Working with Transactions (Data Developer Center)
Managing connections in Entity Framework (Visual Studio)
Using Transactions or SaveChanges (SO)

Transactions in SQL Server

Implicit Transaction 
http://dba.stackexchange.com/questions/43254/is-it-a-bad-practice-to-always-create-a-transaction
http://www.codeproject.com/Articles/4451/SQL-Server-Transactions-and-Error-Handling
http://stackoverflow.com/questions/10153648/correct-use-of-transactions-in-sql-server-2008
http://www.tutorialspoint.com/sql/sql-transactions.htm
http://www.dotnet-tricks.com/Tutorial/sqlserver/c2XF120412-SQL-Server-Transactions-Management.html


SAP
https://help.sap.com/saphelp_gateway20sp08/helpdata/en/41/7af4bca79e11d1950f0000e82de14a/frameset.htm

Read More

Threading in .NET

Thread

Task
Task can be created using task factory as well. (See SO - Task.Factory.StartNew vs new Task)

Difference between Task and Thread
http://stackoverflow.com/questions/4130194/what-is-the-difference-between-task-and-thread
http://stackoverflow.com/questions/13429129/task-vs-thread-differences



Resources
http://www.codeproject.com/Articles/26148/Beginners-Guide-to-Threading-in-NET-Part-of-n
http://msdn.microsoft.com/en-us/library/e1dx6b2h%28v=vs.110%29.aspx
http://msdn.microsoft.com/en-us/library/system.threading.thread%28v=vs.110%29.aspx
http://stackoverflow.com/questions/200469/what-is-the-difference-between-a-process-and-a-thread
http://stackoverflow.com/questions/365489/questions-every-good-net-developer-should-be-able-to-answer?lq=1
http://www.learncsharptutorial.com/threading-and-types-of-threading-stepbystep.php

Read More

The most seamless tool set to develop applications

Are you looking for the seamless set of tools to develop your applications? You have great languages like Java, C#. But what is the best tool set? Well, when it comes to that the obvious choice of yours would be Microsoft products. These MS products have such a nice compatibility with each other.

Expression Blend, Visual Studio, Silverlight and .NET provide the most compelling and seamless design and development workflow on the market today. You will amazed by how easily they can be handled.

Read More

Introduction to Cloud Computing

What is cloud computing?

Large group of remote servers networked to allow centralize data storage and online access to computer services or resources. (Wikipedia). Cloud computing can be classified as private, public and hybrid.

Fundamental models 

Infrastructure as a service (IaaS)

Provides Virtual Machines, Servers, Storage, Load balancer's etc.

Platform as a service (PaaS)

Typically provides execution runtime, database, web server

Software as a service (SaaS)

Provided access to software and databases. Cloud provider manages the infrastructure. Also known as On demand software. Usually priced pay per use. 

Deployment models

Private cloud

Typically used for a single organization 

Public cloud

Open for public use. Technically there may not be any difference between between private and public clouds however security considerations are different. 

Web Server, Garden and Farm

Web Garden scales across multiple processes

Web Farm scales across multiple servers

Hybrid Cloud

Some of the enterprise software companies include
Hewlett Packed Enterprise - https://www.hpe.com/

Web Farms in IIS

Web Farm Framework - IIS

CodeProject - Difference between Web farm and garden

SO - Difference between Web Garden and Farm

Read More