Discover the entire series on C#.
What's new in C# 2
What's new in C# 3
What's new in C# 4
Excel automation is unavoidable scenario in most of the Enterprise IT solution. Primarily the automation targets following area
In addition to typical Interop Assembly usage, we can take advantage of Open XML APIs. In addition to that there are lot of third party tools available to address the same. In this blog will keep adding the relevant tools and techniques of Excel Automation.
Note: If you are using SSIS, there is good amount challenge. Check out Dougbert blog for solutions.
Windows Phone 7 is the latest buzz in Microsoft. There are lot of opportunity for developer. Here is the resources to catch up.
Training Kit
Did you ever worked on a project where you need to create CRUD SP for each table and explored opportunity to automate the code. In such scenarios most of the people do dynamic SQL, but managing a dynamic SQL code is not as smooth as for the V1 developer.
The code template, code generation tools bridges the gap.
More info blog,Text Templates, T4 Toolbox and T4 Editor
A quick snap of patterns. (The diagram are from Design Patten Book)
Chain of Responsibility
![B Chain of Res_thumb[2]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Chain of Res[4].png "B Chain of Res_thumb[2]")
Command
![B Command_thumb[2]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Command[4].png "B Command_thumb[2]")
Interpreter
![B Interpreter_thumb[2]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Interpreter[4].png "B Interpreter_thumb[2]")
Iterator
![B Iterator_thumb[2]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Iterator[4].png "B Iterator_thumb[2]")
Mediator
![B Mediator_thumb[1]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Mediator[3].png "B Mediator_thumb[1]")
Memonto
![B Memento_thumb[1]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Memento[3].png "B Memento_thumb[1]")
State
![B State_thumb[1]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B State[3].png "B State_thumb[1]")
Strategy
![B Strategy_thumb[1]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Strategy[3].png "B Strategy_thumb[1]")
Template Method
![B Template Method_thumb[1]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Template Method[3].png "B Template Method_thumb[1]")
Visitor
![B Visitor_thumb[1]](file:///C:/Users/guvijaya/AppData/Local/Temp/WindowsLiveWriter-429641856/supfiles2708F5/B Visitor[3].png "B Visitor_thumb[1]")
Observer
