Author: tbedford
Date: 2010-06-10 12:56:05 +0200 (Thu, 10 Jun 2010)
New Revision: 21150
Log:
Added initial text for EF/DDL macro tutorial.
Added:
trunk/refman-common/connector-net-tutorials-efmodel-ddl.xml
Added: trunk/refman-common/connector-net-tutorials-efmodel-ddl.xml
===================================================================
--- trunk/refman-common/connector-net-tutorials-efmodel-ddl.xml (rev 0)
+++ trunk/refman-common/connector-net-tutorials-efmodel-ddl.xml 2010-06-10 10:56:05 UTC (rev 21150)
Changed blocks: 1, Lines Added: 130, Lines Deleted: 0; 4078 bytes
@@ -0,0 +1,130 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE section PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % all.entities SYSTEM "all-entities.ent">
+ %all.entities;
+]>
+<section id="connector-net-tutorials-efmodel-ddl">
+
+ <title>Tutorial: Generating MySQL DDL from an Entity Framework Model</title>
+
+ <para>
+ In this tutorial you will learn how to create MySQL DDL from an
+ Entity Framework model. You will need to use Visual Studio 2010 and
+ &cnet; 6.3 to carry out this tutorial.
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Create a new console application in Visual Studio 2010.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Using the <guilabel>Solution Explorer</guilabel> add a reference
+ to <filename>MySql.Data.Entity</filename>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ From the <guilabel>Solution Explorer</guilabel> select
+ <guimenu>Add</guimenu>, <guimenu>New Item</guimenu>. In the
+ <guilabel>Add New Item</guilabel> dialog select <guilabel>Online
+ Templates</guilabel>. Select <guilabel>ADO.NET Entity Data
+ Model</guilabel> and click <guibutton>Add</guibutton>. The
+ <guilabel>Entity Data Model</guilabel> dialog will be displayed.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ In the <guilabel>Entity Data Model</guilabel> dialog select
+ <guilabel>Empty Model</guilabel>. Click
+ <guibutton>Finish</guibutton>. A blank model will be created.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Create a simple model. A single Entity will do for the purposes
+ of this tutorial.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ In the <guilabel>Properties</guilabel> panel select
+ <guimenu>ConceptualEntityModel</guimenu> from the drop-down
+ listbox.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ In the <guilabel>Properties</guilabel> panel, locate the
+ <guilabel>DDL Generation Template</guilabel> in the category
+ <guilabel>Database Script Generation</guilabel>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ For the <guilabel>DDL Generation</guilabel> property select
+ <guimenu>SSDLToMySQL.tt(VS)</guimenu> from the drop-down
+ listbox.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Save the solution.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Right-click in an empty space in the model design area. The
+ context-sensitive menu will be displayed.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ From the context-sensitive menu select <guimenu>Generate
+ Database from Model</guimenu>. The <guilabel>Generate Database
+ Wizard</guilabel> dialog will be displayed.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ In the <guilabel>Generate Database Wizard</guilabel> dialog
+ select an existing connection, or create a new connection to a
+ server. Select an appropriate radio button to show or hide
+ sensitive data. For the purposes of this tutorial you can select
+ <guilabel>Yes</guilabel> (although you may not want to do this
+ for commercial applications).
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Click <guibutton>Next</guibutton>. MySQL compatible DDL code
+ will be generated. Click <guibutton>Finish</guibutton> to exit
+ the wizard.
+ </para>
+ </listitem>
+
+ </orderedlist>
+
+ <para>
+ You have seen how to create MySQL DDL code from an Entity Framework
+ model.
+ </para>
+
+</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r21150 - trunk/refman-common | tony.bedford | 10 Jun |
