A Blog About Random Computer Subjects
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
Summary In this blog post I’m going to talk about legacy code and my experience with transitioning from Legacy into a new model. Background I’ve worked for quite a few companies now and I’ve converted many systems from antiquated legacy code into something more modern, like C#, PHP, Object Oriented, MVC, etc. Legacy code that … Read moreDealing with Legacy Code
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
Summary In this blog post I’m going to talk about Visual Studio’s proj file which is nothing more than an XML file used to keep track of the resources inside a project. The Setup Open your Visual Studio (I’m currently using VS 2012) and create a console application. If you have your solution explorer window … Read moreVisual Studio Project Files
Summary So I wanted to try out MongoDB and see what it was all about. In this blog post I’m going to give a quick run-down of how to get things up and running just to show how easy it is to install and connect to a MongoDB database. Where to Get MongoDB The official … Read moreIntroduction to Mongo DB and C#
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
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…
Summary If you’re an old-hat with databases, this blog post will not be new to you. I’m going to show some capabilities of SQL Server that will reveal how powerful a database server can be. These “secrets” (OK, they’re really not secret to anybody with a browser and Google) actually apply to other data servers … Read moreSQL Server Secrets…
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!
Summary In this post, I’m going to show how to use a stored procedure in a SQLLocalDB MS Test setup. Technically this is an integration test, so excuse the fact that I might call it a unit test out of habit. The Technical Details What I’m going to do is copy the code from a … Read moreUnit Testing with Stored Procedures