Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

I am trying to replicate an example found on MSDN. I am using ASP.NET and EF 4.1 (CTP?). I've used NuGet to install the EntityFramework package.

I am getting this error: The provider did not return a ProviderManifestToken string ... and the database is never created.

Here is my connection string:

<add name="HospitalContext"

   connectionString=

   "data source=.\SQLExpress;initial catalog=NewTestDB;integrated security=True;"

   providerName="System.Data.SqlClient"/>

Here is my code:

var pat = new Patient { Name = "Shane123132524356436435234" };

db.Patients.Add(pat);

var labResult = new LabResult { Result = "bad", Patient = pat };

int recordAffected = db.SaveChanges();

Here is my context:

public class HospitalContext : DbContext

{

    static HospitalContext()

    {

        Database.SetInitializer(new HostpitalContextInitializer());

    }

    public DbSet<Patient> Patients { get; set; }

    public DbSet<LabResult> LabResults { get; set; }

}

public class HostpitalContextInitializer :

             DropCreateDatabaseIfModelChanges<HospitalContext>

{

    protected override void Seed(HospitalContext context)

    {

        context.Patients.Add(new Patient { Name = "Fred Peters" });

        context.Patients.Add(new Patient { Name = "John Smith" });

        context.Patients.Add(new Patient { Name = "Karen Fredricks" });

    }

}

This is a fully patched SQL 2008 system, with VS 2010 SP1.

1 Answer

0 votes
by (40.7k points)

It looks like you may be getting a simple SQL login failure for the user. So, first, check the Inner Exception.

Related questions

0 votes
1 answer
asked Oct 5, 2019 in SQL by Tech4ever (20.3k points)
0 votes
2 answers
0 votes
3 answers

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...