• Many-to-Many relationships are not supported
• All your entities are defined in a single, monstrous class
• You have to fetch records from the database just to delete or update them
• There is no built-in caching

• Many-to-Many support
• Entities get their own class files
• Changes to your SQL schema are magically preserved when you update your classes
• Deletes and updates are optimized
• You can detach and reattach entities
• You can generate astoria services for EASY use with jQuery ajax (sweet!)
• MUCH MORE
  

1. Dell Inspiron E1705 w/ Windows 7 RC x86
   
2. Dell Studio 16 XPS w/ Windows 7 RC x64 (happened with both 64-bit and 32-bit ODBC drivers, and with both 3.51 and 5.1 versions of each)

1. Get .NET Reflector and install it.
2. Use .NET Reflector to open your assembly.
3. Expand your assembly, and look for the class that represents the page you would like to edit. In my case it was "viewprintnotice", which represented "viewprintnotice.vb".
4. Expand that class and click the method you guess the text was set in. I guessed Page_Load.
5. Right click it and Disassemble.
6. Did you find the code where the value was set? If so, take note. If not, keep digging until you find it. You can't make the change here, though. To actually edit, you need a plug-in.
7. Download Reflexil.
8. Install it.

1. Close .NET Reflector (this step may not be necessary, actually)
   
2. Drop its files into the .NET Reflector directory.
3. Open .NET Reflector.
4. View > Add-Ins.
5. Choose Add, and double-click Reflexil.dll.

publicstaticstring MySqlEscape(thisstring usString)

{

    if (usString
== null)

    {

        returnnull;

    }

    //
SQL Encoding for MySQL Recommended here:
    //
http://au.php.net/manual/en/function.mysql-real-escape-string.php
    //
it escapes \r, \n, \x00, \x1a, baskslash, single quotes, and double quotes     return Regex.Replace(usString, @"[\r\n\x00\x1a\\'""]", @"\$0");

}

1. Install the ODBC Driver
2. Edit the C:\IBM\UniDK\Config\uci.config file, adding this to the bottom:
   <storis>
   DBMSTYPE = UNIDATA
   network = TCP/IP
   service = udserver
   host = [your storis IP address]
3. Add an ODBC System DSN

1. Click Administrative Tools - Data Sources. Note that on a 64-bit system, you will need to access the 32-bit ODBC applet, which you can get to (on Vista x64, for example) in Control Panel -> View 32-Bit Control Panel Items
2. On the System DSN Tab, Click Add...
3. Select the IBM UniData ODBC Driver
4. Click Finish

1. Select your DSN from the list
2. Click Configure...
3. Give it a Data Source Name. We went with "StorisUnidata"
4. For the server, specify "storis", which is the first line you added to the uci.config file above.
5. Specify your Database name. In the UniData world, they often refer to this as the Account Name, which is a little confusing.
6. For the User, specify a windows account that can access your database. To eliminate permissions issues, we started with a local system administrator account. We entered that account name under User.
7. Click OK.

1. Prepare yourself, because this app is a bit ugly :). Think Lotus Notes...
   
2. Launch the VSG
3. This is just like configuring the DSN:
   

1. For the server, specify "storis", which is the first line you added to the uci.config file above.
2. Specify your Database name. In the UniData world, they often refer to this as the Account Name, which is a little confusing.
3. For the User, specify a windows account that can access your database. To eliminate permissions issues, we started with a local system administrator account. We entered that account name under User.
4. Enter the password for that windows account.
   
5. Click OK.

1. Create a new application pool, and call it something like StorisApp32
2. In its Advanced Settings, Set Enable 32-Bit Applications to True.
3. Set your app to use this application pool.
4. It will now run in 32-bit mode and load the ODBC driver.
5. You do not have to change the way you compile (no need to specify x86 only, or anything like that).
   

OdbcConnection
odbcConnection =new OdbcConnection(ConfigurationManager.AppSettings["StorisSystemDsn"]);
OdbcDataAdapter odbcDataAdapter =new OdbcDataAdapter("select
* from from SALES_FLASH_DAILY", odbcConnection); DataSet dataSet =new DataSet();
odbcDataAdapter.Fill(dataSet); gvRecords.DataSource = dataSet.Tables[0];
gvRecords.DataBind();

Database
db = DatabaseFactory.CreateDatabase("StorisOdbc");
DbCommand dbCommand = db.GetSqlStringCommand("select
* from from SALES_FLASH_DAILY"); DataSet dataSet = db.ExecuteDataSet(dbCommand);
gvRecords.DataSource = dataSet.Tables[0];
gvRecords.DataBind(); 

1. Go to MySQL.com and download the latest MySQL ODBC connector. As I write this it's 5.1.5. I used the 64-bit version, as I have 64-bit Vista.
   
2. Install the ODBC Connector. I chose to use the no-installer version. I just unzipped it and ran Install.bat at an administrator's command prompt. The MSI version probably works fine, but I did it this way back when I installed the 3.51 connector.
   
3. Verify the installation by opening your ODBC control panel and checking the Drivers tab. You should see the MySQL ODBC 5.1 Driver listed there. It seems to even co-exist peacefully with the older 3.51 version if you already have that. Additionally it coexists peacefully with the .NET connector if that is installed too.
4. At this point you will be doing what you've done to connect to a SQL Server database. All you need to know is what to use for a connection string.
5. Here's what mine looks like:
   <add name="MySqlDatabaseTest" connectionString="server=myservername;database=mydbname;uid=myusername;pwd=mypassword;driver={MySQL ODBC 5.1 Driver};option=3;" providerName="System.Data.Odbc" />
6. Of course you can set "name" to whatever you want.
7. If this is your only database, you can set it up as the defaultDatabase like this: <dataConfiguration defaultDatabase="MySqlDatabaseTest"/>
8. Access your data in your code like you always do! Here's a plain text sql example:

public List<Contact>
Contact_SelectAll()

{

    string sql =string.Format(@"

        select

            *

        from

            Contact

    ");


    List<Contact> contactList =new List<Contact>();

    Database db = DatabaseFactory.CreateDatabase("MySqlDatabaseTest");

    DbCommand dbCommand = db.GetSqlStringCommand(sql);

    using (IDataReader
dataReader = db.ExecuteReader(dbCommand))

    {

        while (dataReader.Read())

        {

            Contact contact =new Contact();

            contact.ID = (int)
dataReader["ContactID"];

            contact.FirstName = dataReader["ContactFName"].ToString();

            contact.LastName = dataReader["ContactLName"].ToString();

            contactList.Add(contact);

        }

    }


    returncontactList;

}