First Azure connection using Entity Framework code

azure code-first connection-string ef-code-first entity-framework

Question

I am using Entity Framework Code First 4.3 + Azure and having difficulties connecting to the database. The error I get is the following (on the first query):

Keyword not supported: 'server'.

I have the following connection set up in my Web.config

<configSections>
    type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  </configSections>

  <connectionStrings>
    <add name="TestDBContext"
         connectionString="Server=tcp:[SUBSCR].database.windows.net,1433;Database=[MyDB];User ID=[user];Password=[pass];Trusted_Connection=False;Encrypt=True;PersistSecurityInfo=True"
         providerName="System.Data.EntityClient" />
  </connectionStrings>

My DbContext implementing class uses the connection string's name:

public class MyContext : DbContext, IMyContext
    {
        public MyContext()
            : base("TestDBContext")
        {
            Configuration.LazyLoadingEnabled = true;
            Configuration.ProxyCreationEnabled = true;
        }

Can you tell what is going on?

1
6
2/12/2012 11:21:32 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I just had the same problem.

You're missing all the metadata in the connection string that Entity Framework requires. The connection string provided by SQL Azure needs to inserted within the provider connection string parameter of EF's connection string.

<add name="MyConnectionString" connectionString="metadata=res://*/Model.Model.csdl|res://*/Model.Model.ssdl|res://*/Model.Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;[PUT SQL AZURE CONN STRING HERE]&quot;" providerName="System.Data.EntityClient" />

You'll need to use the metadata from your own project. I pulled that metadata from an EF project generating from an existing database.

5
7/26/2012 12:20:54 AM

Related Questions

Entity Framework 4 Code First demonstrates how to declare a one-to-one connection (POCO)

How to declare a one to one relationship using Entity Framework 4 Code First (POCO)?...I found ...this question (one-to-one relationships in Entity Framework 4) ..., but the article that the answer references was not useful (there is one line of code that is a 1-1 relationship, but no mention of how to define it).
c# ef-code-first entity-framework one-to-one poco
asked by Paul Hiles

Code First Entity Framework and Windows Azure SQL

I am trying move a very simple code first example from my local SQL on to Azure SQL and as it appears I've hit a brick wall....This is the simple code that I am using:...public class Cat { [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] public Guid ID { get; set; } public string Name { get; set; } } **Context class:** publi...
azure azure-sql-database code-first ef-code-first entity-framework
asked by Jammer

How do I establish a one to one relationship with Entity Framework Code First

I've been reading all the Google and SO pages about people who are establishing a one to one relationship in ...EF... but it just isn't working for me....Here is my model:...Account:...public int Id {get; set;} public virtual AccountConfig AccountConfig {get; set;} ...Account Map:...HasKey(t => t.Id); HasRequired(t => t.AccountConfig) .WithOpti...
.net c# entity entity-framework
asked by jermny

How to make Entity Framework Code First use the SQL Azure DB?

I'm start to learn EF now. What I want to do is use EF code first create new tables in SQL Azure....Here is my code:...namespace WebApplication2 { public class Blog { public int UserName { get; set; } public int ID { get; set; } } public class BlogContext : DbContext { public DbSet<Blog> Blogs { get; set; } ...
azure azure-sql-database c# ef-code-first entity-framework
asked by EthenHY

Entity Framework 6.0 Code First Migrations to Azure SQL DB not working.

I am trying to create an ASP.NET MVC site loosely based on this tutorial. ...http://www.windowsazure.com/en-us/develop/net/tutorials/web-site-with-sql-database/...I am using VS2013 preview which gave me the option to create an ASP.NET MVC 5 site. Also, using the following packages:...EntityFramework 6.0.0-rc1...Microsoft.AspNet.Identity.Core" 1.0....
asp.net-mvc azure ef-migrations entity-framework
asked by Carlos Nuñez

Entity Framework Code First Fluent API configuration for one to one identifying relationship

I have the following class structure:...How to configure Fluent API to put identifying relationship in Cards table? ...I mean ...Cards Table PK: Id, CustomerId...Cards Table FK: CustomerId...I would like the previous Card be deleted when I assign a new one to Customer.Card property....So I defined my classes this way:...public class Customer { ...
c# code-first ef-fluent-api entity-framework entity-framework-6
asked by Dmitry Nogin

One or Zero to One Entity Framework Code First FluentApi

I need to create fluentapi one or zero to one reference and have navigation properties on both of entities. ...EntityTwo should contain simple proerty to store foreign key (EntityOneId)...public class EntityOne { public int Id { get; set; } public EntityTwo EntityTwo { get; set; } } public class EntityTwo { public int Id { get; set; } ...
c# ef-code-first ef-fluent-api entity-framework
asked by Oleg Gochachko

How to define a one to one self reference using Entity Framework Code First

I want to implement versioning on my entity ...Stuff.... Each entity has an optional reference to the next version (the latest version will be null) and an optional reference to the previous version (the first version will be null). I am using entity framework 6, code first. I tried with the following model and modelbuilder statement (and many vari...
c# entity-framework entity-framework-6 foreign-keys self-reference
asked by mnwsmit

Entity Framework 6 code first fluent API one to one relation with both ends required

I want to implement One to One relation with both ends required with the fluent API in Entity Framework 6 code first....I have the principal class:...public class Student { public int Id{ get; set;} public string Name{ get; set;} public StudentProfile StudentProfile { get; set; } } ...and I have the dependent class:...public class S...
ef-fluent-api entity-framework-6 one-to-one relationship
asked by pepe

Configure Azure SQL DTU with Entity Framework Code First

I would like to know if it is possible to define the ...DTU... of a ...Azure SQL database... when using ...Entity Framework Code First...? What i mean is, you can use DropCreateDatabaseIfModelChanges-DropCreateDatabaseAlways, but each time it is dropped and re created, it gets the ...Standard DTU... by default but it needs to be the ...Basic DTU...
azure-sql-database c# ef-code-first entity-framework-6
asked by Dimitri

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow