Trouble just running a basic example

I'm trying the free Express version of LightSpeed by making a console application using .NET 4.5.1 in Visual Studio 2013, but I can't seem to get LightSpeed to load its configuration correctly. I want to use SQL Server Express, I've used it a little bit with the Entity framework before but otherwise I'm a newbie to most database handling. This kind of connectionString usually seems to work with the Entity framework:

(my App.config file:

<?xml version="1.0" encoding="utf-8"?>
    <configuration>

      <configSections>
        <section name="lightSpeedContexts"
                 type="Mindscape.Lightspeed.Configuration.LightSpeedConfigurationSection, Mindscape.LightSpeed"/>
      </configSections>

      <connectionStrings>
        <add name="defaultConnection"
             connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Test1.mdf;Initial Catalog=Test1;Integrated Security=True;User Instance=True"
             providerName="System.Data.SqlClient"/>
      </connectionStrings>

      <lightSpeedContexts>
        <add name="defaultContext"
             connectionStringName="defaultConnection"
             />
      </lightSpeedContexts>

    </configuration>

And my main Program.cs file:

namespace LightSpeedDemo2
{
    class Program
    {
        private static LightSpeedContext<SchoolUnitOfWork> _context;

        static void Main(string[] args)
        {
            _context = new LightSpeedContext<SchoolUnitOfWork>("defaultContext");

            using (var uow = _context.CreateUnitOfWork())
            {
                Console.WriteLine("Students: " + uow.Students.Count());
                Console.ReadLine();
            }
        }
    }
}

When I run this I get an error saying:

An error occurred creating the configuration section handler for lightSpeedContexts: Could not load type 'Mindscape.Lightspeed.Configuration.LightSpeedConfigurationSection' from assembly 'Mindscape.LightSpeed'.

I've tried adding

"dataProvider="SqlServer2008"

in the tag as well, with no change.

Any help would be much appreciated!

You have a typo in the type name for the configuration section, you have specified Mindscape.Lightspeed.Configuration.LightSpeedConfigurationSection, Mindscape.LightSpeed it should be Mindscape.LightSpeed.Configuration.LightSpeedConfigurationSection, Mindscape.LightSpeed

The difference is the capital S in LightSpeed in the second word.

Jeremy

Thanks!

I'm still having issues though. If I create a database layout in the Lightspeed model designer, how do I actually start a new database using this schema, and then populate it? Can I have LightSpeed create it at runtime if it can't find the file specified in my connection string, or do I need to export this schema to an empty database or something? I don't know if what I'm doing wrong has to do with SQL Server and user permissions etc., or if I'm trying to use LightSpeed the wrong way.

Many thanks

If you right click on the design surface and select "Update Database" from the context menu we will prompt to create the database if it doesn't exist. The same command will let you sync the schema changes against an existing database.

At runtime the database must exist and have the correct schema.

Jeremy