Reflection

Reflection is one of the main features of .Net framework . In short it is a powerful way of collecting and manipulate information present in application's assemblies and its metadata. Metadata contain all the Type information used by the application.(Metadata - Data about data). The ability to obtain information at runtime also makes it even more advantageous. When reflection is used along with system.type, it allows the developer to get the valuable information about all the types and about the assemblies. We can even create the instances and then invoke various types that are used across the application.

Read more at http://www.dotnetfunda.com/articles/article750-reflection-.aspx

Author: Chikul

IDENTITY columns in SQL Server

The IDENTITY columns are auto incrementing columns provided by SQL Server. There can only be one IDENTITY column per table. SQL Server will take care of incrementing this column automatically.

Read more at http://www.dotnetfunda.com/articles/article753-identity-columns-in-sql-server-.aspx

Author: Chikul

SET VS. SELECT in SQL Server

SET and SELECT both key words are used to Assign Variables in SQL Server. SET and SELECT both specifies the columns to be changed and the new values for the columns. The values in the specified columns are updated with the values specified in the SET and SELECT in all rows that match the WHERE clause search condition. If no WHERE clause is specified, all rows are updated.

Read more at http://www.dotnetfunda.com/articles/article752-set-vs-select-in-sql-server-.aspx

Author: Chikul

Execute Stored Procedure in SQL Server using nHibernate

I was facing a lot of challenges to execute Stored Procedure through nHibernate. As I was new to nHibernate technology, Googling also did not help me much on this front and I spent a lot of time to get the actual result. Here, I am sharing with you some tips while doing this type of activity.

Read more at http://www.dotnetfunda.com/articles/article749-execute-stored-procedure-in-sql-server-using-nhibernate-.aspx

Author: Ziaulh