Naresh Microsoft Technologies Blog

An Object-Oriented Database Management System (OODBMS), sometimes referred as Object Database Management System (ODMS) is a Database Management System (DBMS) that supports modeling and creation of data as objects. OODBMS provides support for object classes, class property and method inheritance by sub classes and their objects. A Relational Database Management System (RDBMS) is also a DBMS but, that is based on the relational model. Most popular DBMSs currently in use are RDMSs. As mentioned earlier RDBMS is based on the relational model and data in a RDMS are stored in the form of related tables. So, a relational database can simply be seen as a collection of one or more relations or tables with columns and rows. Each column corresponds to an attribute of the relation and each row corresponds to a record that consists of data values for an entity. RDMSs are developed by extending hierarchical and the network models, which were two previous database systems. Main elements of a RD...

Use  views and stored procedures  instead of heavy-duty queries. Try to use  constraints  instead of triggers, whenever possible. Use  table variables  instead of temporary tables. Try to use  UNION ALL statement  instead of  UNION , whenever possible. Try to  avoid using the DISTINCT  clause, whenever possible. Try to  avoid using SQL Server cursors , whenever possible. Try to  avoid the HAVING clause , whenever possible. If you need to return the total table's row count, you can use alternative way instead of  SELECT COUNT(*) statement. Include  SET  NOCOUNT   ON  statement into your stored procedures  to stop the      message indicating the number of rows affected by a T-SQL statement. Use the select statements with  TOP keyword or the SET ROWCOUNT  statement, if  you need to return only the first n rows.        More Tips w...

Delegates in C# Delegates in C# are similar to functional pointers in C++ and are used to encapsulate a method that have similar signature like delegate. We can declare a delegate type with “delegate” keyword in C#. Moving forward, we will see more about delegates and its uses. Delegates – A Detailed Look A delegate is a type that references a method once it is assigned to that method and it behaves exactly like that method. The delegate method can be used like any other method, with parameters and return value. Any method that matches the delegate’s signature, in terms of return type and parameters can be assigned to that delegate. Some information about Delegates 1.        Delegates have are similar to c++ function pointer but are type safe. 2.        Delegates allow method to be passed as parameters. 3.        Delegates can be used to define callback methods. 4. ...