A Blog About Random Computer Subjects
Summary This blog post is overdue, but I’d like to talk about my database experiences with and without ORMs. Before ORMs I have been writing database driven software for a long time. My early days include the use of Borland C++ with Paradox and FoxPro databases. I have also written Borland C++ and PHP code … Read moreOrm vs Non-ORM
If you’ve ever used SQL server for a serious project, you’re already nodding your head at the title of this blog post. There are many aspects of SQL server that is a bit quirky. Overall I think SQL Server is a very good but expensive product. I have experience with Oracle as well, and Oracle … Read moreSQL Server is Crazy!
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
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