A Blog About Random Computer Subjects
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
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
Summary A commenter on my blog mentioned Dapper .Net so I decided to take a look. Dapper is known as a Micro-ORM. It’s very easy to get started and can be used as a stepping stone between non-ORM code and an ORM with LINQ queries. First, I’ll show how it’s done: Installing Dapper in Visual … Read moreDapper .Net
Summary In this post, I’m going to show you the easiest way to get a service application up and running. Windows Services can be used to perform background tasks while your computer or server continues to perform normal tasks. Services can also run while a computer is logged out. Getting Started The first thing I … Read moreCreating a Windows Service Application