Transcript Slide 1
Boost data-driven application development using SQL Server Centric .NET Code Generator David Rodriguez SQL Server Technology Specialist Microsoft Corporation Agenda Overview Installation Using built-in templates Building custom templates Olymars in real world Resources http://www.microsoft.fr/olymars/webupdate.xml Freely downloaded but NOT SUPPORTED That being said it is very easy to use Agenda Overview Installation Using built-in templates Building custom templates Olymars in real world N Tiered Application Data Classes Windows controls ComboBox ListBox Stored Procedures CheckedListBox DataGrid Table1 Insert Update Database Windows Forms Form Application Delete Web controls Select Custom1 ListBox DropDownList CheckBoxList Repeater DataList DataGrid Overview Internally known as OlyMars Project started in March 2001 Can help you (and your organization) move quickly to the .NET world Already 200+ external customers using it Overview OlyMars is built on .NET (C#) Two ways of considering this tool Comes with more 150+ built-in templates Is a code generation framework Relies on a SQL Server 2000 database Is built using itself Agenda Overview Installation Using built-in templates Building custom templates Olymars in real world OlyMars Setup Agenda Overview Installation Using built-in templates Building custom templates Olymars in real world Table1 What do we need next? Table2 Stored procedures… Database Table3 Table4 Designed by hand Stored Procedures Insert Update Table1 Delete Select Database Custom1 Custom2 Custom3 Auto-generated Written by hand Stored Procedures Generation Stored Procedures Insert Update Table1 Delete Select Database What do we need next? ADO .NET classes able to call the stored procedures Custom1 Custom2 Custom3 Auto-generated Written by hand Auto-generated Written by hand Data Classes What do we need next? Database Structure Windows & Web controls that map to each of our tables Auto-generated Windows controls Written by hand ComboBox ListBox CheckedListBox Table1 DataGrid Web controls ListBox Database DropDownList CheckBoxList Repeater DataList DataGrid Auto-generated Windows controls Written by hand ComboBox ListBox SP CheckedListBox DataGrid Web controls ListBox Database DropDownList CheckBoxList Repeater DataList DataGrid Auto-generated Written by hand Windows Forms Form Table1 Sample Application Database Web Forms Page Rest of the generation Agenda Overview Installation Using built-in templates Building custom templates Olymars in real world html Code content TOOL IIS You IE Template asp page SQL File Repository Needs to connect to a repository Tool Repository Tool Needs to connect to a working database and analyses it Working DB Repository Tool In memory Working DB representation When analyzed, creates an in-memory representation of this working database Working DB Repository In memory Working DB representation Loads the templates in memory Templates Tool Working DB Repository This representation is provided to the templates In memory Working DB representation Templates Tool Working DB Repository In memory Working DB representation Templates Tool The templates are executed by the tool Working DB Repository In memory Working DB representation Templates Tool SQL code Working DB Can be some SQL code to execute on the working DB Repository In memory Working DB representation Templates Tool SQL code Can be any code to save in files Working DB File Disk Agenda Overview Installation Using built-in templates Building custom templates Olymars in real world Questions? © 2002 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.