Connection String Problem

Hello,

I have installed SQL Servr Express on my local machine (Sunil-PC) and am bale to connect to it from Management studio using windows authentication.

I am attaching my config file.

Now, I connect to the database using the following code:

LightSpeedContext _context = new LightSpeedContext("default"); var uow = _context.CreateUnitOfWork(); var updateCompany = uow.Companies.Single(o => o.CompanyNameId == company.CompanyNameId);

The code blows up at the above step and says that "The ConnectionString property has not been initialized." Any solutions?

The config file doesn't seem to have arrived here but my guess would be that something in the names doesn't match up. Your config file should look something like this:

<lightSpeedContexts>
  <add name="default" connectionStringName="dev" />
</lightSpeedContexts>

<connectionStrings>
  <add name="dev" connectionString="..."/>
</connectionStrings>

Note that the name in the lightSpeedContexts section must match the name in your C# code ("default" in this case) and the name in the connectionStrings section must match the connectionStringName in the lightSpeedContexts section ("dev" in this case).