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 →
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 →
One of the better capabilities of NHibernate that I have recently found was the ability to group together queries on the client and execute them using only a trip to the database. What I have recently found, is that, as of writing this article and using NHibernate version 3.0 Beta 1, only SQL Server and […]
Read More →There are 6 things you need to do before you can capture the SQL Query generated by NHibernate at runtime. Create a class to store the NHibernate generated SQL Query Create an Interceptor class that implements the IInterceptor interface Implement the OnPrepareStatement method and set the NHibernate generated SQL Query created in step 1 Set […]
Read More →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 →
My video on this topic can be found here. We will do 4 things in the article. Add a subGrid to a JQuery/jqGrid Grid. Populate the Grid using ICriteria Populate the subGrid using IQuery (HQL) Change the ICriteria and HQL to use LINQ to NHibernate First, let’s open the Views/Home/Index.aspx file and add the /jqGrid […]
Read More →
In Lesson 14 you will learn how to: Create a SQL Server database from Visual Studio Create the database table using NHibernate SchemaExport Create a WCF which uses NHibernate Create a SilverLight 5.0 application Populate SilverLight 5.0 DataGrid
Read More →
In Lesson 13 you will learn how to: Install and reference NHibernate 3.2 Beta 1 Create a SQL Server 2008 database Create NHibernate entities using Mapping by Code Create a strongly-typed NHibernate configuration Use SchemaExport and SchemaValidate to create tables and relationships Insert and retrieve data
Read More →
In Lesson 11 you will learn how to: Add a SubGrid to the View Populate SubGrid with a method from a Controller using HQL and ICriteria Upgrade to NHibernate version 3.0 Beta Change and HQL query to LINQ to NHibernate
Read More →
In Lesson 10 you will learn how to: Create an ASP.NET MVC project Configure NHibernate using a .config file Install and Configure jqGrid Modify the View and Controller
Read More →