CodeLogs

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.

What's OOP? Object Oriented Programming or simply OOP is a way of programming in which you think of Objects and the interrelated methods, functions or properties that each object must contain. There are four important concepts behind Object Oriented Programming these are Abstraction, Encapsulation, Polymorphism and Inheritance. Abstraction It the process of modelling wherein only the needed or the important functions of a class are shown and hide the inner workings to lessen the complexity. Encapsulation Often referred to as information hiding, encapsulation hides data from external access, in C#  access is given through access modifiers such as public, internal and protected. Polymorphism Is simply having many forms and shapes, you may ave many classes which can be used interchangeably, in .Net polymorphism is implemented through interfaces. Inheritance is the ability to create a new class from existing base class, parent class are called base class and the class t...

Decorator

Let's talk about .Net Generics, what exactly is Generics in .Net. Generics was first introduced in .Net Framework 2.0. What is Generics? "Generics allows you to to create type safe class without committing to the actual class" say that again? It only means that you may create a class that can be used with different types.

Been busy for quite some time, now I decided to go back to blogging since I cant seem to remember the tricks I did from my previous applications. So I decided to blog whatever it is that I may think relevant to blog when it comes to .Net Code, this would truly help me when trying to remember what I did in the past... I'll discuss about Factory Pattern and how we implemented it in our project.