These are inspired by the "controller" templates for CodeSmith supplied by Bert. I've changed the names from *Controller to *Manager.

Not every piece of possible functionality is in there but, there's plenty for it to be useful. Maybe we can use these as a starting point for the LLBLGen TemplateStudio community to build something really useful for us.

These were built in about an hour so, they need some work still.

Otis,

If you look at the <~~> block in "EntityManagerBaseTemplate.lpt" you'll see what I was getting at with wanting that stuff to be available to a whole templateset without having to redefine it on every template. I suppose copy/paste is good enough though.

Here they are: http://code.caliberweb.com/LLBLGenProManagers.zip

Chris

Sounds great! I'll check them out tomorrow (friday).

Thanks for posting this!

BTW - Found 2 bugs in EntityManagerBase:

You are using rel.RelationEndPoint.Name in the Method names, but this fails for tables that have a relationship with themselves...

Here is the fixed code:

        #region One To Many
        <%  
        foreach(EntityRelation rel in Entity.Relations)
        {
            if(rel.RelationType == EntityRelationType.OneToMany && !rel.UtilizingPropertyIsHidden)
            {
        %>      
        public static EntityCollection Fetch<%=rel.UtilizingPropertyName%>Collection( <%=Entity.Name%>Entity <%=CamelCase( Entity.Name )%> )
        {
            EntityCollection collection = <%=CamelCase( Entity.Name )%>.<%=rel.UtilizingPropertyName%>;
            return FetchCollection( collection, <%=CamelCase( Entity.Name )%>.GetRelationInfo<%=rel.UtilizingPropertyName%>(), 0, defaultSorter );
        }       
        
        public static EntityCollection Fetch<%=rel.UtilizingPropertyName%>Collection( <%=BuildPrimaryKeyParameterList()%> )         
        {
            <%=Entity.Name%>Entity <%=CamelCase( Entity.Name )%> = new <%=Entity.Name%>Entity( <%=BuildPrimaryKeyList()%> );
            return Fetch<%=rel.UtilizingPropertyName%>Collection( <%=CamelCase( Entity.Name )%> );
        }
        <%
            }
        }
        %>
        #endregion
        
        #region Many To One
        <%  
        foreach(EntityRelation rel in Entity.Relations)
        {
            if(rel.RelationType == EntityRelationType.ManyToOne && !rel.UtilizingPropertyIsHidden)
            {
        %>  
        public static <%=rel.RelationEndPoint.Name%>Entity Fetch<%=rel.UtilizingPropertyName%>Entity( <%=Entity.Name%>Entity <%=CamelCase( Entity.Name )%> )
        {
            return (<%=rel.RelationEndPoint.Name%>Entity)FetchNew( new <%=rel.RelationEndPoint.Name%>EntityFactory( ), <%=CamelCase( Entity.Name )%>.GetRelationInfo<%=rel.UtilizingPropertyName%>( ) );            
        }
        
        public static <%=rel.RelationEndPoint.Name%>Entity Fetch<%=rel.UtilizingPropertyName%>Entity( <%=BuildPrimaryKeyParameterList()%> )
        {
            <%=Entity.Name%>Entity <%=CamelCase( Entity.Name )%> = new <%=Entity.Name%>Entity( <%=BuildPrimaryKeyList()%> );
            return Fetch<%=rel.UtilizingPropertyName%>Entity( <%=CamelCase( Entity.Name )%> );
        }
        <%
            }
        }
        %>
        #endregion

Also, sometimes rel.RelationEndPoint.Name = rel.UtilizingPropertyName which cause a compile error in the DeleteWithRelations method. I have added the word Collection to the end of the local collection variable name to avoid this:

        public static bool DeleteWithRelations( <%=ObjectName%>Entity <%=CamelCase(ObjectName)%> )
        {
            #region One to Many
        <%  
        foreach(EntityRelation rel in Entity.Relations)
        {
            if( rel.RelationType == EntityRelationType.OneToMany && !rel.UtilizingPropertyIsHidden )
            {
        %>          
            EntityCollection <%=CamelCase(rel.UtilizingPropertyName)%>Collection = <%=rel.RelationEndPoint.Name%>Manager.FetchCollection( <%=CamelCase(ObjectName)%>.<%=rel.UtilizingPropertyName%> );
            
            foreach( <%=rel.RelationEndPoint.Name%>Entity <%=CamelCase(rel.RelationEndPoint.Name)%> in <%=CamelCase(rel.UtilizingPropertyName)%>Collection )
            {
                <%=rel.RelationEndPoint.Name%>Manager.DeleteWithRelations( <%=CamelCase(rel.RelationEndPoint.Name)%> );
            }
        <%
            }
        }
        %>  

            #endregion

Regards,

Marcus

Thanks for the feeback. I'll check it out when I get into the office.

cmartinbot wrote:

These are inspired by the "controller" templates for CodeSmith supplied by Bert. I've changed the names from *Controller to *Manager.

Not every piece of possible functionality is in there but, there's plenty for it to be useful. Maybe we can use these as a starting point for the LLBLGen TemplateStudio community to build something really useful for us.

These were built in about an hour so, they need some work still.

Otis,

If you look at the <~~> block in "EntityManagerBaseTemplate.lpt" you'll see what I was getting at with wanting that stuff to be available to a whole templateset without having to redefine it on every template. I suppose copy/paste is good enough though.

Here they are: http://code.caliberweb.com/LLBLGenProManagers.zip

Chris

Can someone please explain what these "controller" templates are used for?

alexdresko wrote:

Can someone please explain what these "controller" templates are used for?

They generate a bunch of helper "Manager" classes which provider methods for doing usual tasks like Fetching, Saving and Deleting.

So instead of writing:

PersonEntity entity = new PersonEntity(personID);
using (DataAccessAdapter adapter = new DataAccessAdapter()){
    adapter.Fetch(entity);
}

You simply have to call:

PersonEntity entity = PersonManager.Fetch(PersonID);

It gets more helpful when you are think about related objects for example:

PrefetchPath2 prefetch = new PrefetchPath2( (int)EntityType.PersonEntity );
prefetch.Add( PersonEntity.PrefetchPathHomeAddress );
PersonEntity entity = new PersonEntity(personID);
using (DataAccessAdapter adapter = new DataAccessAdapter()){
    adapter.Fetch(entity, prefetch);
}

is replaced by:

PersonEntity entity = PersonManager.FetchWithHomeAddress(PersonID);

Something that is missing in these templates however is the ability to pass in an existing DataAccessAdapter... which would be required for transaction control.

The nice thing, is that its easily added by simply adding a contructor which takes DataAccessAdapter as a parameter and stores in a field which is accessed by the DataAdapter property of the ManageBase class.

[UPDATE] This is of course "rubbish" as the methods are static.

You will have to provide overloaded methods which take a DataAccessAdapter instance as a parameter... [/UPDATE]

Marcus

Marcus wrote:

Something that is missing in these templates however is the ability to pass in an existing DataAccessAdapter... which would be required for transaction control.

The nice thing, is that its easily added by simply adding a contructor which takes DataAccessAdapter as a parameter and stores in a field which is accessed by the DataAdapter property of the ManageBase class.

[UPDATE] This is of course "rubbish" as the methods are static.

You will have to provide overloaded methods which take a DataAccessAdapter instance as a parameter... [/UPDATE]

Marcus

This is something that I've never to date had a use for. I'll give it some thought.

One thing I have added today is a strongly-typed collection class that holds IPrefetchPathElement2 objects and overloads to the FetchWith* methods that accept a PrefetchPathElement2Collection for additional prefetches. This proved to be very useful today for me. YAY!!! Hopefully, other people will find the so too.

Marcus wrote:

Something that is missing in these templates however is the ability to pass in an existing DataAccessAdapter... which would be required for transaction control.

I actually adding these now... and you can have them when I'm done...

cmartinbot wrote:

One thing I have added today is a strongly-typed collection class that holds IPrefetchPathElement2 objects and overloads to the FetchWith* methods that accept a PrefetchPathElement2Collection for additional prefetches. This proved to be very useful today for me. YAY!!! Hopefully, other people will find the so too.

Cool, will you be making these available also?

Marcus wrote:

I actually adding these now... and you can have them when I'm done...

Cool.

cmartinbot wrote:

One thing I have added today is a strongly-typed collection class that holds IPrefetchPathElement2 objects and overloads to the FetchWith* methods that accept a PrefetchPathElement2Collection for additional prefetches. This proved to be very useful today for me. YAY!!! Hopefully, other people will find the so too.

Marcus wrote:

Cool, will you be making these available also?

Yup

Otis,

I remember you offering to setup a Subversion repository before. Would that be possible now to accomodate ongoing development of these templates between other members?

cmartinbot wrote:

Otis,

I remember you offering to setup a Subversion repository before. Would that be possible now to accomodate ongoing development of these templates between other members?

I was going to suggest exactly the same thing...

Man, this is GREAT! Thanks, cmartinbot! I'm saving even more time (using these templates) with my timesaver tool (LLBLGen). This keeps up and I'll just go home for the day and let the tools do the work...

Hi,

The 2 updated template files which include the DataAccessAdapter overloads are available at http://www.styledesign.biz/downloads/temp/2004-12-10UpdatedTemplates.zip

These new templates produce code that compiles ok, but I have not tested the changes or the original generated code from cmartinbot.

Marcus

We moved our site from our co-located server to an ISP server. The co-located server is leased and that will end april 2005 (as no important websites are running on it at the moment, our own site will move to an ISP as well), so the subversion setup is not possible I'm afraid. However I'd love to post a .zip on the 3rd party section, if the templates are generic enough to be interesting to others (which these are )

I'll set up a GotDotNet Workspace as a temporary solution... Can everyone who is interested email me directly with your email address so that I can set you up as Workspace members.

email: llblgen AT styledesign.biz

**GotDotNet Workspaces**
Your request cannot be processed at this time. 
The application may be under heavy load or may be encountering an internal error. 

Will these guys ever get their act together!!!!!

Marcus wrote:

**GotDotNet Workspaces**
Your request cannot be processed at this time. 
The application may be under heavy load or may be encountering an internal error. 

Will these guys ever get their act together!!!!!

GotDotNet is the web-equivalent of hellonearth.exe

There is a workspace of llblgen code (the old DAL generator) but it was SUCH a pain to get stuff uploaded... it made sourceforge's CVS crap look brilliantly smooth.

This thread spawned some discussion here about what to do with our old leased Dell pizzabox online (the one running www.sd.nl and a couple of other sites). I now realize that it might be a good thing to have to offer to a limited group of people to have a sourcecontrol for the templates which is controlled by us and not by some 3rd party like microsoft (which has an EULA you don't want to deal with ).

I'll try to setup Subversion on our box within the hour to see if we can get this running. Stay tuned.

I'm almost done with setting up subversion, there is a little problem at the moment though: the online box is humming along fine but I accidentily closed vnc so I can't reboot it at the moment (it has to be rebooted to open the subversion tcp port) as the poweroutlet apparently isn't connected correctly to the APC online power control (the server was moved last friday) and because the vnc server is closed, I can't reconnect! (yeah, that was pretty silly ). As I've tried as much as possible to lock down the thing I can't get it to start vnc again as I can't login nor start it via a webpage I've uploaded aaaaaaargg....

They're busy with it now, but I don't know how long it will take. As soon as I can reboot the darn thing I'll continue with teh subversion setup and will let you know how to get an account and get access to the repository.

Otis wrote:

... because the vnc server is closed, I can't reconnect! (yeah, that was pretty silly ).

At least you hadn't got the ISP to open up the SQL Server port for your dynamically asssigned IP address so that you could do some major upgrades over the weekend (they don't work the weekends) and half way through (for some reason) you accidentally pull the plug on the router which causes a reboot and a new IP Address

Marcus wrote:

Otis wrote:

... because the vnc server is closed, I can't reconnect! (yeah, that was pretty silly ).

At least you hadn't got the ISP to open up the SQL Server port for your dynamically asssigned IP address so that you could do some major upgrades over the weekend (they don't work the weekends) and half way through (for some reason) you accidentally pull the plug on the router which causes a reboot and a new IP Address

whoa that's also very clever But let's say 'these accidents happen'

(my ISP isn't very fast though, still haven't heard back from them... (*@$$#@)

One thing I want to add when it's under source control is increased support in the generated prefetchs for paging of the child collections. More overloading! Who cares if my assembly is 5 megabytes! WooHoo!

and while we're on it, there was, in another thread, some CLSA discussions. Isn't this template very close to being that already? What's the work to take it there?

Subversion runs. I've mailed 3 people so we can test out write access.

readaccess is anonymous:

svn://www.sd.nl/LLBLGenPro

Nothing there yet, except some dirs

(edit) I've imported the initial templates by chris with the fixes applied to it by Marcus.

Otis wrote:

Subversion runs. I've mailed 3 people so we can test out write access.

readaccess is anonymous:

svn://www.sd.nl/LLBLGenPro

Nothing there yet, except some dirs

(edit) I've imported the initial templates by chris with the fixes applied to it by Marcus.

Frans... I have installed TortoiseSVN, but the Repository Browser is giving me an error when i try to connect to the

svn://www.sd.nl/LLBLGenPro

repository.

I get:

 + svn://www.sd.nl
   Error * No repository found in 'svn://www.sd.nl'

That's teh error you get when you specify

svn://www.sd.nl

or when you have the casing not correct. If I select Repro browser in the tortoisesvn menu and I specify:

svn://www.sd.nl/LLBLGenPro

it works... strange...

Otis wrote:

That's teh error you get when you specify

svn://www.sd.nl

or when you have the casing not correct. If I select Repro browser in the tortoisesvn menu and I specify:

svn://www.sd.nl/LLBLGenPro

it works... strange...

Its working now.... Strange indeed!