DevForce Community Forum : Database First

Database First : I just pulled down the latest...

Sat, 17 Nov 2012 08:03:40 -700

Author: brian.shirley
Subject: 3804
Posted: 17-Nov-2012 at 8:03am

I just pulled down the latest from NuGet and it is working perfectly. Thanks again for the quick turnaround. Stellar.

Database First : There is a new Breeze version...

Sat, 17 Nov 2012 03:09:58 -700

Author: jtraband
Subject: 3804
Posted: 17-Nov-2012 at 3:09am

There is a new Breeze version 0.71.3 available now that should fix this issue.

With this version, you should be able to create an EFContextProvider with a "Database First" DbContext .

Database First : I created a simple database first...

Fri, 16 Nov 2012 11:30:54 -700

Author: brian.shirley
Subject: 3804
Posted: 16-Nov-2012 at 11:30am

I created a simple database first model that uses ObjectContext as a test and it worked as stated, so progress!!

Thank you very much for the quick responses on this and all of the hard work on Breeze.

Originally posted by jtraband

Ok, I think I understand what is happening.

Our internal tests are all built against "Database first" models built several years ago with an "ObjectContext". With the advent of EF 4.1, EF "Database first" now defaults to creating a context that derives from DbContext and uses POCO entity classes. We need to add tests for this, because evidently the DbContext that EF4.1 creates for "Database first" models is subtly different from that created for CodeFirst models, where we have a number of tests.

We will try to have this cleared up and a patch put together by this evening. But until then, you can still use an "old" ObjectContext by following the instructions in this link.

msdn.microsoft.com/en-us/data/jj556581.aspx

Database First : Ok, I think I understand what...

Fri, 16 Nov 2012 11:22:13 -700

Author: jtraband
Subject: 3804
Posted: 16-Nov-2012 at 11:22am

Ok, I think I understand what is happening.

Our internal tests are all built against "Database first" models built several years ago with an "ObjectContext". With the advent of EF 4.1, EF "Database first" now defaults to creating a context that derives from DbContext and uses POCO entity classes. We need to add tests for this, because evidently the DbContext that EF4.1 creates for "Database first" models is subtly different from that created for CodeFirst models, where we have a number of tests.

We will try to have this cleared up and a patch put together by this evening. But until then, you can still use an "old" ObjectContext by following the instructions in this link.

msdn.microsoft.com/en-us/data/jj556581.aspx

Database First : I switched to the annotation for...

Fri, 16 Nov 2012 11:11:08 -700

Author: brian.shirley
Subject: 3804
Posted: 16-Nov-2012 at 11:11am

I switched to the [AcceptVerbs("GET")] annotation for good measure and still no luck.

I'm wondering if the conflict is due to the fact that my Database First EDMX model is generating a class derived from DbContext rather than ObjectContext due to the DbContext generator template I linked to above. I went this route in order to get true POCOs and DbSet with DbContext API.

I will try to do a traditional database first example that derives from ObjectContext to see if I still get issues.

Have you tried any examples this way?

For reference, Error:

Creating a DbModelBuilder or writing the EDMX from a DbContext created using Database First or Model First is not supported. EDMX can only be obtained from a Code First DbContext created without using an existing DbCompiledModel.

Database First : Hm, we have several test cases...

Fri, 16 Nov 2012 10:49:26 -700

Author: jtraband
Subject: 3804
Posted: 16-Nov-2012 at 10:49am

Hm, we have several test cases that use Database first models.

The EFContextProvider generic argument "T" can be either a DbContext or an ObjectContext.

So with EF "Database first", you should have an EFContext class that looks something like.

    public partial class NorthwindIBContext : ObjectContext {
    ...

    }

The Breeze EFContextProvider can then be used like this

    public class NorthwindIBContextProvider: EFContextProvider<NorthwindIBContext> {
        public NorthwindContextProvider() : base() { }

      // any public override here like BeforeSaveEntity or BeforeSaveEntities...

    }

And then your api controller might look something like this

public class NorthwindIBModelController : ApiController {

private NorthwindContextProvider _contextProvider = new NorthwindContextProvider();

[AcceptVerbs("GET")]
      public String Metadata() {
    return _contextProvider.Metadata();
      }
        ...
}

Also, note that the example above uses an [AcceptVerbs("Get")] attribute instead of an [HttpGet] attribute. I'm not really clear on the distinction between these two, but just to be safe ...

If this doesn't work, let me know and I'll try to post an entire working example with an DataBase first model.

Database First : I am also encountering this...

Fri, 16 Nov 2012 08:42:09 -700

Author: brian.shirley
Subject: 3804
Posted: 16-Nov-2012 at 8:42am

I am also encountering this exact same problem.

I created an EDMX file with one table from an existing database. I then used the DbContext generator template so that the model used DbContext rather than ObjectContext and generated a POCO.

When calling directly via a WebApi method such as below, I receive JSON data as expected.

BrokerCommContext DbContext = new BrokerCommContext();

return DbContext.CommissionDesignations.AsEnumerable();

However, when invoking the method from the EFContextProvider I receive the same error as identified by Mike in the original post.

readonly EFContextProvider _contextProvider =

new EFContextProvider();

[HttpGet]

public string Metadata()

{

return _contextProvider.Metadata();

}

I am really looking forward to getting Breeze out there with this project. Any help is greatly appreciated!

Code Generated from EDMX

public partial class BrokerCommContext : DbContext

{

public BrokerCommContext()

: base("name=BrokerCommContext")

{

this.Configuration.LazyLoadingEnabled = false;

}

protected override void OnModelCreating(DbModelBuilder modelBuilder)

{

throw new UnintentionalCodeFirstException();

}

public DbSet CommissionDesignations { get; set; }

Originally posted by mike963

Hi

I have tried Breeze with an existing EF implementation that was developed DB first.

I get an error _contextProvider.Metadata();

Originally I had the EDMX file in a separate Data Access Layer but have also tried it locally but still get same error

Any advice ?

Stack Trace

at System.Data.Entity.Infrastructure.EdmxWriter.WriteEdmx(DbContext context, XmlWriter writer)

at Breeze.WebApi.EFContextProvider`1.GetCsdlFromDbContext(DbContext dbContext)

at Breeze.WebApi.EFContextProvider`1.GetJsonMetadataFromDbContext(DbContext dbContext)

at Breeze.WebApi.EFContextProvider`1.Metadata()

at UsingBreeze.Controllers.BreezeSampleController.Metadata() in d:\ModuleChooser\UsingBreeze\Controllers\BreezeSampleController.cs:line 19

at lambda_method(Closure , Object , Object[] )

at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.b__c(Object instance, Object[] methodParameters)

at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)

at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.b__4()

at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)

Edited by brian.shirley - 16-Nov-2012 at 9:09am

Database First : HiI have tried Breeze with an...

Fri, 16 Nov 2012 07:58:57 -700

Author: mike963
Subject: 3804
Posted: 16-Nov-2012 at 7:58am

Hi