Download the CommunityDrop1 from here.
Example 4 Generating Class from SqlServer TableSchema
Step1 Opening Existing Template
Open Example4 from Example_Projects folder, as a website project in Visual Studio 2005.
Step2 Launching the Generator
Run the project you have opened from Visual Studio 2005 and this will display the default.aspx page.
Put your connection string in the connectionstring field and Click Scan Button. If the connectionstring is ok and this can connect to the database it will load the table list available in the Database.
Step3 Generating the Text or Code
Select desired tables and simply click the Generate Button. And this will generate code for you. In this case I selected 5 tables Job, JobDataValue, JobHost and JobLog.
Step6: Review the Generated Code.
The class for Job looks like this.
Step7: Review the Profile section in web.config you will notice I have used a custom datatype
<add name="Sql_Tables" type="SmartCodeGen.WebUtil.PropTypes.ScSqlTablesProperty" serializeAs="Xml" />
In future articles and Examples I ll show how to extend SmartCodeGenerator Framework Map different .Net Objects to UIProperty and how to write your custom UI.