DotNet Core vs. NHibernate vs. Dapper Smackdown!

The Contenders Dapper Dapper is a hybrid ORM.  This is a great ORM for those who have a lot of ADO legacy code to convert.  Dapper uses SQL queries and parameters can be used just like ADO, but the parameters to a query can be simplified into POCOs.  Select queries in Dapper can also be … Read moreDotNet Core vs. NHibernate vs. Dapper Smackdown!

Entity Framework 6.1.3 vs. Linq2SQL vs. NHibernate Smackdown!

Summary I’ve done these ad-hoc ORM performance tests in the past.  In this test I’m going to re-test the latest Entity Framework (version 6.1.3) against the latest Linq-to-SQL version.  I’ll be using EF code-first this time to make sure there isn’t any extra overhead.  I’ll also be using Visual Studio 2013. The Hardware and Software … Read moreEntity Framework 6.1.3 vs. Linq2SQL vs. NHibernate Smackdown!

NHibernate Mapping Utility Update

Summary For those who have followed my blog, I have a long-term project called the NHibernate Mapping Generator. This application generates ORM table mapping C# code for the Fluent NHibernate ORM. In this blog post I’m going to describe a few new features to this application. ADO.Net Unit Testing There is an ADO.Net Context that … Read moreNHibernate Mapping Utility Update

Fluent NHibernate Session Magic

Summary If you’ve spent any time with NHibernate or Fluent NHibernate, you’ll know how annoying it is to use the .Query() method in every LINQ query. It’s especially a problem for situations where you must convert Entity Framework or LINQ-to-SQL to NHibernate, since you have to convert every LINQ query in your code. In this … Read moreFluent NHibernate Session Magic

Entity Framework Unit Testing with SQLLocalDB

Summary I’ve published a few blog posts on the usage of SQLLocalDB with NHibernate. Now I’m going to demonstrate how easy it is to use with EF. In fact, SQLLocalDB can be used with ADO queries and LINQ-To-SQL. If you’re dealing with legacy code and your methods use a lot of database access operations, it … Read moreEntity Framework Unit Testing with SQLLocalDB

Fluent NHibernate Mapping Generator

Summary I finally did it. I completed my new Fluent NHibernate mapping generator. It has several features that make it more powerful than the hacked together console application that I did earlier this year. Included in this package are objects that use the generated code to create unit tests around SQLLocalDB. The Mapping Generator The … Read moreFluent NHibernate Mapping Generator

Using Oracle with Fluent NHibernate

Summary So far I’ve written a lot of posts about Fluent NHibernate using MS SQL Server. I wanted to demonstrate how to connect to Oracle and what the differences were between SQL and Oracle. Getting the connection to work is probably the most difficult part. After that, the mappings are a bit different, but not … Read moreUsing Oracle with Fluent NHibernate

NHibernate 4000 Character Limit, Sigh…

Summary NHibernate has its share of issues. One of it’s most notorious issues is the 4000 character limit. That limit reveals itself when you attempt to write to text or VARCHAR fields in your database that exceed that limit. In this post, I’m going to describe some solutions to this problem. Mappings One issue shows … Read moreNHibernate 4000 Character Limit, Sigh…

Fluent NHibernate Execute Stored Procedure

Summary I’ve demonstrated stored procedures a couple of times on this blog, but this time I’m going to show you how to execute a stored procedure that doesn’t need to return a value. You can use the same syntax to execute an update, insert or delete query (in cases where you might want to make … Read moreFluent NHibernate Execute Stored Procedure