.NET ORM Dapper released as open source
Written by Kay Ewbank   
Wednesday, 06 April 2011

If your website puts a heavy load on the need to convert requests into queries and return the result from an underlying SQL database, Dapper, a new open-source tool might provide a solution.

Dapper, a simple SQL object relational mapper (ORM) for SQL Server and .NET, has been released as open source. Note that this Dapper is completely different and unrelated to the Dapper Data Mapper released by Yahoo a couple of years ago. Dapper Data Mapper is is a tool that enables users to create update feeds for their favorite sites and website owners to optimize and distribute their content in new ways. Dapper ORM also handles data, but in this case it takes a page request and passes it to SQL Server, then returns the data in a very efficient way.

dapper

At the most general, ORMs take a request from an application and handles the communication with the database the application works with. The ORM converts the data request from the application into a query format that the database will understand, then converts the results of the query back into the format used by the application. There are many ORMs on the market, which may make you wonder why we need yet another. The answer is that Dapper has been designed to let sites that are experiencing very high loads respond more rapidly. Dapper has been designed to be almost as fast as hand-tuned code using SqlDataReader and the benchmarks it produces are within milliseconds of the results if you do write hand-tuned SQL code.

Sam Saffron, a developer working on the Q&A site Stack Overflow explained that the team at Stack Overflow created Dapper in response to the load that Google's web-spidering processes placed on the site. Unlike many sites, Stack Overflow’s content changes rapidly as people ask and answer questions. This means that Google's web spider is processing up to ten pages a second.

 

dapper2

 

Stack Overflow designed Dapper to handle a specific problem; mapping parameterized SQL to business objects. They haven’t implemented it as a full blown ORM to handle database features such as relationships, just to take all the inline SQL and deal with it efficiently. There’s a good description of the ORM and what it does on Sam Saffron’s blog, as well as a link to the open source download.

Banner


Cybercrime From OU and BBC
01/11/2014

The Open University and the BBC have teamed up in a 6-part TV series about cybercrime. It starts today, Saturday, November 1 (repeated tomorrow) and can be viewed worldwide on BBC World News.



Amazon Launches Supercharged MySQL Alternative
13/11/2014

Amazon has announced a rebuilt version of MySQL created for the cloud, and engineered to be extremely low maintenance and easy to protect and affordable.


More News

Last Updated ( Wednesday, 06 April 2011 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.