Devart Forums

jacksparrow

We are able to fix the issue by uninstalling .Net Framework 4.5 on the affected workstation. dotConnect for Oracle version 5.70.190 works correctly with .Net Framework 4.0. We are also able to try dotConnect for Oracle version 8.3.125 (with .Net Framework 4.0) without any issues. Thanks for the support.

jacksparrow

We are using dotConnect for Oracle version 5.70.190. This version is installed on our production server and the application runs fine with the same code. This problem appears in developer workstations when running the application under Visual Studo 2010. Hence an upgrade at this point is not warranted.

Seems like the problem is related to the version of Oracle client software installed on the machines. Please let us know how dotConnect for Oracle, interacts with the Oracle client software.

jacksparrow

Hello,

We have the following LINQ query for Oracle which generates the "ORA-00904: \"TOLOWER\": invalid identifier" exception. Please advice on the solution.

Code: Select all

var qry = from proddesc in entities.Productdescriptions.Include("Product")
                          from manuf in entities.Optionsmanufacturers
                          where proddesc.Languageid == languageID
                          && proddesc.Product.Optionsmanufacturerid == manuf.Optionsmanufacturerid
                          && proddesc.Product.Producttype.ToLower() == productType.ToLower()
                          && manuf.Languageid == DefaultLanguage
                          && (proddesc.Isdeleted == null || proddesc.Isdeleted == 0)
                          && (proddesc.Product.Isdeleted == null || proddesc.Product.Isdeleted == 0)
                          && (manuf.Isdeleted == null || manuf.Isdeleted == 0)
                          orderby proddesc.Publishdate descending
                          select new { proddesc, manuf, product=proddesc.Product };

The below SQL query trace is obtained using dbMonitor.

Code: Select all

SELECT 
"Project1".C1 AS C1, 
"Project1".SKU AS SKU, 
"Project1".NAME AS NAME, 
"Project1".DESCRIPTIONSHORT AS DESCRIPTIONSHORT, 
"Project1".DESCRIPTIONLONG AS DESCRIPTIONLONG, 
"Project1".MARKETINGTEXT AS MARKETINGTEXT, 
"Project1".LANGUAGEID AS LANGUAGEID, 
"Project1".TAGLINE AS TAGLINE, 
"Project1".LEGALTERM AS LEGALTERM, 
"Project1".ISTRANSLATIONNEEDED AS ISTRANSLATIONNEEDED, 
"Project1".IMMUTABLE AS IMMUTABLE, 
"Project1".UPDATEDDATE AS UPDATEDDATE, 
"Project1".PUBLISHSTATUS AS PUBLISHSTATUS, 
"Project1".PUBLISHDATE AS PUBLISHDATE, 
"Project1".ISDELETED AS ISDELETED, 
"Project1".CREATEDBY AS CREATEDBY, 
"Project1".UPDATEDBY AS UPDATEDBY, 
"Project1".VIDEOID AS VIDEOID, 
"Project1".CROSSSELLIMAGEID AS CROSSSELLIMAGEID, 
"Project1".UPSELLIMAGEID AS UPSELLIMAGEID, 
"Project1".OPTIONSMANUFACTURERID AS OPTIONSMANUFACTURERID, 
"Project1".NAME1 AS NAME1, 
"Project1".SORTORDER AS SORTORDER, 
"Project1".LANGUAGEID1 AS LANGUAGEID1, 
"Project1".IMMUTABLE1 AS IMMUTABLE1, 
"Project1".OPUSMANUFACTURERID AS OPUSMANUFACTURERID, 
"Project1".OPUSLOADDATE AS OPUSLOADDATE, 
"Project1".LASTMODIFIEDDATE AS LASTMODIFIEDDATE, 
"Project1".ISDELETED1 AS ISDELETED1, 
"Project1".UPDATEDBY1 AS UPDATEDBY1, 
"Project1".PUBLISHSTATUS1 AS PUBLISHSTATUS1, 
"Project1".PUBLISHDATE1 AS PUBLISHDATE1, 
"Project1".UPDATEDDATE1 AS UPDATEDDATE1, 
"Project1".ISTRANSLATIONNEEDED1 AS ISTRANSLATIONNEEDED1, 
"Project1".MANUFACTURERIMAGE AS MANUFACTURERIMAGE, 
"Project1".SKU1 AS SKU1, 
"Project1".PRODUCTTYPE AS PRODUCTTYPE, 
"Project1".MODELNUMBER AS MODELNUMBER, 
"Project1".PRODUCTSIZE AS PRODUCTSIZE, 
"Project1".WEIGHT AS WEIGHT, 
"Project1".FULLSIZEIMAGEURL AS FULLSIZEIMAGEURL, 
"Project1".THUMBNAILIMAGEURL AS THUMBNAILIMAGEURL, 
"Project1".STATUS AS STATUS, 
"Project1".SORTORDER1 AS SORTORDER1, 
"Project1".IMMUTABLE2 AS IMMUTABLE2, 
"Project1".OPTIONSMANUFACTURERID1 AS OPTIONSMANUFACTURERID1, 
"Project1".OPUSLOADDATE1 AS OPUSLOADDATE1, 
"Project1".COLOR AS COLOR, 
"Project1".PUBLISHSTATUS2 AS PUBLISHSTATUS2, 
"Project1".PUBLISHDATE2 AS PUBLISHDATE2, 
"Project1".LASTMODIFIEDDATE1 AS LASTMODIFIEDDATE1, 
"Project1".ISDELETED2 AS ISDELETED2, 
"Project1".RELEASEDATE AS RELEASEDATE, 
"Project1".OPTIONSMODULEID AS OPTIONSMODULEID, 
"Project1".REBATEPRICE AS REBATEPRICE, 
"Project1".REBATELEGALTERM AS REBATELEGALTERM, 
"Project1".ISSMALLBUSINESS AS ISSMALLBUSINESS, 
"Project1".OPTIONSSTYLEID AS OPTIONSSTYLEID, 
"Project1".CREATEDBY1 AS CREATEDBY1, 
"Project1".CREATEDON AS CREATEDON, 
"Project1".UPDATEDBY2 AS UPDATEDBY2, 
"Project1".UPDATEDDATE2 AS UPDATEDDATE2, 
"Project1".DISPLAYBARCODE AS DISPLAYBARCODE, 
"Project1".SKU_CATEGORY AS SKU_CATEGORY, 
"Project1".IMEI_TYPE AS IMEI_TYPE, 
"Project1".TECHNOLOGY_TYPE AS TECHNOLOGY_TYPE, 
"Project1".DEALER_COST AS DEALER_COST, 
"Project1".CHANNEL AS CHANNEL, 
"Project1".COMMISSIONABLE AS COMMISSIONABLE, 
"Project1".MSRP AS MSRP
FROM ( SELECT 
	"Filter1".SKU AS SKU, 
	"Filter1".NAME1 AS NAME, 
	"Filter1".DESCRIPTIONSHORT AS DESCRIPTIONSHORT, 
	"Filter1".DESCRIPTIONLONG AS DESCRIPTIONLONG, 
	"Filter1".MARKETINGTEXT AS MARKETINGTEXT, 
	"Filter1".LANGUAGEID1 AS LANGUAGEID, 
	"Filter1".TAGLINE AS TAGLINE, 
	"Filter1".LEGALTERM AS LEGALTERM, 
	"Filter1".ISTRANSLATIONNEEDED1 AS ISTRANSLATIONNEEDED, 
	"Filter1".IMMUTABLE1 AS IMMUTABLE, 
	"Filter1".UPDATEDDATE1 AS UPDATEDDATE, 
	"Filter1".PUBLISHSTATUS1 AS PUBLISHSTATUS, 
	"Filter1".PUBLISHDATE1 AS PUBLISHDATE, 
	"Filter1".ISDELETED1 AS ISDELETED, 
	"Filter1".CREATEDBY AS CREATEDBY, 
	"Filter1".UPDATEDBY1 AS UPDATEDBY, 
	"Filter1".VIDEOID AS VIDEOID, 
	"Filter1".CROSSSELLIMAGEID AS CROSSSELLIMAGEID, 
	"Filter1".UPSELLIMAGEID AS UPSELLIMAGEID, 
	"Filter1".OPTIONSMANUFACTURERID AS OPTIONSMANUFACTURERID, 
	"Filter1".NAME2 AS NAME1, 
	"Filter1".SORTORDER AS SORTORDER, 
	"Filter1".LANGUAGEID2 AS LANGUAGEID1, 
	"Filter1".IMMUTABLE2 AS IMMUTABLE1, 
	"Filter1".OPUSMANUFACTURERID AS OPUSMANUFACTURERID, 
	"Filter1".OPUSLOADDATE AS OPUSLOADDATE, 
	"Filter1".LASTMODIFIEDDATE AS LASTMODIFIEDDATE, 
	"Filter1".ISDELETED2 AS ISDELETED1, 
	"Filter1".UPDATEDBY2 AS UPDATEDBY1, 
	"Filter1".PUBLISHSTATUS2 AS PUBLISHSTATUS1, 
	"Filter1".PUBLISHDATE2 AS PUBLISHDATE1, 
	"Filter1".UPDATEDDATE2 AS UPDATEDDATE1, 
	"Filter1".ISTRANSLATIONNEEDED2 AS ISTRANSLATIONNEEDED1, 
	"Filter1".MANUFACTURERIMAGE AS MANUFACTURERIMAGE, 
	"Extent3".SKU AS SKU1, 
	"Extent3".PRODUCTTYPE AS PRODUCTTYPE, 
	"Extent3".MODELNUMBER AS MODELNUMBER, 
	"Extent3".PRODUCTSIZE AS PRODUCTSIZE, 
	"Extent3".WEIGHT AS WEIGHT, 
	"Extent3".FULLSIZEIMAGEURL AS FULLSIZEIMAGEURL, 
	"Extent3".THUMBNAILIMAGEURL AS THUMBNAILIMAGEURL, 
	"Extent3".STATUS AS STATUS, 
	"Extent3".SORTORDER AS SORTORDER1, 
	"Extent3".IMMUTABLE AS IMMUTABLE2, 
	"Extent3".OPTIONSMANUFACTURERID AS OPTIONSMANUFACTURERID1, 
	"Extent3".OPUSLOADDATE AS OPUSLOADDATE1, 
	"Extent3".COLOR AS COLOR, 
	"Extent3".PUBLISHSTATUS AS PUBLISHSTATUS2, 
	"Extent3".PUBLISHDATE AS PUBLISHDATE2, 
	"Extent3".LASTMODIFIEDDATE AS LASTMODIFIEDDATE1, 
	"Extent3".ISDELETED AS ISDELETED2, 
	"Extent3".RELEASEDATE AS RELEASEDATE, 
	"Extent3".OPTIONSMODULEID AS OPTIONSMODULEID, 
	"Extent3".REBATEPRICE AS REBATEPRICE, 
	"Extent3".REBATELEGALTERM AS REBATELEGALTERM, 
	"Extent3".ISSMALLBUSINESS AS ISSMALLBUSINESS, 
	"Extent3".OPTIONSSTYLEID AS OPTIONSSTYLEID, 
	"Extent3".CREATEDBY AS CREATEDBY1, 
	"Extent3".CREATEDON AS CREATEDON, 
	"Extent3".UPDATEDBY AS UPDATEDBY2, 
	"Extent3".UPDATEDDATE AS UPDATEDDATE2, 
	"Extent3".DISPLAYBARCODE AS DISPLAYBARCODE, 
	"Extent3".SKU_CATEGORY AS SKU_CATEGORY, 
	"Extent3".IMEI_TYPE AS IMEI_TYPE, 
	"Extent3".TECHNOLOGY_TYPE AS TECHNOLOGY_TYPE, 
	"Extent3".DEALER_COST AS DEALER_COST, 
	"Extent3".CHANNEL AS CHANNEL, 
	"Extent3".COMMISSIONABLE AS COMMISSIONABLE, 
	"Extent3".MSRP AS MSRP, 
	1 AS C1
	FROM   (SELECT "Extent1".SKU AS SKU, "Extent1".NAME AS NAME1, "Extent1".DESCRIPTIONSHORT AS DESCRIPTIONSHORT, "Extent1".DESCRIPTIONLONG AS DESCRIPTIONLONG, "Extent1".MARKETINGTEXT AS MARKETINGTEXT, "Extent1".LANGUAGEID AS LANGUAGEID1, "Extent1".TAGLINE AS TAGLINE, "Extent1".LEGALTERM AS LEGALTERM, "Extent1".ISTRANSLATIONNEEDED AS ISTRANSLATIONNEEDED1, "Extent1".IMMUTABLE AS IMMUTABLE1, "Extent1".UPDATEDDATE AS UPDATEDDATE1, "Extent1".PUBLISHSTATUS AS PUBLISHSTATUS1, "Extent1".PUBLISHDATE AS PUBLISHDATE1, "Extent1".ISDELETED AS ISDELETED1, "Extent1".CREATEDBY AS CREATEDBY, "Extent1".UPDATEDBY AS UPDATEDBY1, "Extent1".VIDEOID AS VIDEOID, "Extent1".CROSSSELLIMAGEID AS CROSSSELLIMAGEID, "Extent1".UPSELLIMAGEID AS UPSELLIMAGEID, "Extent2".OPTIONSMANUFACTURERID AS OPTIONSMANUFACTURERID, "Extent2".NAME AS NAME2, "Extent2".SORTORDER AS SORTORDER, "Extent2".LANGUAGEID AS LANGUAGEID2, "Extent2".IMMUTABLE AS IMMUTABLE2, "Extent2".OPUSMANUFACTURERID AS OPUSMANUFACTURERID, "Extent2".OPUSLOADDATE AS OPUSLOADDATE, "Extent2".LASTMODIFIEDDATE AS LASTMODIFIEDDATE, "Extent2".ISDELETED AS ISDELETED2, "Extent2".UPDATEDBY AS UPDATEDBY2, "Extent2".PUBLISHSTATUS AS PUBLISHSTATUS2, "Extent2".PUBLISHDATE AS PUBLISHDATE2, "Extent2".UPDATEDDATE AS UPDATEDDATE2, "Extent2".ISTRANSLATIONNEEDED AS ISTRANSLATIONNEEDED2, "Extent2".MANUFACTURERIMAGE AS MANUFACTURERIMAGE
		FROM  JANUSSTG.PRODUCTDESCRIPTION "Extent1"
		CROSS JOIN JANUSSTG.OPTIONSMANUFACTURER "Extent2"
		WHERE ((1 = "Extent2".LANGUAGEID) AND (("Extent1".ISDELETED IS NULL) OR (0 = "Extent1".ISDELETED))) AND (("Extent2".ISDELETED IS NULL) OR (0 = "Extent2".ISDELETED)) ) "Filter1"
	INNER JOIN JANUSSTG.PRODUCT "Extent3" ON ("Filter1".OPTIONSMANUFACTURERID = "Extent3".OPTIONSMANUFACTURERID) AND ("Filter1".SKU = "Extent3".SKU)
	WHERE ((("Extent3".ISDELETED IS NULL) OR (0 = "Extent3".ISDELETED)) AND ("Filter1".LANGUAGEID1 = :p__linq__0)) AND ((ToLower("Extent3".PRODUCTTYPE)) = (ToLower(:p__linq__1)))
)  "Project1"
ORDER BY "Project1".PUBLISHDATE DESC

jacksparrow

Hello,

We use dotconnect for Oracle and have three schemas (Master, Staging and Prod) in our database. We have three SSDL files, one corresponding to each schema. Until now all the schemas had the same table structure, but now we have less number of columns in one of the table in one schema. We have one Data Model for all three schemas and use the different SSDL files when querying the corresponding schema. Is there a way to ignore columns in the SSDL file (or elsewhere), so we can continue using a single Data Model?

Thanks.

jacksparrow

I have sent the table creation scripts. Please keep us posted on your findings.

jacksparrow

I am able to create the association manually in the Designer as follows (in the .edml file).

Code: Select all

The generated x.Designer.cs file also includes the below navigation properties for the Productdescription class.

Code: Select all

#region Navigation Properties

        /// 
        /// There are no comments for Product in the schema.
        /// 
        [XmlIgnoreAttribute()]
        [SoapIgnoreAttribute()]
        [DataMemberAttribute()]
        [EdmRelationshipNavigationPropertyAttribute("x", "Product_Productdescription", "Product")]
        public Product Product
        {
            get
            {
                return ((IEntityWithRelationships)(this)).RelationshipManager.GetRelatedReference("x.Product_Productdescription", "Product").Value;
            }
            set
            {
                ((IEntityWithRelationships)(this)).RelationshipManager.GetRelatedReference("x.Product_Productdescription", "Product").Value = value;
            }
        }

        /// 
        /// There are no comments for Product in the schema.
        /// 
        [BrowsableAttribute(false)]
        [DataMemberAttribute()]
        public EntityReference ProductReference
        {
            get
            {
                return ((IEntityWithRelationships)(this)).RelationshipManager.GetRelatedReference("x.Product_Productdescription", "Product");
            }
            set
            {
                if (value != null)
                {
                    ((IEntityWithRelationships)(this)).RelationshipManager.InitializeRelatedReference("x.Product_Productdescription", "Product", value);
                }
                else 
                {
                    ((IEntityWithRelationships)(this)).RelationshipManager.GetRelatedReference("x.Product_Productdescription", "Product").Value = null;
                }
            }
        }

        #endregion

Please let us know if it is a limitation of the Devart Entity designer to generate the AssociationSet automatically.

jacksparrow

I am running into the same error in our project. Please Advise.

Message:
OUTER APPLY is not supported by Oracle

Source:
Devart.Data.Oracle.Entity

StackTrace:
at Devart.Data.Oracle.Entity.k.a(DbApplyExpression A_0)
at System.Data.Common.CommandTrees.DbApplyExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
at Devart.Common.Entity.f.a(DbExpression A_0, String A_1, TypeUsage A_2, o& A_3)
at Devart.Common.Entity.f.a(DbProjectExpression A_0)
at System.Data.Common.CommandTrees.DbProjectExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
at Devart.Common.Entity.f.a(DbExpression A_0, String A_1, TypeUsage A_2, o& A_3)
at Devart.Common.Entity.f.a(DbSortExpression A_0)
at System.Data.Common.CommandTrees.DbSortExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
at Devart.Common.Entity.f.a(DbExpression A_0, String A_1, TypeUsage A_2, o& A_3)
at Devart.Common.Entity.f.a(DbProjectExpression A_0)
at System.Data.Common.CommandTrees.DbProjectExpression.Accept[TResultType](DbExpressionVisitor`1 visitor)
at Devart.Common.Entity.f.a(DbExpression A_0, Boolean A_1, o& A_2)
at Devart.Common.Entity.f.f(DbExpression A_0)
at Devart.Common.Entity.f.a(DbQueryCommandTree A_0, List`1& A_1)
at Devart.Data.Oracle.Entity.k.a(DbCommandTree A_0, DbConnection A_1, DbProviderManifest A_2)
at Devart.Data.Oracle.Entity.OracleEntityProviderServices.a(DbProviderManifest A_0, DbCommandTree A_1)
at Devart.Data.Oracle.Entity.OracleEntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
at System.Data.EntityClient.EntityCommandDefinition..ctor(DbProviderFactory storeProviderFactory, DbCommandTree commandTree)

jacksparrow

Hello,

We are using dotconnect for Oracle v5.70.152 for generating Entity Framework.

We have a Product table with sku as PK and ProductDescription table with sku, languageId as composite PK. The sku in ProductDescription table is a FK to the (PK) sku column in Product table. When we generate the EF, the sku FK relationship is not mapped. If the FK is not part of a PK, the relationship is generated correctly.

Please let us know if this is a bug in the Devart EF.

Thanks.

jacksparrow

We are using dotconnect for Oracle to generate our EDM for website.

The entities are detached since we pass them thru our service layer. We have a User table, with a foreign key to a Role table. When a User's role is updated the foreign key is not updated in the User Table.

The EDM generates a Role property and RoleReference property on the User Entity. When the SaveChanges method is called, the above two property changes are not propogated to the DB, since they are in Unchanged State (due to the dettached nature of the User Entity).

Devart Forums

Search found 9 matches

Re: ORA-00904: \"TOLOWER\": invalid identifier

Re: ORA-00904: \"TOLOWER\": invalid identifier

ORA-00904: \"TOLOWER\": invalid identifier

Ignore columns in SSDL

AssociationSetMapping for Composite PK - Foreign Key

Update Related Entities