Introduction: In the last article we saw that how we can insert the data into the database using only few lines and without stored procedures. Retrieving a single record from the database: You can easily retrieve a single record for a particular person based on …

Introduction: I know you all must be really anxious to find out that how NHibernate works and how it can make your life easier.In this article we will look at the add feature of the NHibernate. I will go step by step so you understand …

Series Part I Abstract: This is an article series in which I will talk about using O/R Mapping. O/R Mapping can ease your life since you don’t need to write those hefty stored procedures. O/R Mapping will also put an end to using datasets in …

Introduction: In the last article we saw the differences between the dataset and typed datasets. Typed datasets are more flexible than using dataset. In this article I will explain the entity classes which is far superior than datasets and typed datasets. Why using Entity Classes: …

Introduction: A couple of days ago I ran into a confusion when I had to decide that whether to use ViewState or Data Caching. The use of ViewState as well as Data Caching technique would have provided me with the correct solution. One of the …

Introduction: Today you will learn to write images to SQL Server and then read and display them. In order to follow this tutorial, you will need to have SQL Server,  Visual Studio .NET and .NET Framework installed. Ensure that the SQL Server instance is running. …

Introduction: Data Access has always been the heart and sole of any application. We saw ADO in classic Asp and ADO .NET in Asp .net 1.1. We also saw the data access using the Microsoft .NET application blocks, which I personally love :). In this …

SQL DMO or SQL Distributed Management Objects are available through a Development library called SQLDMO.DLL from Microsoft. This Library can be used to automate the repetitive tasks needed to be done on, SQL Databases and Servers using Enterprise manager. Tasks like Back up, Restore, Scheduled …

Last Update: 18 February 2005 Note: This article assumes a basic knowledge of Oracle stored procedures and how to create and access them. While a developer can write practically anything in C#, there are times when it would be nice to have the ability to …

Last Update: 11.02.2005 You’ve worked for months and months on your C# application and it has passed testing now is ready for deployment. You get everything through the appropriate administrators and the application is finally installed on the main applications server. You go to your …