CodeLogs

Why use design Patterns? Every software problem is most likely the same in concept, there are some differences in domain but basically problem is the same and therefore solutions already exists and can be re-used this is what design patterns are for. What are the advantages of using Design Patterns? Predictability Reduce Cost Scalability Reusability  Robust code. Superior Software. Design Patterns are categorized into the following: Creational Structural Behavioral

What is Common Type Expressions? and How do we use it in our Stored Procedures? Common Type Expressions is almost similar to a view but you don't really create a physical view, instead you are querying a result set that is available for your SELECT, UPDATE, DELETE statements. Here's an example using Northwind: We may have a query like this: SELECT CustomerID,         CompanyName,         CONVERT(varchar,OrderDate,101) as OrderDate,         ProductName,         Quantity FROM (  SELECT  c.CustomerID, c.CompanyName,  o.OrderDate,                p.ProductName,  od.Quantity FROM Orders o INNER JOIN dbo.Customers c ON o.CustomerID = c.CustomerID INNER JOIN dbo.[Order Details] od ON o.OrderID =  od.OrderID INNER JOIN dbo.Products p ON od.ProductID = p.ProductID ) details WHERE details.Quantity>10 With...

Back to Blogging. I have this project in ASP.Net MVC wherein I need to make a dashboard for our client using ASP.Net MVC. Quick Requirements: -A predefined dashboard for each user group. -Customizable widget/gatgets/webparts whatever you want to call it. Quick Goals: -Create a webpart and webzones. -Create a baseclasses with interfaces. -Create a controller base which other controllers will inherit from. -Webparts are independent.

It's been awhile since I last opened this blog.. Haven't started anything on this blog last year. Hopefully this year I'll be able to post some useful information to all .net coders out there.