Devart Forums

darth_bug

Hello,

do You plan to continue PostgreSQLDirect .NET version 3 to solve this issue?

I tried the new beta release 4 and have massive problems to migrate our project. I changed all references, edited the .edmx to the new Devart namespace, but i get a TypeLoadExcepttion which says that .Net did not find the Store Provider.

Do you plan to provide a migration guide? And what about licensing, can get an update with our version 3 license?

best regards,

Johannes

darth_bug

Thank's for the quick reply

!

darth_bug

Hello,

i've send You an E-Mail to [email protected] on this issue on monday and didn't get any reply yet! The Mail mail contains a sample project to demonstrate the behaviour, because i suggested it would be to complex to explain in the forum. As You didn't response the the E-Mail request i'll try to explain the problem here:

I get a NullReferenceException when i query an entity by using '==' or 'Equals()' on at least 2 string properties of any navigation property. This problem only exists when several conditions (under several combinations) are satisfied. For example the use of 'Include' functions in the query, or if both entities are derived from an abstract Entity class.

As i already mentioned i've created a sample project with a sample database to reproduce this behaviour very easy. If You like, i'll send it to you again.

I would realy appreciate, if You could give any reply on this, because we have to decide how to continue!

Thank's in advance and best regards,
Johannes

darth_bug

Hello,

i'm successfully using 'PostgreSQLDirect .NET version 3.70.29' with 'ADO .Net Entity Framework' from '.Net Framework 3.5 SP 1 (beta)'.
When i updated to '.Net Framework 3.5 SP 1 (release)', i experience the following error by updating my model or running an entity linq query:

Code: Select all

---------------
		Type : System.Data.EntityCommandCompilationException, System.Data.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
		Message : Fehler bei der Vorbereitung der Befehlsdefinition. Details finden Sie in der internen Ausnahme.
		Source : System.Data.Entity
		Help link : 
		Data : System.Collections.ListDictionaryInternal
		TargetSite : Void .ctor(System.Data.Common.DbProviderFactory, System.Data.Common.CommandTrees.DbCommandTree)
		Stack Trace :    bei System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)
		   bei System.Data.EntityClient.EntityProviderServices.CreateCommandDefinition(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)
		   bei System.Data.EntityClient.EntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
		   bei System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
		   bei System.Data.Objects.Internal.ObjectQueryExecutionPlan.Prepare(ObjectContext context, DbQueryCommandTree tree, Type elementType, MergeOption mergeOption, Span span)
		   bei System.Data.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable`1 forMergeOption)
		   bei System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
		   bei System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
		   bei System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
		   bei System.Data.Objects.ELinq.ObjectQueryProvider.b__2[TResult](IEnumerable`1 sequence)
		   bei System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
		   bei System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
		   bei System.Linq.Queryable.Count[TSource](IQueryable`1 source)
		   bei WoVModel.WoVConfiguration.GetSetting(String key) in [PATH]
		   bei WoVModel.WoVConfiguration.get_AdsConnection() in [PATH]
		   bei WoVModel.WoVConfiguration.get_AdsKatalogDB() in [PATH]
		   bei WoVModules.ListGenerator.Services.ExportADSService..ctor(IExcelExport excelExport, WorkItem workitem) in [PATH]

			Inner Exception
			---------------
			Type : System.MethodAccessException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
			Message : System.Data.Common.CommandTrees.DbCommandTree.Validate()
			Source : CoreLab.PostgreSql.Entity
			Help link : 
			Data : System.Collections.ListDictionaryInternal
			TargetSite : System.String a(System.Data.Common.CommandTrees.DbQueryCommandTree, System.Collections.Generic.List`1[System.String] ByRef)
			Stack Trace :    bei CoreLab.Common.Entity.i.a(DbQueryCommandTree A_0, List`1& A_1)
			   bei CoreLab.PostgreSql.Entity.c.a(DbCommandTree A_0, DbConnection A_1)
			   bei CoreLab.PostgreSql.Entity.PgSqlEntityProviderServices.b(DbProviderManifest A_0, DbCommandTree A_1)
			   bei System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
			   bei System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)

Have You already tested PostgreSQLDirect .NET against Net Framework 3.5 SP 1 (release)? I'm looking forward to deploy my application with this release.

best regards,
Johannes

Devart Forums

Search found 4 matches

NullReferenceException on query over navigation properties

.Net Framework 3.5 SP 1 Problem