Effort Framework does not recognize Entity Model schema

c# effort entity-framework-5 sybase-ase unit-testing

Question

I have an entity model of a Sybase ASE database and I am trying to use the Effort Framework to create unit tests for it. I am able to access the database with the entity model in both my main project and unit test project, however when try to use Effort to create an in memory database, I get an exception.

Problem Code in Unit Test project

public SetUpShims()
{
     string connString = System.Configuration.ConfigurationManager.ConnectionStrings["CoPathDataContext"].ConnectionString;
     MyDbContext context;
     // CreateTransient throws exception
     EntityConnection conn = Effort.EntityConnectionFactory.CreateTransient(connString);

     context = new Data.CoPathDataContext(conn);

}

Exception Details: (System.Data.MetadataException)

Schema specified is not valid. Errors: 
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.
(0,0) : error 0063: Precision facet isn't allowed for properties of type double.

Stack Trace

at System.Data.Metadata.Edm.StoreItemCollection.Loader.ThrowOnNonWarningErrors()  
at System.Data.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths) 
at System.Data.Metadata.Edm.StoreItemCollection.Loader..ctor(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths, Boolean throwOnError)  
at System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest& providerManifest, DbProviderFactory& providerFactory, String& providerManifestToken, Memoizer`2& cachedCTypeFunction)
at System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders)   
at Effort.Internal.Common.MetadataWorkspaceHelper.CreateMetadataWorkspace(List`1 csdl, List`1 ssdl, List`1 msl)   
at Effort.Internal.Common.MetadataWorkspaceHelper.Rewrite(String metadata, String providerInvariantName, String providerManifestToken) 
at Effort.EntityConnectionFactory.<GetEffortCompatibleMetadataWorkspace>b__1(String metadata)
at Effort.Internal.Caching.MetadataWorkspaceStore.<>c__DisplayClass1.<GetMetadataWorkspace>b__0()
at System.Lazy`1.CreateValue()   
at System.Lazy`1.LazyInitValue()
at System.Lazy`1.get_Value()
at Effort.Internal.Caching.ConcurrentCache`2.Get(TKey key, Func`1 factory)  
at Effort.Internal.Caching.MetadataWorkspaceStore.GetMetadataWorkspace(String metadata, Func 2 workspaceFactoryMethod)
at Effort.EntityConnectionFactory.GetEffortCompatibleMetadataWorkspace(String& entityConnectionString)
at Effort.EntityConnectionFactory.CreateTransient(String entityConnectionString, IDataLoader dataLoader)
at Effort.EntityConnectionFactory.CreateTransient(String entityConnectionString)

After looking at the .csdl and .ssdl files that Entity made, I believe I found the fields causing the problem.

SSDL

<Property Name="sequence_num" Type="float" Precision="24" Nullable="false" />

CSDL

<Property Name="sequence_num" Type="Double" Nullable="false" />

I tried removing the Precision attribute from the SSDL fields, but but I still received the same error. (Even if it did work, the changes would probably not persist when the model is regenerated )

Anyone thoughts on what is causing the exception and how I should resolve it?

1
1
10/8/2014 10:44:28 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

if you have not done so jet upgrade MySQL server to 5.6+ this has been added then update all your date, datetime, time ...... with the with option's 0-6 in ()

0
3/24/2015 1:00:48 PM

Related Questions

What's the correct way to use Effort with Entity Framework 6?

You cannot compare custom objects in a LINQ query. You should compare only primitive type (int, string, etc)....var existingFrames = from frame in repository.CcdFrames where frame.Id == newFrame.Id select frame; ...You can get some info here: ...Only primitive types or enumeration types are supported in thi...
c# effort entity-framework entity-framework-6 linq
asked by Vsevolod Goloviznin

unit testing with effort for entity framework 6 with computed values

This issue is fixed with the latest update....You have to set the global ...EntityFrameworkEffortManager.UseDefaultForNotNullable... flag as true.
effort entity-framework entity-framework-6 unit-testing
asked by garo cm

Update model causes interface to be removed from DbContext when using Effort with Entity Framework

Presently, I am attempting to use Effort (...https://effort.codeplex.com/...) with my Entity Framework 6 solution to allow unit testing without requiring a database connection (see ...http://www.codeproject.com/Articles/460175/Two-strategies-for-testing-Entity-Framework-Effort...). Everything works in my project, where this is the ...DbContext... w...
c# effort entity-framework-6 unit-testing
asked by user8128167

Effort (EF6) exception when accessing DbSet (The given key was not present in the dictionary)

I'm having the exact problem. Turned out it was because I was using the SQL geography data type in some of my SQL 2014 database tables, and effort ...doesn't support this data type..., and there are no plans to add support for it at the moment either, which leaves me in a real quandry as I can't find any other in-memory database provider for EF6 wh...
.net effort entity-framework entity-framework-6 linq
asked by Breeno

Entity Framework 6 throws migration exception when trying to create a context with Effort

I kept getting the same error in my unit testing project. I solved it by modifying the TestInitialize function by calling the CreateIfNotExist() function ... [TestInitialize] public void Initialize() { DbConnection connection = Effort.DbConnectionFactory.CreateTransient(); context = new MyAccessContext(connection); ...
asp.net-mvc effort entity-framework-6
asked by user8515

Effort unit testing Entity framework 6.1.3 DB-first

A colleague of mine found the solution to my issue! ...Apparently I was using the "Effort" nuget package instead of the "Effort.EF6" nuget package. After uninstalling and installing the other I also had to update my App.Config with the tags:... <system.data> <DbProviderFactories> <add name="Effort.Provider" invariant="Effort.Provider" de...
c# effort entity-framework unit-testing
asked by gurkan

ASP Boilerplate problems using Effort in unit testing with EFProf (Entity Framework Profiler)

Answering my own question: Effort fakes the DbContect object but does not actually create SQL for in-memory, thus there is nothing to intercept by profilers. It is also the reason why the CommandText is always null when using EF6's Database.Log with Effort....Am going to try using Moq with EF6 to use an in-memory database implementation for testing...
asp.net-boilerplate effort entity-framework entity-framework-6 unit-testing
asked by Todd Brooks

Effort Entity Framework Sequence contains not matching elements

Found the problem I had another data model with a property containing the following annotation. It didn't like it. Commented it out and it worked....[Column(TypeName = "XML")]
asp.net-mvc c# effort entity-framework
asked by user892381

Effort.Exceptions.EffortException : Database has not been initialized - after non commited update?

I took the advice mentioned in the exception message and added the following line to my test within the ...using... statement... db.Database.CreateIfNotExists(); ...and that worked for me.
c# effort entity-framework entity-framework-6
asked by Eugenio Miró

UnintentionalCodeFirstException | Entity Framework Unit Testing with Effort.Ef6 using Database First

The problem was that I had to specify the key for my KeyValuePair dataset....protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<KeyValuePair>().HasKey(x => x.Key); base.OnModelCreating(modelBuilder, null); } ...Thank you very much ...Robert Jørgensgaard Engdahl ...!
c# effort entity-framework entity-framework-6 unit-testing
asked by WoIIe

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