We use CodeSmith to generate a lot of our code. Stored Procedures, SqlMap files, base domain objects, and services are all generated from database schema and extended properties on tables/columns.
Mike On Fri, Nov 21, 2008 at 5:57 PM, Andrea Tassinari < [EMAIL PROTECTED]> wrote: > Mygenerarion with a customized template. > > Andreat > > > Juan Pablo Araya wrote: > >> Make an XML Template with the Base Queries (The CRUDs for example). >> Here is a sample: >> >> <?xml version="1.0" encoding="utf-8" ?> >> <sqlMap namespace="$safeitemrootname$" >> xmlns="http://ibatis.apache.org/mapping"; >> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > >> >> <parameterMaps> >> <parameterMap id="parameterQuery" >> class="System.Collections.Generic.Hashtable"> >> <parameter property="ID" column="P_ID" direction="Input"/> >> <parameter property="REFCURSOR" column="REFCURSOR" >> direction="Output" dbType="RefCursor"/> >> </parameterMap> >> </parameterMaps> >> >> <resultMaps> >> <resultMap id="$safeitemrootname$Map" class="$safeitemrootname$"> >> your common properties >> </resultMap> >> </resultMaps> >> >> <statements> >> <procedure id="Find$safeitemrootname$ByRut" >> parameterMap="parameterQuery" resultMap="$safeitemrootname$Map"> >> PKG_$safeitemrootname$.Name >> </procedure> >> </statements> >> >> Then just make your XML with this template. >> >> Greetings! >> >> On Fri, Nov 21, 2008 at 6:21 PM, Ben Monro <[EMAIL PROTECTED]> wrote: >> >>> Notepad & a keyboard :D >>> >>> On Fri, Nov 21, 2008 at 1:06 PM, Rodrigo Vaz <[EMAIL PROTECTED]> >>> wrote: >>> >>>> Hi friends, >>>> >>>> which the best code generator for Ibatis. >>>> >>>> Thanks. >>>> >>>> -- >>>> []'s >>>> --------------------------------- >>>> Rodrigo Vaz >>>> Mobile : (31)-92822839 >>>> --------------------------------- >>>> >>> >>> >>> -- >>> Ben Monro >>> Software Developer >>> >>> >> >> >> > -- > AndreaT > >
