CodeSmith Community

Martin Olivares Asp.net, Ajax and NetTiers experiences: Efficient Nettiers Deepload - Filling object graphs in just one database call

Blake Niemyjski — Tue, 31 Aug 2010 12:48:22 GMT

After using several ORM's I found that when need a complete object graph or some related entities (INNER/LEFT JOIN "like") they haven't an efficient approach built-in. Almost all ORM can lazy load related properties (collections or instances) that means additional db calls and specifically in Nettiers filling an object with n-childs implies (n+1) database calls with the related performance penalty. On this post, I want expose one alternative to populate an entire object graph in...(read more)

PLINQO at Chris McGrath's Blog

Blake Niemyjski — Tue, 31 Aug 2010 12:48:19 GMT

I've been looking a PLINQO , it's quite interesting. I'm a huge fan of LINQ in general. PLINQO is like Linq to SQL, with improvements. The big ones for me are ones which make talking to the database more efficient. ......(read more)

mojoPortal - Generating Code with CodeSmith

Blake Niemyjski — Mon, 30 Aug 2010 17:35:07 GMT

If you have the mojoPortal source code, we have a number of Codesmtih templates for code generation that can be used to jump start your development. They are located in the CodesmithTemplates folder. You can still download the older freeware version of Codesmith 2.6 , though I highly recommend getting the newer version from http://www.codesmithtools.com/ , most of our templates do still work with the older freeware version. About the mojoPortal Codesmith Templates We've created a variety of Codesmith...(read more)

C# rocks!: Using codesmith with postgresql for NHibernate

Blake Niemyjski — Mon, 30 Aug 2010 00:59:23 GMT

You could say that this post is a modification of ( http://www.codesmithtools.com/video/nhibernate.html ) when you don't have working visual studio integration and/or you want to use codesmith with Postgresql+NHibernate This is how to use Codesmith professional version 5.1 without visual studio with Postgresql to generate nhibernate templates. First download the Npgsql (version Npgsql2.0.2-bin-ms.net.zip ). Extract and copy the "Npgsql.dll" and Mono.Security.dll" files to GAC ...(read more)

Getting a Jump Start on mojoPortal Development with Codesmith

Blake Niemyjski — Tue, 24 Aug 2010 13:27:03 GMT

Tutorial video about code generation for mojoPortal using Codesmith tools....(read more)

CodeSmith Tips & Tricks: Template Recursion

Blake Niemyjski — Tue, 24 Aug 2010 13:27:02 GMT

Here is a simple CodeSmith template that shows how templates can be recursively called, have indentation levels and render to a single output: @ CodeTemplate Language ="C#" TargetLanguage ="C#" ClassName ="RecurseSampleTemplate" %> @ Property Name ="InRecurse" Type ="System.Boolean" %> // Sample header if ( this .InRecurse) { %> // Nested class } else { %> // Parent class RecurseSampleTemplate recurseSample = new RecurseSampleTemplate...(read more)

Implementing Simple Cache For Codesmith And Nettiers Asp Net 2 0 ...

Blake Niemyjski — Mon, 23 Aug 2010 14:38:53 GMT

Configuration Sources ... This way, the new project can be in ASP.Net, VB. ... I used CodeSmith Tools and . netTiers 2.2.0 to generate the code for my DB but ... www.alhamsyah.com/.../implementing+simple+cache+for+cod......(read more)

Modified CodeSmith MSSQL Store Procedure Template

Blake Niemyjski — Mon, 23 Aug 2010 14:38:53 GMT

Recently I was working on one project where I needed to have store procedure that is bit different from those available in templates so i modified one existing to add my own implementation. I am more than happy if someone else find it useful for his work,though code formatting is bad still it is nice template to be in collection Here It is...(read more)

.Nettiers problem when changing column type

Blake Niemyjski — Sun, 22 Aug 2010 19:01:52 GMT

When using .nettiers I have found a problem of generation when changing column type. The only way to resolve this problem on my point of view was to select another name for that column. This change will be a huge problem as sometimes this column is used in stored procedures, functions or buisness layer. One day I decided to spend a time looking for a solution for this problem. I tried to change column name and rebuild then change it back, generate and rebuild, but the problem was still existing ...(read more)

LINQ to SQL with PLINQO « MP Blog

Blake Niemyjski — Mon, 16 Aug 2010 13:22:01 GMT

So after a bit of frustration and the reluctance to add the 1 new field manually I began searching again and came accross some very very cool LINQ to SQL Templates, PLINQO is not just a mere template, its a whole bunch of awesome stuff ... MP Blog - http://meikleprogramming.wordpress.com/...(read more)

PLINQO: Keeping LINQ-to-SQL Viable

Blake Niemyjski — Mon, 16 Aug 2010 13:22:00 GMT

Are you tired of writing database access code by hand, but don't want to deal with the bloat of Microsoft's Entity Framework or mess around with complex config files for some of the other ORM solutions out there? I've been using CodeSmith's PLINQO (Professional LINQ to Objects) for over four months now, and I'm quite impressed by it....(read more)

Generating Generic CSLA Objects Using Codesmith

Blake Niemyjski — Fri, 13 Aug 2010 14:44:35 GMT

This post will focus on the generation of generic objects based on database metadata using CodeSmith Studio and the included CSLA generation templates. For those of you unfamiliar with CodeSmith or CSLA here are the relevant sites for your reference: http://www.codesmithtools.com/ http://lhotka.net/ For those of you who are already familiar with these tools, please, read on. Most .NET developers should already be familiar with generics so I will skip the theory behind generics and get straight into...(read more)

A Nightmare of Insanity: PLINQO

ejsmith — Fri, 13 Aug 2010 03:25:30 GMT

PLINQO solves so many of my Linq problems and saves me writing so much code that I would have had to do before, its unbelievable. The rules engine alone completely frees me from writing my own constraints! ... A Nightmare of Insanity - http://win2k3admin.blogspot.com/...(read more)

Continuous Generation: Generating the code during every build using TFS and CodeSmith Tools

Blake Niemyjski — Wed, 11 Aug 2010 12:44:14 GMT

Doing builds and running unit tests after every check-in has become a standard practice in Agile and non-Agile development teams. Continuous Integration is the term that describes this process and helps ensure that that nothing has been broken since the last check-in. One area that is sometimes overlooked is the code generation. Continuous Generation, the re-generating of code / stored procedures for every check-in and build, should be considered for your TFS builds. I believe there is a lot of benefit...(read more)

.NetTiers with CodeSmith: An ERP best practice tool

Blake Niemyjski — Wed, 11 Aug 2010 12:44:10 GMT

I worked on .NetTiers Framework with some talented professionals for more than two years. We successfully used .NetTiers to generate Enterprise Entity as a LOB resource to support ERP applications. The Database can be as large as over 200 tables, with very complicate Data Model and relationships....(read more)

James Dawson's Blog : Using Visual Studio Solution Files with MSBuild

Blake Niemyjski — Thu, 05 Aug 2010 16:50:56 GMT

As previously discussed by Simon , there are issues with pointing MSBuild at a Visual Studio solution file to build your project assemblies - the alternatives are to either build each of the projects individually (using tasks) or to call VS itself to build the solution (the SDC Build Tools project has a custom task to easily do this). The former approach causes some maintenance headaches by requiring the MSBuild script to be updated anytime a project is added or removed from the solution - whereas...(read more)

CodeSmith or: How I Learned to Stop Worrying and Love Code Generation

Blake Niemyjski — Thu, 05 Aug 2010 16:50:56 GMT

One of my Xmas hobby projects was to produce a WinForm GUI for creating and editing Microsoft SDC Build Tool configuration files – I really wanted to make it much easier for developers (and myself) to manage SDC build scripts – I’m sure I’m not the only person who gets giddy and disoriented navigating around any script that’s over 20 or so steps long. I’ve been ruminating about this utility for quite a while – and after my experience developing PeopleFinder – I decided that The Netron Project was...(read more)

How-to: Rename your generated CSLA property names

Blake Niemyjski — Tue, 03 Aug 2010 22:29:35 GMT

In the following example, I'll show you how to use the CodeSmith CSLA template's powerful renaming options. Many of you might have a legacy database with those ugly prefixes, or things you wish you could refactor but just can't. Luckily, you're in luck as CodeSmith is going to save the day once again! By default we will strip any invalid characters from your property names like prefixed digits etc... Please note that these methods also work for renaming class names, but there are...(read more)

Tip of the Day: Retrieve the unique columns from a table

Blake Niemyjski — Tue, 03 Aug 2010 13:03:42 GMT

Today I was setting up a new template, and I needed to look at the unique constraints as part of my task. The following CodeSmith script will load the columns that have unique constraints (but not the primary key) into an ArrayList. ArrayList uniqueColumns = new ArrayList(); for ( int i = 0; i if (SourceTable.Indexes[i].IsUnique) { for ( int y=0; y if (!SourceTable.Indexes[i].MemberColumns .IsPrimaryKeyMember) uniqueColumns.Add(SourceTable.Indexes[i].MemberColumns .Name); } } }...(read more)

MSDotNetBuddy: The BLL CodeSmith Template

ejsmith — Sat, 31 Jul 2010 17:02:35 GMT

CodeSmith .BaseTemplates.SqlCodeTemplate" TargetLanguage="T-SQL" Description="Generate Collection based class" %> ... MSDotNetBuddy - http://msdotnetbuddy.blogspot.com/...(read more)

How-to: Using a Stored Procedure extended property to preserve custom logic in the CSLA generated code.

Blake Niemyjski — Fri, 30 Jul 2010 09:51:11 GMT

In the previous article on how to use the partial methods in the CodeSmith CSLA templates to preserve custom code mostly focused on the code side of things. For those of you who might be using Stored Procedures might be wondering... How do I accomplish preserving my custom stored procedure logic? Don't worry, CodeSmith already though of this and didn't leave you out in the dark! The CSLA templates by default will not automatically execute the generated stored procedures but it can! To do...(read more)

How-to: Using the CSLA partial methods to preserve custom code and promote active regeneration.

Blake Niemyjski — Thu, 29 Jul 2010 21:46:00 GMT

One of the best features of code generation is the reality of being able to actively generate you code while preserving custom changes. This allows you to implement custom logic while constantly making changes to your metadata and getting the latest template changes. CodeSmith has worked hard on making this happen in both the PLINQO and CSLA Templates . The CSLA templates offer many partial method overrides to make your life easier. It is recommended that you place any partial methods that you implement...(read more)

Ten Must-Have .NET Tools Every Developer Should Download Now

Blake Niemyjski — Thu, 29 Jul 2010 18:55:40 GMT

CodeSmith templates are simply text files which you can create in any text editor. Their only requirement is that they be saved with the .cst file extension. The sample template that I'm going to build will accept a string and then build a class based on that string....(read more)

NetTiers Notes - When deploying to .NET 4.0

Blake Niemyjski — Thu, 29 Jul 2010 12:52:46 GMT

I wanted to add a few notes to myself about some changes I might want to remember the next time I use NetTiers: In Design View: http://community.codesmithtools.com/nettiers/f/30/p/7803/30149.aspx#30149 (updating Visual Studio to 2010) When deploying on .NET 4.0, remove: --> If regenerating a template, you probably will need to change the following in GridViewSearchPanel.cs if you are using an image button: ImageButton cmdSearch = new ImageButton(); cmdSearch.ID = "cmdSearch"; cmdSearch...(read more)

CodeSmith XAML Templates « Oscar Agreda's Blog

Blake Niemyjski — Thu, 29 Jul 2010 12:52:46 GMT

As I get more and more comfortable with Entity Framework, Ria Services and XAML on the VS 2010, I realize that there are some simple things within the XAML that can be automatically generated from the Database using code generator like Code Smith, that Microsoft absolutely miss by doing in in T4. One of these features is the ability to add more attributes to the XAML created when you drag and drop a Datasource in the current XAML Page, Child Window or Custom Control. I think the best way to describe...(read more)