ORA-01790

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
LeeSalter
Posts: 3
Joined: Fri 02 Oct 2009 12:31

ORA-01790

Post by LeeSalter » Fri 02 Oct 2009 12:40

Please help.

I've just downloaded and installed the latest version of dotConnect for Oracle, thinking that it may fix an existing bug, but have now come across another bug.

My Entity object was working fine before but now I get an ORA-01790 error whenever I try to instantiate an Entity Object with more than two .Includes in.

The following code, which was working before, now fails:-

Code: Select all

 Nominal thisNom = (from n in context.Nominals.Include("RestorativeJustices").Include("Fips")
                                   .Include("CommonAssessmentFrameworks").Include("NominalDocuments")
                                   .Include("NominalDocuments.DocumentType")
                                   where n.NominalId == NominalId
                                   select n).FirstOrDefault();
If I remove some of the .Includes and leave two or less the code works. This is the same for any combination of .Include statements.

I'm in the middle of a critical project and need this sorting asap!!!

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 05 Oct 2009 08:58

Could you please make a small test project illustrating the problem and send it to support * devart * com, subject "EF: Include"?
Please include the scripts of DB objects into the project.

LeeSalter
Posts: 3
Joined: Fri 02 Oct 2009 12:31

Post by LeeSalter » Mon 05 Oct 2009 11:39

AndreyR wrote:Could you please make a small test project illustrating the problem and send it to support * devart * com, subject "EF: Include"?
Please include the scripts of DB objects into the project.
Hi Andrey,

I've sent you a test project and db table creation scripts.
It may get quarentined at this end before it gets to you, please let me know if you haven't received it by this time tomorrow.

Kind regards,

Lee

Tom Wilkinson
Posts: 1
Joined: Mon 05 Oct 2009 13:30
Location: Cleveland, Ohio USA

I am also having this problem

Post by Tom Wilkinson » Mon 05 Oct 2009 13:43

I have the same problem using version 5.25.44.

I did find a workaroud but I would perfer it to work the old way.

Code: Select all

public REQUEST GetRequest(int id)
        {
            var q = from r in Ctx.REQUEST
                        .Include("HISTORY")
                        .Include("REQUEST_WORKGROUP.WORKGROUP")
                        //.Include("ASSIGNMENTS.STAFF")  // Devart bug ORA-01790: expression must have same datatype as corresponding expression
                        //.Include("ASSIGNMENTS.TASKS")  // Devart bug ORA-01790: expression must have same datatype as corresponding expression
                        //.Include("COMMENTS")           // Devart bug ORA-01790: expression must have same datatype as corresponding expression
                        .Include("PROJECT")
                        .Include("WORKGROUP")
                    where r.ID == id
                    select r;

            // workaroud for Devart bug ORA-01790: expression must have same datatype as corresponding expression 
            // this will show the bad sql in x; 
            var x = ((ObjectQuery)q).ToTraceString();
            var req = q.First();
            req.COMMENTS.Load();
            req.ASSIGNMENTS.Load();
            foreach (var assignment in req.ASSIGNMENTS)
            {
                assignment.STAFFReference.Load();
                assignment.TASKS.Load();
            }
            // end of workaround

            return req;
        }

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 06 Oct 2009 14:53

I tried to reproduce the described problem using Lee's test project and failed.
However, the problem is reproducible using the previous build of dotConnect for Oracle or in case when
Devart.Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls is set to true
(this code imitates the behaviour of previous builds).
I recommend you check that there are no cached assemblies with the old version in your system.
You can also check loaded modules in runtime (Debug->Modules).

LeeSalter
Posts: 3
Joined: Fri 02 Oct 2009 12:31

Post by LeeSalter » Wed 07 Oct 2009 08:27

AndreyR wrote:I tried to reproduce the described problem using Lee's test project and failed.
However, the problem is reproducible using the previous build of dotConnect for Oracle or in case when
Devart.Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls is set to true
(this code imitates the behaviour of previous builds).
I recommend you check that there are no cached assemblies with the old version in your system.
You can also check loaded modules in runtime (Debug->Modules).
Thanks for the update Andrey, I'll check those things out and get back to you.

epsilon
Posts: 2
Joined: Wed 14 Oct 2009 12:44

Same problem here too

Post by epsilon » Wed 14 Oct 2009 13:07

Hi,

We also have this problem here.
In our case, it seems to happen only if the one-to-many relations that are Included are more than 2.

Is there something new on this?

Regards, Alain

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 15 Oct 2009 08:42

2Tom, Epsilon:
Could you please send us (support * devart * com, subject "EF: Multiple Includes") a small test project reproducing the problem?
As I have already mentioned, the Lee's test project worked fine with the latest version.

barrie mcguire
Posts: 1
Joined: Thu 15 Oct 2009 08:49

Post by barrie mcguire » Thu 15 Oct 2009 08:58

Hi,

We are currently experiencing the same problem with multiple includes with one-to-many assoiciations.

This is the query we're executing...

Code: Select all

var query = from p in context.PropulsionSet
    .Include("Aspiration.DescriptionResource")
    .Include("BaseEngine")
    .Include("BaseMotor")
    .Include("FuelDelivery.DescriptionResource")
    .Include("Fuel.DescriptionResource")
    select p;
And the SQL generated looks like this..

Code: Select all

SELECT 
"UnionAll4".C2 AS C1, 
"UnionAll4".C3 AS C2, 
"UnionAll4".C4 AS C3, 
"UnionAll4".C1 AS C4, 
"UnionAll4".C5 AS C5, 
"UnionAll4".C6 AS C6, 
"UnionAll4".C7 AS C7, 
"UnionAll4".C8 AS C8, 
"UnionAll4".C9 AS C9, 
"UnionAll4".C10 AS C10, 
"UnionAll4".C11 AS C11, 
"UnionAll4".C12 AS C12, 
"UnionAll4".C13 AS C13, 
"UnionAll4".C14 AS C14, 
"UnionAll4".C15 AS C15, 
"UnionAll4".C16 AS C16, 
"UnionAll4".C17 AS C17, 
"UnionAll4".C18 AS C18, 
"UnionAll4".C19 AS C19, 
"UnionAll4".C20 AS C20, 
"UnionAll4".C21 AS C21, 
"UnionAll4".C22 AS C22, 
"UnionAll4".C23 AS C23, 
"UnionAll4".C24 AS C24, 
"UnionAll4".C25 AS C25, 
"UnionAll4".C26 AS C26, 
"UnionAll4".C27 AS C27, 
"UnionAll4".C28 AS C28, 
"UnionAll4".C29 AS C29, 
"UnionAll4".C30 AS C30, 
"UnionAll4".C31 AS C31, 
"UnionAll4".C32 AS C32
FROM  (SELECT 
	"UnionAll3".C1 AS C1, 
	"UnionAll3".C2 AS C2, 
	"UnionAll3".C3 AS C3, 
	"UnionAll3".C4 AS C4, 
	"UnionAll3".C5 AS C5, 
	"UnionAll3".C6 AS C6, 
	"UnionAll3".C7 AS C7, 
	"UnionAll3".C8 AS C8, 
	"UnionAll3".C9 AS C9, 
	"UnionAll3".C10 AS C10, 
	"UnionAll3".C11 AS C11, 
	"UnionAll3".C12 AS C12, 
	"UnionAll3".C13 AS C13, 
	"UnionAll3".C14 AS C14, 
	"UnionAll3".C15 AS C15, 
	"UnionAll3".C16 AS C16, 
	"UnionAll3".C17 AS C17, 
	"UnionAll3".C18 AS C18, 
	"UnionAll3".C19 AS C19, 
	"UnionAll3".C20 AS C20, 
	"UnionAll3".C21 AS C21, 
	"UnionAll3".C22 AS C22, 
	"UnionAll3".C23 AS C23, 
	"UnionAll3".C24 AS C24, 
	"UnionAll3".C25 AS C25, 
	"UnionAll3".C26 AS C26, 
	"UnionAll3".C27 AS C27, 
	"UnionAll3".C28 AS C28, 
	"UnionAll3".C29 AS C29, 
	"UnionAll3".C30 AS C30, 
	"UnionAll3".C31 AS C31, 
	"UnionAll3".C32 AS C32
	FROM  (SELECT 
		"UnionAll2".C1 AS C1, 
		"UnionAll2".C2 AS C2, 
		"UnionAll2".C3 AS C3, 
		"UnionAll2".C4 AS C4, 
		"UnionAll2".C5 AS C5, 
		"UnionAll2".C6 AS C6, 
		"UnionAll2".C7 AS C7, 
		"UnionAll2".C8 AS C8, 
		"UnionAll2".C9 AS C9, 
		"UnionAll2".C10 AS C10, 
		"UnionAll2".C11 AS C11, 
		"UnionAll2".C12 AS C12, 
		"UnionAll2".C13 AS C13, 
		"UnionAll2".C14 AS C14, 
		"UnionAll2".C15 AS C15, 
		"UnionAll2".C16 AS C16, 
		"UnionAll2".C17 AS C17, 
		"UnionAll2".C18 AS C18, 
		"UnionAll2".C19 AS C19, 
		"UnionAll2".C20 AS C20, 
		"UnionAll2".C21 AS C21, 
		"UnionAll2".C22 AS C22, 
		"UnionAll2".C23 AS C23, 
		"UnionAll2".C24 AS C24, 
		"UnionAll2".C25 AS C25, 
		"UnionAll2".C26 AS C26, 
		"UnionAll2".C27 AS C27, 
		"UnionAll2".C28 AS C28, 
		"UnionAll2".C29 AS C29, 
		"UnionAll2".C30 AS C30, 
		"UnionAll2".C31 AS C31, 
		"UnionAll2".C32 AS C32
		FROM  (SELECT 
			"UnionAll1".C1 AS C1, 
			"UnionAll1".PROPULSION_ID AS C2, 
			"UnionAll1".COMMENTS_NATIVE AS C3, 
			"UnionAll1".C2 AS C4, 
			"UnionAll1".C3 AS C5, 
			"UnionAll1".ASPIRATION_ID AS C6, 
			"UnionAll1".DESCRIPTION_RESOURCE_ID AS C7, 
			"UnionAll1".DEFINITION_NATIVE AS C8, 
			"UnionAll1".COMMENTS_NATIVE1 AS C9, 
			"UnionAll1".C4 AS C10, 
			"UnionAll1".C5 AS C11, 
			"UnionAll1".C6 AS C12, 
			"UnionAll1".C7 AS C13, 
			"UnionAll1".C8 AS C14, 
			"UnionAll1".C9 AS C15, 
			"UnionAll1".C10 AS C16, 
			"UnionAll1".C11 AS C17, 
			"UnionAll1".C12 AS C18,             --> fails here with ORA-01790
			"UnionAll1".C13 AS C19, 
			"UnionAll1".C14 AS C20, 
			"UnionAll1".C15 AS C21, 
			"UnionAll1".C16 AS C22, 
			"UnionAll1".C17 AS C23, 
			"UnionAll1".C18 AS C24, 
			"UnionAll1".C19 AS C25, 
			"UnionAll1".C20 AS C26, 
			"UnionAll1".C21 AS C27, 
			"UnionAll1".C22 AS C28, 
			"UnionAll1".C23 AS C29, 
			"UnionAll1".C24 AS C30, 
			"UnionAll1".C25 AS C31, 
			"UnionAll1".C26 AS C32
			FROM  (SELECT 
				"Project1".C1 AS C1, 
				"Extent1".PROPULSION_ID AS PROPULSION_ID, 
				"Extent1".COMMENTS_NATIVE AS COMMENTS_NATIVE, 
				1 AS C2, 
				"Project1".C1 AS C3, 
				"Project1".ASPIRATION_ID AS ASPIRATION_ID, 
				"Project1".DESCRIPTION_RESOURCE_ID AS DESCRIPTION_RESOURCE_ID, 
				"Project1".DEFINITION_NATIVE AS DEFINITION_NATIVE, 
				"Project1".COMMENTS_NATIVE AS COMMENTS_NATIVE1, 
				NULL AS C4, 
				NULL AS C5, 
				NULL AS C6, 
				NULL AS C7, 
				NULL AS C8, 
				NULL AS C9, 
				NULL AS C10, 
				NULL AS C11, 
				NULL AS C12, 
				NULL AS C13, 
				NULL AS C14, 
				NULL AS C15, 
				NULL AS C16, 
				NULL AS C17, 
				NULL AS C18, 
				NULL AS C19, 
				NULL AS C20, 
				NULL AS C21, 
				NULL AS C22, 
				NULL AS C23, 
				NULL AS C24, 
				NULL AS C25, 
				NULL AS C26
				FROM  TVI.PROPULSION "Extent1"
				LEFT OUTER JOIN  (SELECT 
					"Extent2".PROPULSION_ID AS PROPULSION_ID, 
					"Extent3".ASPIRATION_ID AS ASPIRATION_ID, 
					"Extent4".DESCRIPTION_RESOURCE_ID AS DESCRIPTION_RESOURCE_ID, 
					"Extent4".DEFINITION_NATIVE AS DEFINITION_NATIVE, 
					"Extent4".COMMENTS_NATIVE AS COMMENTS_NATIVE, 
					1 AS C1
					FROM   TVI.PROPULSION_ASPIRATION "Extent2"
					INNER JOIN TVI.ASPIRATION "Extent3" ON "Extent3".ASPIRATION_ID = "Extent2".ASPIRATION_ID
					LEFT OUTER JOIN WORLD.DESCRIPTION_RESOURCE "Extent4" ON "Extent3".DESCRIPTION_RESOURCE_ID = "Extent4".DESCRIPTION_RESOURCE_ID ) "Project1" ON "Extent1".PROPULSION_ID = "Project1".PROPULSION_ID
			UNION ALL
				SELECT 
				2 AS C1, 
				"Extent5".PROPULSION_ID AS PROPULSION_ID, 
				"Extent5".COMMENTS_NATIVE AS COMMENTS_NATIVE, 
				1 AS C2, 
				NULL AS C3, 
				NULL AS C4, 
				NULL AS C5, 
				NULL AS C6, 
				NULL AS C7, 
				1 AS C8, 
				"Join4".BASE_ENGINE_ID1 AS BASE_ENGINE_ID, 
				"Join4".FAMILY_CODE AS FAMILY_CODE, 
				"Join4".CUBIC_CAPACITY AS CUBIC_CAPACITY, 
				"Join4".BORE_MM AS BORE_MM, 
				"Join4".STROKE_MM AS STROKE_MM, 
				"Join4".ENGINE_CONFIGURATION_ID AS ENGINE_CONFIGURATION_ID, 
				"Join4".MANUFACTURER_BRAND_ID AS MANUFACTURER_BRAND_ID, 
				NULL AS C9, 
				NULL AS C10, 
				NULL AS C11, 
				NULL AS C12, 
				NULL AS C13, 
				NULL AS C14, 
				NULL AS C15, 
				NULL AS C16, 
				NULL AS C17, 
				NULL AS C18, 
				NULL AS C19, 
				NULL AS C20, 
				NULL AS C21, 
				NULL AS C22, 
				NULL AS C23
				FROM  TVI.PROPULSION "Extent5"
				INNER JOIN  (SELECT "Extent6".PROPULSION_ID AS PROPULSION_ID, "Extent6".BASE_ENGINE_ID AS BASE_ENGINE_ID2, "Extent7".BASE_ENGINE_ID AS BASE_ENGINE_ID1, "Extent7".ENGINE_CONFIGURATION_ID AS ENGINE_CONFIGURATION_ID, "Extent7".MANUFACTURER_BRAND_ID AS MANUFACTURER_BRAND_ID, "Extent7".FAMILY_CODE AS FAMILY_CODE, "Extent7".CUBIC_CAPACITY AS CUBIC_CAPACITY, "Extent7".BORE_MM AS BORE_MM, "Extent7".STROKE_MM AS STROKE_MM
					FROM  TVI.PROPULSION_BASE_ENGINE "Extent6"
					INNER JOIN TVI.BASE_ENGINE "Extent7" ON "Extent7".BASE_ENGINE_ID = "Extent6".BASE_ENGINE_ID ) "Join4" ON "Extent5".PROPULSION_ID = "Join4".PROPULSION_ID) "UnionAll1"
		UNION ALL
			SELECT 
			3 AS C1, 
			"Extent8".PROPULSION_ID AS PROPULSION_ID, 
			"Extent8".COMMENTS_NATIVE AS COMMENTS_NATIVE, 
			1 AS C2, 
			NULL AS C3, 
			NULL AS C4, 
			NULL AS C5, 
			NULL AS C6, 
			NULL AS C7, 
			NULL AS C8, 
			NULL AS C9, 
			NULL AS C10, 
			NULL AS C11, 
			NULL AS C12, 
			NULL AS C13, 
			NULL AS C14, 
			NULL AS C15, 
			1 AS C16, 
			"Join6".BASE_MOTOR_ID1 AS BASE_MOTOR_ID, 
			"Join6".FAMILY_CODE AS FAMILY_CODE, 
			"Join6".VOLTAGE AS VOLTAGE, 
			"Join6".MANUFACTURER_BRAND_ID AS MANUFACTURER_BRAND_ID, 
			NULL AS C17, 
			NULL AS C18, 
			NULL AS C19, 
			NULL AS C20, 
			NULL AS C21, 
			NULL AS C22, 
			NULL AS C23, 
			NULL AS C24, 
			NULL AS C25, 
			NULL AS C26
			FROM  TVI.PROPULSION "Extent8"
			INNER JOIN  (SELECT "Extent9".PROPULSION_ID AS PROPULSION_ID, "Extent9".BASE_MOTOR_ID AS BASE_MOTOR_ID2, "Extent10".BASE_MOTOR_ID AS BASE_MOTOR_ID1, "Extent10".MANUFACTURER_BRAND_ID AS MANUFACTURER_BRAND_ID, "Extent10".FAMILY_CODE AS FAMILY_CODE, "Extent10".VOLTAGE AS VOLTAGE
				FROM  TVI.PROPULSION_BASE_MOTOR "Extent9"
				INNER JOIN TVI.BASE_MOTOR "Extent10" ON "Extent10".BASE_MOTOR_ID = "Extent9".BASE_MOTOR_ID ) "Join6" ON "Extent8".PROPULSION_ID = "Join6".PROPULSION_ID) "UnionAll2"
	UNION ALL
		SELECT 
		4 AS C1, 
		"Extent11".PROPULSION_ID AS PROPULSION_ID, 
		"Extent11".COMMENTS_NATIVE AS COMMENTS_NATIVE, 
		1 AS C2, 
		NULL AS C3, 
		NULL AS C4, 
		NULL AS C5, 
		NULL AS C6, 
		NULL AS C7, 
		NULL AS C8, 
		NULL AS C9, 
		NULL AS C10, 
		NULL AS C11, 
		NULL AS C12, 
		NULL AS C13, 
		NULL AS C14, 
		NULL AS C15, 
		NULL AS C16, 
		NULL AS C17, 
		NULL AS C18, 
		NULL AS C19, 
		NULL AS C20, 
		1 AS C21, 
		"Join9".FUEL_DELIVERY_ID1 AS FUEL_DELIVERY_ID, 
		"Join9".DESCRIPTION_RESOURCE_ID1 AS DESCRIPTION_RESOURCE_ID, 
		"Join9".DEFINITION_NATIVE AS DEFINITION_NATIVE, 
		"Join9".COMMENTS_NATIVE AS COMMENTS_NATIVE1, 
		NULL AS C22, 
		NULL AS C23, 
		NULL AS C24, 
		NULL AS C25, 
		NULL AS C26
		FROM  TVI.PROPULSION "Extent11"
		INNER JOIN  (SELECT "Extent12".PROPULSION_ID AS PROPULSION_ID, "Extent12".FUEL_DELIVERY_ID AS FUEL_DELIVERY_ID2, "Extent13".FUEL_DELIVERY_ID AS FUEL_DELIVERY_ID1, "Extent13".DESCRIPTION_RESOURCE_ID AS DESCRIPTION_RESOURCE_ID2, "Extent14".DESCRIPTION_RESOURCE_ID AS DESCRIPTION_RESOURCE_ID1, "Extent14".DEFINITION_NATIVE AS DEFINITION_NATIVE, "Extent14".COMMENTS_NATIVE AS COMMENTS_NATIVE
			FROM   TVI.PROPULSION_FUEL_DELIVERY "Extent12"
			INNER JOIN TVI.FUEL_DELIVERY "Extent13" ON "Extent13".FUEL_DELIVERY_ID = "Extent12".FUEL_DELIVERY_ID
			LEFT OUTER JOIN WORLD.DESCRIPTION_RESOURCE "Extent14" ON "Extent13".DESCRIPTION_RESOURCE_ID = "Extent14".DESCRIPTION_RESOURCE_ID ) "Join9" ON "Extent11".PROPULSION_ID = "Join9".PROPULSION_ID) "UnionAll3"
UNION ALL
	SELECT 
	5 AS C1, 
	"Extent15".PROPULSION_ID AS PROPULSION_ID, 
	"Extent15".COMMENTS_NATIVE AS COMMENTS_NATIVE, 
	1 AS C2, 
	NULL AS C3, 
	NULL AS C4, 
	NULL AS C5, 
	NULL AS C6, 
	NULL AS C7, 
	NULL AS C8, 
	NULL AS C9, 
	NULL AS C10, 
	NULL AS C11, 
	NULL AS C12, 
	NULL AS C13, 
	NULL AS C14, 
	NULL AS C15, 
	NULL AS C16, 
	NULL AS C17, 
	NULL AS C18, 
	NULL AS C19, 
	NULL AS C20, 
	NULL AS C21, 
	NULL AS C22, 
	NULL AS C23, 
	NULL AS C24, 
	NULL AS C25, 
	1 AS C26, 
	"Join12".FUEL_ID1 AS FUEL_ID, 
	"Join12".DESCRIPTION_RESOURCE_ID3 AS DESCRIPTION_RESOURCE_ID, 
	"Join12".DEFINITION_NATIVE AS DEFINITION_NATIVE, 
	"Join12".COMMENTS_NATIVE AS COMMENTS_NATIVE1
	FROM  TVI.PROPULSION "Extent15"
	INNER JOIN  (SELECT "Extent16".PROPULSION_ID AS PROPULSION_ID, "Extent16".FUEL_ID AS FUEL_ID2, "Extent17".FUEL_ID AS FUEL_ID1, "Extent17".DESCRIPTION_RESOURCE_ID AS DESCRIPTION_RESOURCE_ID4, "Extent18".DESCRIPTION_RESOURCE_ID AS DESCRIPTION_RESOURCE_ID3, "Extent18".DEFINITION_NATIVE AS DEFINITION_NATIVE, "Extent18".COMMENTS_NATIVE AS COMMENTS_NATIVE
		FROM   TVI.PROPULSION_FUEL "Extent16"
		INNER JOIN TVI.FUEL "Extent17" ON "Extent17".FUEL_ID = "Extent16".FUEL_ID
		LEFT OUTER JOIN WORLD.DESCRIPTION_RESOURCE "Extent18" ON "Extent17".DESCRIPTION_RESOURCE_ID = "Extent18".DESCRIPTION_RESOURCE_ID ) "Join12" ON "Extent15".PROPULSION_ID = "Join12".PROPULSION_ID) "UnionAll4"
ORDER BY "UnionAll4".C2 ASC, "UnionAll4".C1 ASC

epsilon
Posts: 2
Joined: Wed 14 Oct 2009 12:44

Post by epsilon » Thu 15 Oct 2009 11:28

AndreyR wrote:2Tom, Epsilon:
Could you please send us (support * devart * com, subject "EF: Multiple Includes") a small test project reproducing the problem?
As I have already mentioned, the Lee's test project worked fine with the latest version.
Hi,

I sent you a test project.

Regards,

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 16 Oct 2009 14:30

This problem is associated with the fact that we have changed the behaviour associated with
typed Nulls in Oracle. The change was caused by the Charset mismatch problems in some situations.
To fix the issue you should set Devart.Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls
to true before the query is executed.

estern
Posts: 19
Joined: Tue 27 Jan 2009 18:59

Devart.Data.Oracle.Entity.OracleEntityProviderServices.Typed

Post by estern » Fri 16 Oct 2009 15:29

I'm using silverlight on the front end and the entity framework for data access. I have no idea where to sent the above parameter to true - is there a web.config setting I can use?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 19 Oct 2009 08:23

You can implement the OnContextCreated partial method for your ObjectContext, like this:

Code: Select all

  public partial class Entities {
    partial void OnContextCreated () {
      Devart.Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls = true;
    }
  }

estern
Posts: 19
Joined: Tue 27 Jan 2009 18:59

ORA-01790

Post by estern » Sat 24 Oct 2009 00:30

got it thanks - here is a vb implementation

Namespace nWorkArea
' fix ORA-01790
Partial Public Class WorkAreaEntities

Private Sub OnContextCreated()
Devart.Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls = True
End Sub

End Class
End Namespace

marc.wuergler
Posts: 3
Joined: Wed 22 Jul 2009 14:17

Performance

Post by marc.wuergler » Wed 28 Oct 2009 07:57

Hello!

I have upgraded to the version 5.25.49, but since then, I also had that expression error.

So I did what is written in this forum (TypeNulls = true). This made it work...

BUT... since then I have big performance problems... An operation that took 1-2 seconds before now takes more than 20 seconds... (create a few new entities and add them to the context).

Any idea?

Thanks for your help

Post Reply