Creating a Data-Tier Library for an ASP.NET Web App

[Kyle Korndoerfer <kk...@yahoo.com>]

I am creating an ASP.NET application and would like to use iBatis.NET for the Data-Tier. While I can find information on how to set everything up within a single web project, I am looking to create the data tier as a Library project within a Solution that contains the Web project

What I would like to have is as follows:

> My Solution
    > Web Application Project
    > Data Tier Library Project (using iBatis.NET)
    > Business-Logic Tier Library Project
 
The usage scenario would be as follows:

    Web Application  <--->  Business-Logic Tier Library  <--->  Data Tier Library

This would keep things logically separated and easier to maintain/upgrade in the future.

Is this possible (surely it is) and how do I structure things to achieve this?  If I have missed a link to an article explaining a similar scenario, please send me the link!

Thanks in advance!


-={ Kyle }=-



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: IBatis.NET release

["Bruno Silva (Cool Advance)" <br...@cooladvance.com>]

Hi,

I've been trying to use the groupBy feature available in the trunk and 
it works great. However, I haven't managed to have the right results for 
maps that return a primitive.

These are the result maps:

*<resultMap id="Fields.ResultMap" class="Field">
      <result property="Id" column="id"  />
      <result property="Name" column="name" />
      <result property="Description" column="description" />
      <result property="FieldType" column="field_type"/>
    </resultMap>

    <resultMap id="Fields.Fill.ResultMap" class="Field" 
extends="Fields.ResultMap" groupBy="Id">
      <result property="PossibleValues" column="value_text" 
resultMapping="Fields.PossibleValues.ResultMap" />
    </resultMap>

    <resultMap id="Fields.PossibleValues.ResultMap" class="string">
      <result property="value" column="value_text" />
    </resultMap>*

and here is the statement:

*<select id="Select.Fields.Fill" resultMap="Fields.Fill.ResultMap" 
parameterClass="string">
      SELECT
      f.*, pv.value_text
      FROM fields f
      LEFT JOIN possible_values pv ON f.id = pv.field_id
      <isParameterPresent>
        WHERE f.id = #value#
      </isParameterPresent>
    </select>
*
It actually groups the results correctly (2 inserted entries return 2 
rows) but I get empty strings instead of the correct values.
Where did I go wrong, or is this is a bug?

Thanks in advance,
  Bruno Silva

-- 
Cool Advance - Information Systems
http://www.cooladvance.com/

Re: IBatis.NET release

[Gilles Bayon <ib...@gmail.com>]

I have a lot of things on the fire on this year end, before to do a a new
release, the documentation must be updated.
Expected the new release before the end of the year or in january.

The current trunk in SVN is fully operational (I used in production) and I
don't think that's new feature will be add in.
This will be the last release under the 1.*.
The next will be versionned 2.* and adopt a new namespace something like
org.apache.ibatis as introduc a new syntax to access file resource in the
spirit of Spring.NET and Castle .

-- 
Cheers,
Gilles

<a href="http://www.amazon.com/gp/registry/6JCP7AORB0LE">Wish List</a>

IBatis.NET release

["Bruno Silva (Cool Advance)" <br...@cooladvance.com>]

Hello,

any predictions about the next official release data of iBatis.NET? 
There are some features which I would like to have, but I usually try to 
avoid using nightly builds on systems which are on production.

Regards,
  Bruno Silva

-- 
Cool Advance - Information Systems
http://www.cooladvance.com/