Contents tagged with .NET SQL Server
-
Error logging techniques using Database
Nowadays error logging becomes mandatory and there has been lots of techniques/API's to log the errors. We develop a ASP.NET application and it works fine on your development machine, and when we deploy the application to the production we set the <compilation debug="false" ...> element in your web.config , of course it is the best practice, which makes the error not visible to the end users.
Well, now, we got some exception and we wonder what is that error and you don't have any clue about error since we have not logged the exception and we were left at no man’s land and makes the developer job very tough without any clue about the error and hence we expect is to log the error and a notification mail to sent to the development so that we make the developer job much easier which is even best practice.
In following article we are going to cover the topics on how to log the error in a simple way and of course in a efficient manner. -
DAL Class and Transact-SQL generator for C#.Net
This program help you write the necessary code for doing base operations of your application's Data Layer (both Web and Windows applications). The function of this program is making a DAL class to easily selecting, manipulating and deleting records of the Database. The result is a simple class for each table in your database.
-
Developing 3 tier web sites in ASP.NET 2.0
If you struggle with the new architecture database model in ASP.NET 2.0 maybe you should read this excellent article by Bipin Joshi on N-Tier architecture for ASP.Net 2.0
-
Inserting Records Into SQL Server Using SqlBulkCopy
With the advent of .NET 2.0 Microsoft has incorporated SQL Server’s bcp command line utility into the framework. The System.Data.SqlClient.SqlBulkCopy class provides significant performance increases over regular inserts. It also works with the System.Data.SqlClient.SqlTransaction class.