By -
Nice things of this week

Hi all,




I have been spending half of the preceeding week coding a little usefull tool : let's say a metacode tool. How many time have you been written the same style business objects, having only accessors (getter and setter) and DAO (Data Acces Objects) functionalities changed. When you have done it twice, you are bored and you don't want to repeat it.

That's why I have stopped all personnals stufs last saturday and have written a Developer experience librarie. Let me give more details about it.


Okay first of all I have set up a basic data acces class with all necessary code to get in to my Sql server database. The tool enable me then to generate automaticcaly the objects acces and manipulations classes with respect to some little conventions. See the sample right there

DevelopersExperienceLibraries.ObjectGenerator myGenerator
= new DevelopersExperienceLibraries.ObjectGenerator();
System.Collections.ArrayList myTypes = new ArrayList();
DevelopersExperienceLibraries.TypeInformation tiIdModule = new DevelopersExperienceLibraries.TypeInformation("_idModule","int",string.Empty,true,true);
DevelopersExperienceLibraries.TypeInformation tiCodeModule = new DevelopersExperienceLibraries.TypeInformation("_codeModule","string","string.Empty",true,true);
DevelopersExperienceLibraries.TypeInformation tiIntitule = new DevelopersExperienceLibraries.TypeInformation("_intitule","string","string.Empty",true,true);
DevelopersExperienceLibraries.TypeInformation tiDureeModule = new DevelopersExperienceLibraries.TypeInformation("_dureeModule","int",string.Empty,true,true);

myGenerator.TypeList = myTypes;
myTypes.Add(tiIdModule);
myTypes.Add(tiCodeModule);
myTypes.Add(tiIntitule);
myTypes.Add(tiDureeModule);

myGenerator.ObjectFileName = "D:\\Elsam\\Internals\\GeneratedClasses\\Module.cs";
myGenerator.ObjectName = "Module";
myGenerator.ObjectNameSpace = "GBusinessDataAcces";
myGenerator.GenerateObjectAccessorsFile();

DevelopersExperienceLibraries.DAOGenerator myDAOGenerator = new DevelopersExperienceLibraries.DAOGenerator();
myDAOGenerator.GeneratorObject = myGenerator;

myDAOGenerator.DataAccesConnectionString = "server=ALAINLOMPO\\\\MYSQLSERVER;DataBase
=TrainingManagement;Uid=muGamma;password=tri_dHg64_dsj";
myDAOGenerator.IdName = "IdModule";
myDAOGenerator.GenerateDAOFile();


I hope the rendering will be nice.
It has been very usefull for me this week, enabling me to generate 18 acces and DAO classes in 4 hours. And everything was going right

Comments

Post a Comment

Popular posts from this blog

By -
We are taking off for a new adventure in development: It's about developing a framework which will enable us to persist our business objects into databases, file systems or xml file system. STEP 1: CREATING A BUSINESSOBJECT ATTRIBUTE namespace ORMCore { /// /// This attribute is used to enable the ORMFramework /// to create an associate table on the RDBMS /// [ AttributeUsage(AttributeTargets.Class, AllowMultiple = false)] public class BusinessObjectAttribute:Attribute { private string _databaseName; public string DatabaseName { get { return _databaseName; } } private string _databaseConnexionString; public string DatabaseConnexionString { get { return _databaseConnexionString; } } public BusinessObjectAttribute(string databaseName) { this._databaseName = databaseName; } public B
Read more
By -
Image
Sql Server adapters for Biztalk Server One of the greatest difficulties I found when I started working with BizTalk 2004 was the lack of documentation about the SQL Adapter. In this article, I'm going to demonstrate how we can use this adapter in an Orchestration of BizTalk. The Example To build this example, we're going to use the Northwind database. We're going to simulate a hypothetical situation where we receive an XML message as a file, containing the order number, a customer ID, and the date of the order. In the orchestration, we will use SQL Server to search the additional information about the customer, using the SQL Adapter. Creating the Project We'll start this article by creating a new BizTalk Server project in Visual Studio. In the Visual Studio .NET menu, select the "New Project" option, and for the type of project, select "BizTalk Projects". Select the template "Empty BizTalk Project" and create a project named OrderManager.
Read more
By -
Writing effective adapters for Biztalk Server Introduction Many people, both within Microsoft and in third-party companies, have written successful adapters for Microsoft® BizTalk® Server. This task can be difficult, and this paper is intended to present some of the "tricks of the trade" that these developers have learned, in the hope that these will help others avoid common problems. This document is structured as a set of issues that programmers face when writing adapters, and provides guidelines for resolving these issues. These guidelines can be read in any order, although you may find that reading the whole document first will make the individual guidelines easier to understand. Effective Writing for Adapters Much of the complexity in writing adapters for BizTalk Server is centered on the problems of batched operations and that is what we will look at first. Operations, Messages, Batching, and Transactions Adapters commonly support sending messages to and receiving messa
Read more