Tags: NHibernate

Add an XML Schema file to Visual Studio

Benjamin Perkins C#

XML Schema files (.xsd) are files which provide data for IntelliSense and are often provided along with a 3rd party class library. In case you are not familiar with IntelliSense, it is a functionality that helps you develop or configure a system by providing a list of existing methods or properties which are asscoiated to […]

Read More →

With-clause referenced two different from-clause elements

Benjamin Perkins C#

I believe if you are getting this error that there is more likely something wrong with your configuration than with NHibernate. I received this error when I wanted to create a nested join between 2 unrelated tables. Something like this in HQL: [sourcecode language=”sql” padlinenumbers=”true” autolinks=”false” gutter=”false” toolbar=”false”] select tbl.CODE, av1.NUM, al1.CODE from TABLE tbl […]

Read More →

Online SQL Formatter for ORM generated SQL

With the recent introduction of so many ORM’s (Object-relational mapping) tools onto the market it is becoming less and less needful to write SQL statements. Tools like NHibernate, Entity Framework and SubSonic to name a few will take your database mappings and write an optimized query for you. However, during development, testing or production support […]

Read More →