A Blog About Random Computer Subjects
Frank DeCaire When mapping data types from SQL server into Fluent NHibernate, the generic mappings work just fine (as long as the data in the field fits the type declared). In other words, a char(50), a text or a varchar(max) field in SQL server will fit in a string type without an issue. There is one problem … Read moreFluent NHibernate Custom SQL Types
Summary One of my previous posts described how to setup a MS SQL Lite server called LocalDB. My little demo project worked really good except for one detail. It was slow. The primary problem was that I was starting the instance, creating the database in the unit test initialize (called [TestInitialize]) and then I was … Read moreSQLLocalDB Fast Unit Tests
Summary So my company has successfully switched to using Fluent NHibernate for our production systems. So far the results are astounding. One thing our developers have learned is that there is no “perfect” ORM. Not yet anyway. Each seems to have a flaw or two. NHibernate has a couple of issues that can be worked … Read moreFluent NHibernate “Not Supported By” Exception
Summary I’ve covered a little unit testing of NHibernate in the past. I showed how to use SQLite, which is the most common method of unit testing (technically, integration testing) an NHibernate application. If you’re using MS SQL server for your application, SQLite has some serious limitations that could hinder your unit tests. So I’m … Read moreUnit Testing Fluent NHibernate
Summary I was converting some Entity Framework Linq to use NHibernate when I came across a strange error. At first I was baffled by the error message because it was telling me that there were too many input parameters. Doing an internet search led me to articles about how to limit the number of parameters … Read moreFluent NHibernate Subquery Stuff
I did a sample post on how Fluent NHibernate executes a stored procedure, but I didn’t dig into the subject and show some details. The sample I showed returned a list of tables that were already mapped and it made the whole sample easy, but not realistic. In most cases we want to execute a … Read moreFluent NHibernate More Stored Procedures Without Mapping
Summary So I’ve been posting a lot about NHibernate over the past few months (Fluent NHibernate to be exact). Mostly motivated by frustrations with Entity Framework. I have spent the past week working with NHibernate in a production environment as a proof of concept example. The first problem with NHibernate is the fact that you … Read moreFluent NHibernate Table Dump Utility
I’m going to switch gears here for a post or two and talk about software profiling. For those of you who have never used a profiler before, or have no idea what I’m about to talk about, here’s a quick run-down: A profiler is an add-on program that will measure the performance of your code. … Read moreMiniProfiler
Summary In a previous blog post, I demonstrated a composite key on a table that was used as a reference between two other tables (a many-to-many example). This time I’m going to demonstrate the basic mapping of a composite key for a table that will be defined as a class. This is a one-to-many example, … Read moreFluent NHibernate Composite Keys
Summary In an earlier post I showed how to map a many-to-many relationship without using the HasManyToMany mapper. So I finally put together a simple test project (technically it’s two projects in one solution) to test the two methods side-by-side. To my surprise, it is very difficult to tell if one is faster than the … Read moreFluent NHibernate: Simple Many-to-Many Vs. Normal Many-to-Many Mapping Timing