Error: Invalid object name 'KeyTable'.

I'm getting the error: "Invalid object name 'KeyTable'." in my C# project. The code in using is:

LightSpeedContext<LightSpeedModel1UnitOfWork> context = new LightSpeedContext<LightSpeedModel1UnitOfWork>("Development");

            using (var uow = context.CreateUnitOfWork())
            {
                SiteUser user = new SiteUser();
                user.UserName = "ABC";
                user.RoleId = 1;

                uow.Add(user);

            }

Hi,

This error message is being generated because you're using the KeyTable identity method. The Identity Method is how LightSpeed will generate identifiers for your entities and, by default, uses the KeyTable pattern. This requires a table called "KeyTable" (there is a script for this in the LightSpeed installation directory under the providers folder).

If you don't want to use the KeyTable identity method please configure an appropriate method on your LightSpeedContext configuration in the .config file. There is information about the various methods in the help file, in the getting started screencast and in some of the samples.

You can read the help file page online here:

http://www.mindscape.co.nz/Help/LightSpeed/Help%20Topics/LightSpeed/IdentityGeneration.html

I hope that helps,

John-Daniel