MySQLException - Table doesn't exist.

I am trying out this product by following the tutorial video. I am able to connect to the local mySQL database, and retrieve the rows in the table. However, I couldn't update changes back to the database.

Below is my test code which is pretty much similar with tutorial. If I executed on the "Test read" part, it is working. But when I include the "Test write" part, it is throwing exception at this line: uow.Add(status);

My table name is "Status". So, it supposes to access iconicdb.Status instead of iconicdb.keytable?

MySql.Data.MySqlClient.MySqlException was unhandled

Message="Table 'iconic_db.keytable' doesn't exist"

Source="MySql.Data"

ErrorCode=-2147467259

Number=1146

public partial class Form1 : Form
{
    private static LightSpeedContext<IconicUnitOfWork> _context;

    public Form1()
    {
        InitializeComponent();

        _context = new LightSpeedContext<IconicUnitOfWork>("default");

        using (var uow = _context.CreateUnitOfWork())
        {
            // Test write
            Status status = new Status();
            status.Data = "01-00";
            status.DeviceId = 3;
            status.Online = true;

            uow.Add(status);
            uow.SaveChanges();

            // Test read
            StringBuilder print = new StringBuilder();
            List<Status> lstResult = uow.Statuses.ToList<Status>();
            foreach (Status s in lstResult)
            {
                print.Append(s.Online);
                print.Append(", ");
                print.Append(s.Data);
                print.Append(", ");
                print.Append(s.DeviceId);
                print.AppendLine();

            }

            this.richTextBox1.Text = print.ToString();

        }

    }
}

When you add a new entity, LightSpeed needs to assign that entity an ID. There are various options for doing this, but the default is one called KeyTable. The KeyTable method depends on having a table in the database containing the next ID to allocate: by default, this table is called KeyTable. It is this "id allocation" table that LightSpeed is looking for when this error occurs.

For more information about KeyTable and other identity generation options, see:

http://www.mindscapehq.com/documentation/lightspeed/Controlling-the-Database-Mapping/Identity-Generation

To create the key table, run the KeyTable.sql script for your database. You can find this script in the installation directory (under Providers/MySQL5).

Thanks Ivan. Problem solved. Both read and write are working fine.