Wednesday, January 6, 2016

Conference: MidAmerica GIS Symposium (MAGIC) 2016 Symposium

2 Comments
The 2016 Symposium will be held at the Overland Park, KS Convention Center April 24 - April 28, 2016 in Overland Park, Kansas. The conference hotel, the Overland Park Sheraton is adjacent to the Convention Center.
Why did we chose Overland Park? Overland Park is one of the fastest growing areas in the country. The OP Convention Center is very spacious - offering our Planning Committees ample opportunity to bring you new learning experiences! Additionally, we've listened to your concerns with previous location logistics:
  • Parking: It's free and there is plenty of it!
  • Internet: It's also free EVERYWHERE including the guest rooms, meeting rooms, and Exhibit Hall!
  • The Gym: It's free too!
  • Location: Downtown Kansas City can be intimidating. The Overland Park Convention Center is extremely easy to get to, and is right off a major highway. Additionally, the area is hopping with new entertainment and shopping districts, restaurants and museums!
GIS covers such a broad range of subjects, applications and types of people that use it, that developing a conference program that meets everyone's needs is a challenging task. Even more challenging is an attendee trying to figure out exactly which sessions or topics will be most interesting and helpful. MAGIC 2016 is intended to focus the content of the presentation options into a program specifically geared to each attendee's needs.

Nhibernate criteria API - select from multiple tables

Be The First To Comment
If you ever worked with relational databases then higher chances are you already worked with sub queries. Some time while working with Nhibernate you get yourself into some situation where you need sub query to do some lifting for you. In NHibernate criteria API you can do the sub query usingDetachedCriteria and Subqueries classes. As the name suggests DetachedCriteria helps you define your sub query criteria while Subqueries class help you create sub query criterion object using detached criteria object.

In order to demonstrate sub query implementation lets consider an example. Suppose we have three entities Order, OrderItem and Product where one order can more have more then one order items while one order item may be linked to a product. If we need to do a query where we need to list all those order items which are linked to products and have price greater then $100. Also the products must be the ones marked as special in system. The SQL for such query may be something like below

SELECT * FROM OrderItem AS OI 
WHERE OI.Price > 100 AND OI.ProductId IN ( SELECT P.ProductId FROM Product WHERE P.IsSpecial = 1 )
 

© 2011 GIS and Remote Sensing Tools, Tips and more .. ToS | Privacy Policy | Sitemap

About Me