Uploaded MyGeneration Templates for C# Code for my N-Layer Design Articles

I just uploaded a ZIP file with four MyGeneration templates to generate C# and SQL code that matches the model in my articles about N-Layer design.

You will find the additional download at the end of each of the three parts of the article series.

Additionally, you can download the new C# files here while the older VB version can be found here.

Please note: I didn't write, nor test these templates. Use them at your own risk. If you have comments, questions, additions or new versions of these templates that you want to share: let me know and I'll try to put you in touch with the original author, and update the templates on my site.

Have fun!!


Where to Next?

Wonder where to go next? You can read existing comments below or you can post a comment yourself on this article .

Consider making a donation
Please consider making a donation using PayPal. Your donation helps me to pay the bills so I can keep running Imar.Spaanjaars.Com, providing fresh content as often as possible.

Feedback by Other Visitors of Imar.Spaanjaars.Com

On Wednesday, June 4, 2008 7:02:14 AM Donna said:

It sounds like you use MyGeneration.  Does this tool generate DAL and BAL as you described in your project?

I'm curious if it just does the DAL or if it also does the business object managers and so forth as you described.

Would you recommend MyGeneration for code generation in .NET to speed up the development process?  What about others compared to this one such as CodeSmith or MySpace?

Thanks for any feedback.

On Wednesday, June 4, 2008 7:28:51 AM Imar Spaanjaars said:
Hi Donna,

Sounds like? Quote from my post:

>> I just uploaded a ZIP file with four MyGeneration templates

How more concrete does it get?

As I indicated earlier, I didn't write these templates, but I am pretty sure they generate everything you need including sprocs, BO's and so on.

I would certainly recommend them to speed up the process of writing tedious code. It gives you a nice start of your object model which you can then further customize.

Not much experience with CodeSmith and MySpace so I can't comment much on that.


On Wednesday, July 23, 2008 11:09:09 PM Rick Gibson said:
I use Vb.Net do you have any templates that you can recommend for me to use?
On Thursday, July 24, 2008 5:59:05 AM Imar Spaanjaars said:
Hi Rick,

Check out the Downloads section at the end of each of the three articles. You'll find VB versions of the template.


On Monday, September 22, 2008 8:13:07 AM irmanator said:
Hi Mr. Imar

I would like to thank you of your explanation of DAL-BO-BLL, something that light people on. As a newbie of ASP.NET based on VB now i take a look at your mygeneration templates to N-Layers.

I found something you missed Mr. Imar.
Your mygeneration in C# zipped file has 5 files (1 readme and 4 mygeneration templates), but

mygeneration VB.NET zipped file has 4 files (1 readme and 3 mygeneration templates), i think you missed to put 1 template file SQL_StoredProcs With Upsert.vbgen.

It doesn't matter anyway, thank you.

Best regards.

On Monday, September 22, 2008 9:08:04 AM Imar Spaanjaars said:
Hi irmanator,

Thanks for bringing that to my attention. As I said in this post, I didn't write nor test them, so it never occurred to me something was missing.

Did you try them out? If so, is the sproc generator from the C# download compatible witn the VB version?

On Monday, September 29, 2008 7:13:22 PM irmanator said:
Yes, sproc generator from C# compatible with VB version.
I report you that i had to made little tune up at mygeneration DAL template VB version, little bug in FillDataRecord output, but overall it works well.


On Monday, September 29, 2008 7:32:09 PM Imar Spaanjaars said:
Hi irmanator,

Thanks for the update.



Talk Back! Comment on Imar.Spaanjaars.Com

I am interested in what you have to say about this article. Feel free to post any comments, remarks or questions you may have about this article. The Talk Back feature is not meant for technical questions that are not directly related to this article. So, a post like "Hey, can you tell me how I can upload files to a MySQL database in PHP?" is likely to be removed. Also spam and unrealistic job offers will be deleted immediately.

When you post a comment, you have to provide your name and the comment. Your e-mail address is optional and you only need to provide it if you want me to contact you. It will not be displayed along with your comment. I got sick and tired of the comment spam I was receiving, so I have protected this page with a simple calculation exercise. This means that if you want to leave a comment, you'll need to complete the calculation before you hit the Post Comment button.

If you want to object to a comment made by another visitor, be sure to contact me and I'll look into it ASAP. Don't forget to mention the page link, or the QuickDocId of the document.

For more information about the Talk Back feature, check out this news item.