.netTiers Documentation
Table of Contents
Code Generation Top
CodeSmith is a template driven code generator that can be used with VB or C# and can generate any language or text you wish. As developers, several aspects of of our craft have come full circle, where code generation has matured to a point where it has become a necessity and preferred practice. Code generation helps protect against the mistakes of man. Once you've solidified your code generation process, the chance of bugs entering a bug in a certain peice of code drop dramatically. And should a bug appear, you simply have to change your templates and it will correct itself accross the entire application. Much better than the previous way of relying on yourself to find all instances of a scenario where the behavior caused by the bug was failing. Not to take anything away from the extremely powerful refactoring tools today, they help us out tremendously, but they are very limited when it comes down to actually changing behavior, where code generation is much better suited. A CodeSmith template allows you to define properties that can be used along with rich meta-data to create the most powerful of templates, and the best part, it looks and acts just like Asp.net. Your options for a rich meta data include, RDBMS, XML, .net Types, or easily create your own..netTiers, An Introduction Top
.netTiers is a library of open source CodeSmith templates written in C#. The intention of the templates are to assist developers with the intention of eliminating repetative mundane coding, and at the same time, provide a full fledged framework that allows you to get started working on what matters the most to you in your applications. For example, focusing your efforts with the presentation layer, business rules, workflow, and application health for your application to become a success. Consider .netTiers an application block, only specialized to your domain model, and the growth from within the product will more likely be vertically more than horizontally. Meaning, future versions will be focusing on providing more things out of the box which will assist you in your everyday development tasks.The templates effectively build a set of object-relational domain objects for an existing database based off of Model Driven Design (MDD). MDD essentially is the concept where a predesigned model is used to generate your application. MDD was made famouis by many UML modelers, such as Rational Rose, etc. However, with the advent of CodeSmith's rich set meta-data via it's SchemaExplorer, MDD has been particularly easy to adopt for .netTiers through the familiar data model. It's .netTiers responsibility to have the ability to take a good database design and yield a wonderful generated domain for your codebase. Since the majority of business applications revolve around data, .netTiers offers up the ability to work with your data in the easiest way possible as soon as possible.
Current .netTiers Feature Set Top
This is a generalized list of features that .netTiers provides. You can find more information on these topics within the documentation.- Generates a fully compilable solution along with seperate projects and framework tiers for your application. You can start working on an application immediately after generating.
- Creates a full suite of stored procedures that are specialized towards your domain. This code can run inline, as parameterized sql as well and does not have to be used as procedures.
- Automatically generates entity objects and their relationship objects as a domain based on the tables of your database.
- Advanced Enttiy Validation Rule Engine, which can use any of the pre-created or use delegates for any custom rules.
- Classes inlcude both partial classes and concrete classes throughout so that you can customize logic that will not be overwritten.
- Uses a custom generic List<T> for collections that supports all .net ComponentModel interfaces and more, and are Bindable, Sortable, and Filterable.
- Creates a full website project, already pre-configured and ready to begin coding against your data immediately.
- Creates a full set of administration web controls, that serves as a basic yet fully functional web administration console for database.
- Creates a full set of typed DataSource controls for your entire API with design time support, they are similar to the ObjectDataSource, only these are full featured and are actually developer friendly.
- Creates a full webservice API for your domain, perfect for a .net winforms or smart client application and is simple to configure.
- Creates a full suite of unit tests for the data providers and provides about 50% coverage. These tests are for nUnit or Visual Studio Team System.
- Code is fully commented throughout and ready for your documentation needs. Also follows Microsoft naming guidelines throughout.
- Any code placed in a special folder in any of the projects, which by default is called App_Code, will automatically be included the generated project.
- The Data API consists of query support by Primary Key, Foreign Key, Indexes, ManyToMany join relationships, All, Paged Select with Filter, and Find. Along with database write methods such as Insert/Update/Delete
- You can create your own custom stored procedures for your entities and .netTiers will generate a wrapper and all the plumbing for that procedure. This enables you to have your own logic within the .netTiers API.
- much, much, more. honest.
Getting Started Top
.netTiers are a set of templates written in C# and is built to work with the CodeSmith template code generation platform. CodeSmith itself uses a familiar Asp.net syntax so .netTiers is not written in any obscure language or syntax that you couldn't sit down and understand what's going on in a very short time. The power of .netTiers is that it's a templatized approach to a common problem, and does not prohibit you from changing things or knowing what's going on under the covers.2. Installing .netTiers Top
Once you have downloaded the .netTiers .zip file from the www.netTiers.com/download website, simply extract the files to your favorite projects directory. It's required that you have CodeSmith installed and registered by this point on your system. Here's a glimpse into what you'll see when you extract the directories. We'll delve more into the folder hierarchy later, but right now we're simply interested in doing our first generation.
Folder Structure:
![PS_00_FolderStructure.gif](http://www.nettiers.com/Img/PS_00_FolderStructure.gif)
3. Required Setup Top
To execute, you simply have to run (double-click) the main template, NetTiers.cst found in the root of the folder found where you extracted the templates.
01. Getting Started - Required Properties:
![PS_01.gif](http://www.nettiers.com/Img/PS_01.gif)
Choose Source Database:
This property is the heart of the .netTiers meta data for generation. You should select the database that the tables views, and stored procedures should be based on for generation. IMPORTANT!!! If SourceTables and SourceViews are left blank, the Entire Database will then be generated.
Choose DataSource:
![PS_01_ChooseDb.gif](http://www.nettiers.com/Img/PS_01_ChooseDb.gif)
If you don't see your datasource, you will have to create one of your own, click Add.
![PS_01_CreateDB.gif](http://www.nettiers.com/Img/PS_01_CreateDB.gif)
![PS_01_Setup.gif](http://www.nettiers.com/Img/PS_01_Setup.gif)
Now that you've created your own entry, you can select it for generation. Setting this property will also try to default the the values of the OutputDirectory and your RootNameSpace by appending the datasource name to them. Depicted to the in the image above, Northwind was selected as our datasource, and the output directory appended became "C:\NetTiers\Northwind" and Northwind also became the root namespace.
OutputDirectory: The root windows directory to output the generated project to. It's usually best that this be a new directory unless you've worked with the templates for awhile.
RootNameSpace: Root namespace for generated projects and C# classes. This will be the prefix for the other project namespaces. Example: If you enter NetTiers.Northwind here, and you enter Entities in BLLNamespace, then you will see NetTiers.Northwind.Entities for your Entity Layer.
Note: This is all that is required to generate a successful Data Access Layer from the .netTiers templates. There are many more options and other layers you can generate, you can skip down to #4, Configuration if you don't want to see the added generation options.
4. Advanced Setup Top
01b. Filter by Individual Objects - Optional: Top
![PS_01b.gif](http://www.nettiers.com/Img/PS_01b.gif)
![PS_01b_Setup.gif](http://www.nettiers.com/Img/PS_01b_Setup.gif)
SourceViews: The views you wish to generate into entities, if you do not select any SourceTables or SourceViews, and SourceDatabase is completed, then the entire database will be generated.
![PS_01b_Filled.gif](http://www.nettiers.com/Img/PS_01b_Filled.gif)
02. Framework Generation - Optional: Top
![PS_02.gif](http://www.nettiers.com/Img/PS_02.gif)
ExecuteSql: If true the stored procedures are attempted to be installed on the sql server for you. (The SQL file is still generated and placed in the Namespace.SQL directory).
IncludeComponentLayer: The pattern type to implement in the Component Layer. The component layer is considered to be where you core business rule implementations and in new implementations should be the entry point into your domain logic. You can choose either Service Layer (like the Manager pattern), or Domain Model.
NOTE: The ServiceLayer is by far the most flexible and offers advanced features throughout the framework, like a workflow pipeline and a workspace. The DomainModel should be used on basic applications and prototypes not requiring advanced workflow and loose coupling logic.
IncludeDatabaseFeatures: Indicates which database specific features to generate. The default is SQL 2000 compatibility, but you can select optionally choose Sql2005, which will generate optimized paging procedures specifically for SQL Server 2005.
![PS_02_Filled.gif](http://www.nettiers.com/Img/PS_02_Filled.gif)
- None: No unit test should be included.
- NUnit: No tests should be generated.
- VSTS: Visual Studio Team System tests should be included.
IncludeXmlAttributes: Indicates if the Xml attributes, [XmlElement(IsNullable=true)], should be included on all of the entity classes.
LaunchVisualStudio: Attempts to launch Visual Studio with the generated solution only if there are no instances already open.
SQLFolderName: The sub-folder to output the SQL scripts. This name is appended to the RootNameSpace, so if you enter SQL the folder will be RootNameSpace.SQL
ViewReport: Indicates if the HTML generation report should be shown at the end of the report.
03. Namespaces - Required: Top
![PS_03.gif](http://www.nettiers.com/Img/PS_03.gif)
ComponentLayerNameSpace: The sub-namespace for the given business layer you choose in the IncludeComponentLayer property. So if RootNameSpace = "Northwind", and this property is "Services" the resultant namespace for the services would Northwind.Services
DataAccessLayerNameSpace: The sub-namespace that is added to the root namespace for the Base Data Access Layer. So if RootNameSpace = "Northwind", and this property is "Data" the resultant namespace for the base data access layer would Northwind.Data
UnitTestsNameSpace: The sub-namespace that is added to the root namespace for the UnitTest Layer. So if RootNameSpace = "Northwind", the resultant namespace for the unit test swould Northwind.UnitTests
04. General - Advanced: Top
![PS_04_Filled.gif](http://www.nettiers.com/Img/PS_04_Filled.gif)
CompanyURL: The URL of your company, or client's company. This is only for documenation and any references to the company.
SignAssembly: If true, the generated projects, when building, will try to sign the assemblies and search for the snk in the local root directory(OutputDirectory). This strong names your assemblies and is useful for advanced .net options and security.
05. WebLibrary - Advanced: Top
![PS_05.gif](http://www.nettiers.com/Img/PS_05.gif)
IncludeDesignTimeSupport: Indicates if Visual Studio design-time support should be provided for the Web Library Typed DataSource controls.
06. Web - Advanced: Top
![PS_06.gif](http://www.nettiers.com/Img/PS_06.gif)
GenerateWebService: Indicates if the Webservice DataAccess Provider should be generated. If you are in a situation where you need to create an EndPoint of your Data API, then include this option.
WebAdminOutputPath: The full path for generated WebAdmin UserControl files.
WebServiceOutputPath: The full path for the the WebService files. This path must match with the WebserviceURL in IIS.
WebServiceURL: The base URL for the webservice specified above in WebServiceOutputPath, eg: http://localhost/NetTiersWS.
06b. Website - Advanced: Top
![PS_06b.gif](http://www.nettiers.com/Img/PS_06b.gif)
IncludeAtlasLibrary: Indicates whether to include a reference to the Microsoft Atlas Component Library in the website generated. This is useful if you want to immediately take advantage of the Microsoft Atlas Framework in your WebForms.
IncludeAtlasToolkit: Indicates whether to include a reference to the Atlas Control Toolkit. This property is only taken into account when IncludeAtlasLibrary is true. The Microsoft Atlas Toolkit is a set of advanced controls that take full advantage of ajax and javascript behaviors.
![PS_06b_Filled.gif](http://www.nettiers.com/Img/PS_06b_Filled.gif)
UseWebAppProject: Indicates if a Web Application Project file should be generated. Note: you must have the Visual Studio Maintenance Patch and the WebApplication Projects Visual Studio Extension installed in order to use this feature. This creates a project file for website project much like Visual Studio 2003.
07. - CRUD Advanced: Top
![PS_07.gif](http://www.nettiers.com/Img/PS_07.gif)
CustomProcedureStartsWith: include custom stored procedures, this is the pattern that NetTiers will look for your custom stored procedures to start with. A string format will be used to match the beginning of the procedure pattern. So, {0}=TableName, {1}=ProcedurePrefix(See Property Below). By default NetTiers will look at tables that starts with '_{0}_', which means it will detect the procedure _TableName_GetByBirthdate and generate the necessary plumbing to wrap your custom stored procedure. Your new method can be accessed by DataRepository.TableNameProvider.GetByBirthdate();
IncludeCustoms: Indicates if you would like .netTiers to attempt to generate wrappers into the API for your custom stored procedures.
IncludeDelete: If true delete procedures will be generated into the API.
IncludeDrop: If true drop comands along with all of the stored procedures will be generated.
IncludeFind: If true Find procedures will be generated into the API.
IncludeGet: If true Get procedures will be generated into the API.
IncludeGetList: If true GetList procedures will be generated into the API.
IncludeGetListByFK: If true GetList By Foreign Key procedures will be generated into the API. So if your Order Table has a CustomerId column in it, and its a foreign key back to your Customers Table. Then a method called GetByCustomerId(int customerId) will be created.
IncludeGetListByIX: If true GetList By Index procedures will be generated into the API. So if your Order Table has a Status column in it, and its an index onf your Orders Table. Then a method called GetByStatus(string status) will be created.
![PS_07_Filled.gif](http://www.nettiers.com/Img/PS_07_Filled.gif)
IncludeManyToMany: If true .netTiers will attempt to gain insight into your many to many relationships and generate procedures into the API.
IncludeRelations: If true .netTiers will use the your database meta data to discover relationships and will generate into the API.
IncludeSave: If true save methods will be generated into the API that wrap Insert/Update/Delete.
IncludeUpdate: If true update procedures will be generated into the API.
IsolationLevel: Isolation level to use for the generated procedures.
RetryEnabled: Enabling Retry will add code retry the queries that failed with data exceptions. Useful to if your database becomes temporarily unavailable. Use with caution in that if a transaction fails in the database, then the retry can not continue because the transaction is now in a failed state.
RetryMaxAttempts: The number of attempts that will be made.
RetrySleepStyle:
- Constant - Each sleep will be the n milliseconds.
- Linear - Each sleep will increase by n*attempts milliseconds.
- Exponential - Each sleep will increase exponential by n^attempts milliseconds.
08. Stored Procedures - Advanced: Top
![PS_08.gif](http://www.nettiers.com/Img/PS_08.gif)
FindSuffix: Suffix to use for all generated selective FIND stored procedures.
GrantUser: Optional user or role to GRANT EXEC Procedure permissions to
ProcedurePrefix: The prefix to attach to the stored procedure names, ex: "usp_" will give you "usp_Orders_GetList"
SelectAllSuffix: Suffix to use for all generated selective SELECT stored procedures.
UpdateSuffix: Suffix to use for all generated selective Update stored procedures.
09. CodeStyle - Advanced: Top
![PS_09.gif](http://www.nettiers.com/Img/PS_09.gif)
Alias.txt
------------------------------
Customers:Customer Orders:OrderBaseClassFormat: The format for any base class name. Parameter {0} is replaced by the original class name.
CollectionFormat: The format for any collection class name. Parameter {0} is replaced by the collection item class name.
EntityFormat: The format for entity class name. Parameter {0} is replaced by the trimmed table name, in Pascal case.
GenericListFormat: The format for the tables generic class name. Parameter {0} is replaced by the name of the class that will be stored in the list.
GenericViewFormat: The format for the views generic class name. Parameter {0} is replaced by the name of the class that will be stored in the list.
InterfaceFormat: The format for any interface name. Parameter {0} is replaced by the original interface name based on the class name.
ManyToManyFormat: The format for many to many methods. Parameter {0} is replaced by the secondary class name
ProviderFormat: The format for any provider class name. Parameter {0} is replaced by the original class name
StrippedTablePrefixes: The table prefixes to strip from the classes name, delimited by comma.
5. .netTiers Generation Top
Generate:
![PS_10_generate.gif](http://www.nettiers.com/Img/PS_10_generate.gif)
Save Property Set: The first thing you want to do is save your property set, which is noted by the Arrow and turquoise highlight. This enables you to quickly reload your property without having to re-configure your property set.
Expand Window: Second, click the arrows depicted by the green area to expand the window so you can see the Template Output. This will let you see any error messages, if any.
Generate: Third, click the generate button and wait approximately 30 seconds to 2 minutes depending on this size of the database. Depending on whether or not you chose to view the Generation Report, once .netTiers is completed, your default browser will pop-up showing the generation report.
Reading the Generation Report: Top
![PS_10_Report.gif](http://www.nettiers.com/Img/PS_10_Report.gif)
Summary: The summary section of the report gives you an overall synopsis of total objects or errors that occured during the generation process.
Configuration: The .netTiers Quick Configuration is a section that enables you to quickly configure your winforms or web application. Essentially it requires you to add a section to your configuration section to your web/app config of the NetTiersServiceSection. This allows .netTiers to read critical information during runtime.
Documentation: The documentation section has a link back to the official .netTiers documentation. Which will most likely be this file. It also contains a very useful quick start of sample API calls, which is meant to get you used to how you make calls into your customized API.
Details - Generated Classes: This is a "rather long" list of all your generated objects. This is useful if you added a new table to your generation process, but you don't see the objects for them, you can check here and verify if the table actually got created.
Verifying Complete Generation: Top
![PS_11_Folders.gif](http://www.nettiers.com/Img/PS_11_Folders.gif)
Browse to OutputDirectory: Using Windows Explorer, browse to the OutputDirectory that you chose earlier in the setup process. You will see a solution file, along with several directories. Each directory represents usually Tier in generated code. Let's make sure your generation process was completely successful before you import this into an existing solution if you already have one.
Open Solution: Double click this solution file. You can later attach any new project to this solution. However, even if you're starting from scratch we recommend making a new solution, that is yours and simply importing this solution into your solution. This will allow you to change things up as much as you want in a flexible manner and still not have to worrry about ruining anything. Things like SCC can potentially change the way you work with the templates, so careful seperation will allow you to be happy with the results. This new solution can be a Master Solution of sorts that can contains a web/winforms app, and includes the NetTiers projects. You would also have our Generated solution, which is nice and lean for your quick entity and data layer modifications.
![PS_12_VSOpen.gif](http://www.nettiers.com/Img/PS_12_VSOpen.gif)
Compile Solution:
Now that you're solution is open, the first thing we want to do is build all the libraries to ensure that .netTiers generated valid c# code. If you've configured your solution as I have, that's 7 projects that were fully generated for you.
How's that for a Time Saver!
![PS_12_Build.gif](http://www.nettiers.com/Img/PS_12_Build.gif)
Build Result: You can monitor the build process through the output window, we've shown it here completed and more importantly successful.
![PS_12_BuildReport.gif](http://www.nettiers.com/Img/PS_12_BuildReport.gif)
6. .netTiers Configuration Top
Generate:
![PS_13_Configuration.gif](http://www.nettiers.com/Img/PS_13_Configuration.gif)
Open Web/App.config: Opening the web/app configuration. If you've chosen to have .netTiers generate a web application project for you, then you should already have a configuration that is property configured. You can choose to skip over this step. Otherwise, if you're working on an existing project or a winforms application, then follow along.
The configuration depicted has the configuration along with the Enterprise Library and Atlas configuration.
The configSection that you need to be concerned with is:
<section name="Northwind.Data" type="Northwind.Data.Bases.NetTiersServiceSection, Northwind.Data" allowDefinition="MachineToApplication" restartOnExternalChanges="true" />
Remember, the Connection String name corresponds to the Asp.Net ConnectionString config section you are using. The Northwind.Data Section of the configuration is the critical data that .netTiers needs to know in order to run successfully at runtime.
Name: This is the name of your provider. You will be able to access this provider by name if you don't configure it as the default provider.
Type: This is the Fully qualified Type string of this configured provider.
ConnectionStringName: The first thing you want to do is save your property set, which is noted by the Arrow and turquoise highlight. This enables you to quickly reload your property without having to re-configure your property set.
EntityFactoryType: The entity factory type provides an entity creational factory that dynamically finds where your entity is located and creates a version of that entity. hooks for user interaction during the creational process of the entity. It allows you to maybe subscribe to event if you needed to or have something process the entity prior to setting the data from the data reader. This is also useful in case you've selected the DomainModel, in which case, you want to create Domain objects, but they are not visible to the Data Layer, so you would have to "discover" these types.
Ex:Northwind.Entities.EntityFactory
UseEntityFactory: Indicating if you want to use the EntityFactory for creation of the entities. This is required to be true, if youv'e selected the domain model.
EnableEntityTracking: This allows you to have a performant entity cache using Enterprise Library's ObjectBuilder, Locator class in your application using weak references so that if there no references to the entity, it will be garbage collected.
EnableMethodAuthorization: If using one of the two component layer projects, this will enable runtime code authorization utilizing Microsoft Asp.net's Role Provider and Microsoft Enterprise Library Authorization Provider. You might want to leave this as false until you can get a grasp of the framework, and have time to configure the required rules for using Method Authorization.
UseStoredProcedure: If you chose not to execute all of those procs onto the server, there is a file called procedures.xml that essentially is an xml抏d version of the procedures. Setting useStoredProcedure to false, causes NetTiers to simply use parameterized SQL instead of the crud procs. This is useful if you would like to organize your stored procedures.
7. Ready to Code Top
Typed DataSource:
![PS_14_WebForm1.gif](http://www.nettiers.com/Img/PS_14_WebForm1.gif)
Strongly Typed DataSource controls: You will find that just by typing <data: you will see a list of your DataSource controls ready to be used to get ahold of your data. These maintain the ObjectDataSource controls event model, except they are geared to your data.
![PS_14_WebForm2.gif](http://www.nettiers.com/Img/PS_14_WebForm2.gif)
![PS_14_WebForm3.gif](http://www.nettiers.com/Img/PS_14_WebForm3.gif)
Design View:
![PS_14_WebForm4Designc.gif](http://www.nettiers.com/Img/PS_14_WebForm4Designc.gif)
Taking the form and selecting only the columns that I want, we create a nice grid.
Here's the result of of the form. The wonderful part of the Typed DataSource control is that you don't have to do anything when you want to edit/insert/delete an object. You simply have the grid call the Edit/Delete/Insert command, which can be done a variety of ways in ASP.net 2.0.
![PS_14_WebForm4DesignResults.gif](http://www.nettiers.com/Img/PS_14_WebForm4DesignResults.gif)
Edit:
![PS_14_WebForm4Edit.gif](http://www.nettiers.com/Img/PS_14_WebForm4Edit.gif)
After Edit:
![PS_14_WebForm4EditComplete.gif](http://www.nettiers.com/Img/PS_14_WebForm4EditComplete.gif)
Include Directives:
![PS_14_WebFormCodebehind.gif](http://www.nettiers.com/Img/PS_14_WebFormCodebehind.gif)
How to Access Code:
![PS_14_WebFormCodebehind2.gif](http://www.nettiers.com/Img/PS_14_WebFormCodebehind2.gif)
Quick Start Sample API: Top
Working with the Code: Top
You will quickly discover that while there is a slew code being generated, the concepts themselves are simple, and familiar concepts based on proven practices and patterns.
8. Architecture Top
.netTiers Architecture: Top
This data tiers concept is composed of custom business entities components (the data itself) and data access logic components (the persistence logic).
This design is inspired from the Microsoft patterns & practices guide:
Designing Data Tier Components and Passing Data Through Tiers:
![design.gif](http://www.nettiers.com/Img/design.gif)
.netTiers Patterns: Top
The .netTiers team tries very hard to write an application with best practices in mind. We've followed the guidances given from Microsoft in how best to use their platform, this includes the usage of many of the Microsoft Patterns and Practices Team Libraries.
Here's general information on the patterns used in .netTiers 2.
Information mostly aggregated from these wonderful developer resources:
patternshare.org | dofactory.com | DavidHayden.com
ServiceLayer
http://patternshare.org/default.aspx/Home.MF.ServiceLayer
Processors
By default is a Pipeline:
http://patternshare.org/default.aspx/Home.HW.PipesAndFilters
but easily can be used with workflow management in:
http://patternshare.org/default.aspx/Home.HW.ProcessManager
Each Processor -
Command
http://www.dofactory.com/Patterns/PatternCommand.aspx
Flexible enough to be used within a strategy passed into the ctor to manage different behaviors in complex logic.
http://www.dofactory.com/Patterns/PatternStrategy.aspx
DomainModel + ActiveRecord
http://patternshare.org/default.aspx/Home.MF.DomainModel
http://patternshare.org/default.aspx/Home.MF.ActiveRecord
Data Access Layer
DataRepository.cs - Singleton, Decorator
http://patternshare.org/default.aspx/Home.PP.Singleton
http://www.dofactory.com/Patterns/PatternDecorator.aspx
Uses the entities as Data Transfer Objects:
http://patternshare.org/default.aspx/Home.MF.DataTransferObject
Repository Provider:
http://davidhayden.com/blog/dave/archive/2004/05/19/259.aspx
Entity Layer - Factory, Memento, State
Entity - Memento, State, DomainModel, TableModule
http://www.dofactory.com/Patterns/PatternMemento.aspx
http://www.dofactory.com/Patterns/PatternState.aspx#_self2
http://patternshare.org/default.aspx/Home.MF.DomainModel
http://patternshare.org/default.aspx/Home.MF.TableModule
Entity Factory
http://www.dofactory.com/Patterns/PatternFactory.aspx
WebService Client - Proxy
http://www.dofactory.com/Patterns/PatternProxy.aspx
New Sql Expression Code - Builder
http://www.dofactory.com/Patterns/PatternBuilder.aspx