database

Select Random Records Using Nhibernate

Selecting 5 random rows in SQL is easy

Nhibernate is a different story.  I am new to NHibernate and I both love and hate it.  I hate the steep learning curve and the unobvious ways of doing things.  Anyway, here is how to select 5 random records using nhibernate. First class a new order(…)

SQL Script to generate data inserts for existing tables

Here is a great sql script that will look at your table and generate a script to insert all the data. This is very useful when moving databases or when you want to create a database setup in your application with some default data. Note that I haven’t tried this procedure and it was sent(…)