Some days ago I posted about an helper class to easy the access to database. I took original code by ayende and do slightly modifications to make database indipendent. A natural extension to that class is the ability to retrieve a datareader with some data. An initial solution is simply call the core Execute() function [...]
Continue reading about A pattern to access DB with IDataReader
I’m trying to develop a little framework to include in future projects, actually I had classes and project spread around partition D F and G, and I realized that I’m not really a tidy person . At this moment I only had written some classes to handle access to db with direct Sql, and I [...]
Few clicks, 100$ and in only 4 days from Amazon directly to my desk in Italy J Alk.
After a long time that some friends told me about boo language, finally yesterday I downloaded the trunk and began to familiarize with the language. The first thing that surprised me is the ability to break into debugger with simple instruction like these import System.Diagnostics Debug.Fail(“”) And your favorite debugger will show up with full [...]
Today I found a performance issue in a project of mine, after some try, I found that the overhead of calling a udf function is really enormous…I have a query that move data from a table to another, it move about 25.000 rows, and one of the field of original table is transformed with a [...]
Continue reading about Overhead calling UDF in Sql server 2005
