Devart Forums

skingaby

Thanks. I got the 146 version today and it has fixed this issue. The build and generation of the pregenerated views is working properly. Thanks for getting this out to us (your customers) so quickly. I am very grateful for Devart's responsiveness.

skingaby

That's great. What about the rest of what I said? Will that work as a temporary stop gap so I can upgrade?

skingaby

Thanks! I look forward to your response because this is preventing me from upgrading.
Perhaps this is irrelevant on my build machine. (It is not a dev machine, it is just used to create builds, not to regenerate the model files.
Can I just rename your MSBUILD library to hide it on that machine?

skingaby

When I run my msbuild task, I am getting this error:

"C:\_dev\ClassLibrary1\ClassLibrary1\ClassLibrary1.csproj" (Build target) (1) -
>
(DevartEntityDeploy target) ->
C:\Program Files\MSBuild\Devart\v3.5\Devart.Data.Entity.targets(32,5): error
: DevartEntityDeploy: Could not find a part of the path 'C:\_dev\ClassLibrary1\
ClassLibrary1\obj\Release\DataSourceModel1.ssdl'.

0 Warning(s)
1 Error(s)

To test it, create a new project, add a new DevArt Entity model to it, drop one table in from the database. Compile it. All is well.
Now, change the Project Output Directory in the project properties from bin\Debug to bin and from bin\Release to bin.
Now, from a command line, execute msbuild:
C:\WINDOWS\Microsoft.NET\Framework\v3.5\MSBuild.exe /nologo /t:Build /p:Configuration=Release/v:diag
Now, get the error. The changes you guys have made to the DevartEntityDeploy library, seem to have caused it to use a hard coded path to bin\Release. I did not get this error with version 5.35.62.

skingaby

Is there a version of dbForge for Oracle in the works? I am finding that most schema compare tools take forever and/or produce really lousy comparisons. Thanks, Simon

skingaby

Attachment: posting.txt

We had to pull the plug on a production deployment yesterday because of an anomaly discovered in the 11th hour in our Staging (pre-production) environment.
An Entity Query that works perfectly in our Dev and Test environments, was not returning all the expected records in the Staging environment.

We are using IdeaBlade DevForce for Silverlight (v5.2.4), Devart dotConnect for Oracle (v5.35.62), and the MS Entity Framework (.Net 3.5).

I have an entity query like so:

Code: Select all

public IEntityQuery ConfirmationsFilteredQuery(object[] parameters)
{
	var filter = (BasicFilter)parameters[0];
	var confirmationsQuery = this.ConfirmationsBaseQuery(null);

	return confirmationsQuery
		.Where(c => c.DealSnapShot.FlowDateEnd >= filter.FlowDateStart)
		.Where(c => c.DealSnapShot.FlowDateStart  c.ConfStatusId == (long)filter.SelectedStatus)
		.With(QueryStrategy.DataSourceOnly);
}

private IEntityQuery ConfirmationsBaseQuery(object[] parameters)
{
	var em = (ConfirmationEntityManager)this.PersistenceContext.EntityManager;
	return em.DealConfirmations
		.Include(DealConfirmation.EntityPropertyNames.DealConfContacts)
		.Include(DealConfirmation.EntityPropertyNames.DealConfContacts + "." + DealConfContact.EntityPropertyNames.Contact)
		.Include(DealConfirmation.EntityPropertyNames.DealSnapShot + "." + DealSnapShot.EntityPropertyNames.DealPricingSnapShots)
		.Include(DealConfirmation.EntityPropertyNames.DealSnapShot + "." + DealSnapShot.EntityPropertyNames.DealTrxPricingSnapShots)
		.Include(DealConfirmation.EntityPropertyNames.DealSnapShot + "." + DealSnapShot.EntityPropertyNames.DealTrxSnapShots);
}

When I execute this query, the generated SQL looks like (hold your nose) this:

Code: Select all

SELECT "UnionAll3".C2 AS C1,
   "UnionAll3".C3 AS C2,
   ...See attached file...

The problem is that this query only returns some of the records that should be returned. And only in one of our database environments. We have done the obvious things and all of the tables are the same. There are some differences in indexes and constraints between the database where the query works and where it doesn't.
Also, if we comment out the one of the date range where clause, i.e.:
//.Where(c => c.DealSnapShot.FlowDateStart <= filter.FlowDateEnd)
The resulting query does return all the expected records in all database environments. Here is what the working query looks like:

Code: Select all

SELECT "UnionAll3".C2 AS C1,
   "UnionAll3".C3 AS C2,
   ...See attached file...

A diff. on these two SQL files shows some obvious differences re: the where clause, and this one weird difference:

Code: Select all

"UnionAll3".C71 AS C70,
"UnionAll3".C1 AS C71,

vs.

Code: Select all

"UnionAll3".C1 AS C70,
"UnionAll3".C71 AS C71,

So, my questions are as follows:
1) Which tool actually creates this SQL statement?
2) Is it possible that differences in Indexes on the tables could alter the way the SQL Generator generates the SQL?
3) Is this fixed in a newer release?
4) How can I fix/debug this?

Thanks,
Simon

skingaby

Getting the data out of the database and into objects is only half the problem. The second half, especially in Silverlight, is getting those objects to the client. By far the easiest way to support a Silverlight client is by using the Ideablade Devforce product with the Devart dotConnect for Oracle drivers. It has been a lot of hassle being on the bleeding edge with all three technologies, but they have all stabilized a lot in the past few months. We are now using Devart's Entity Developer as a total replacement for the MS Entity Framework editor and Ideablade then extends those Entity Framework objects with a lot more eventing and a lot of additional business app. functionality.
Taken as a set, the functionality provided by these products is far and above what I can get from Linq to Oracle and saves me from writing a TON of infrastructure code.

skingaby

I second this. We have a Supplier table with a FK to Contact for the Sales Contact and the Shipping Contact. These get generated as Contact and Contact1 and the few times I have had to add these two tables to the model, it is not obvious which is which at all. Thanks!

skingaby

I have got to say that you guys are the most responsive group when it comes to fixing bugs. Many of the problems I have posted about have specifically been addressed in a subsequent release of your dotConnect for Oracle or Entity Developer products. This one wasn't even a complaint and you fixed it anyway. Thank you! Please keep up the great customer service, you guys are awesome!

skingaby

I was working with 2 versions of 2 different products on 2 machines, including your product, trying to fix a domain model problem. It is entirely conceivable that I opened the EDML in the wrong one and corrupted it. I am just glad I found/fixed it.

skingaby

The newest build has fixed this problem for me. Thanks!

skingaby

Found it. Somehow, when adding and removing and re-adding an object in the Designer (yours, not MS), the EDML duplicated the tag in here:

I finally found the error and when I removed the extra tag everything worked properly again.

skingaby

I just broke the EDML file somehow and am now getting this error. How can I figure out where this error is coming from. Thanks.

skingaby

This is working now. One caveat: carriage returns in the Oracle comment are imported into the EF Designer and DO get generated out to the .cs code file -- which is a problem, because the second line of the comment is not prefixed by /// in the .cs code and introduces a compile error. I had to remove the CR from the EF Designer version of the comment and then the generated .cs file was fine.

skingaby

I do not have a clob. I do have this table:

Code: Select all

CREATE TABLE DEAL
(
    DEAL_ID               NUMBER(10,0)   NOT NULL,
    DATE_ENTERED          DATE           DEFAULT sysdate NOT NULL,
    DATE_OF_DEAL          DATE           DEFAULT sysdate NOT NULL,
    FLOW_DATE_START       DATE           NOT NULL,
    FLOW_DATE_END         DATE           NOT NULL,
    DEAL_NUMBER           NUMBER(10,0)       NULL,
    BUS_ASSOCIATE_ID      VARCHAR2(10)       NULL,
    SUPPLY_CONTACT_ID     NUMBER(10,0)       NULL,
    CONTACT_OTHER         VARCHAR2(50)       NULL,
    MO_CONTACT_ID         NUMBER(10,0)       NULL,
    PIPELINE_ID           VARCHAR2(10)       NULL,
    ZONE_ID               NUMBER(10,0)       NULL,
    LOCATION_ID           VARCHAR2(10)       NULL,
    TRANSFER_POINT_ID     VARCHAR2(10)       NULL,
    DEAL_TYPE_ID          NUMBER(10,0)   NOT NULL,
    SUPPLY_CONTRACT_ID    VARCHAR2(10)       NULL,
    GMS_BROKER_ACCT_NBR   VARCHAR2(13)       NULL,
    RATE_PLAN_ID          VARCHAR2(10)       NULL,
    PROMOTED              NUMBER(1,0)    DEFAULT 0 NOT NULL,
    DELIVERED             NUMBER(1,0)    NOT NULL,
    CANCELED              NUMBER(1,0)    DEFAULT 0 NOT NULL,
    DEAL_TERMS_CHANGED    NUMBER(1,0)    DEFAULT 0 NOT NULL,
    DEAL_COMMENT          VARCHAR2(1000)     NULL,
    LOCKED_BY             VARCHAR2(8)        NULL,
    ENTERED_BY            VARCHAR2(8)    NOT NULL,
    LAST_UPDATE_USER      VARCHAR2(8)    NOT NULL,
    LAST_UPDATE_TMS       DATE           DEFAULT sysdate NOT NULL,
    NEED_ACCOUNT          NUMBER(1,0)    DEFAULT 0 NOT NULL,
    RESUBMITTED           NUMBER(1,0)    DEFAULT 0 NOT NULL,
    STORAGE_TRANSFER      NUMBER(1,0)    DEFAULT 0 NOT NULL,
    MO_CONTACT_OTHER      VARCHAR2(50)       NULL,
    SPECIAL_CONDITIONS    VARCHAR2(1000)     NULL,
    HAS_ATTACHED_SHEET    NUMBER(1,0)    DEFAULT 0 NOT NULL,
    ROW_VERSION           NUMBER(10,0)   DEFAULT 1 NOT NULL,
    DEAL_CONFIRMATION_ID  NUMBER(10,0)       NULL,
    DEAL552CODE_ID        VARCHAR2(10)       NULL,
    FLOW_DATE_START_YEAR  NUMBER(4,0)    NOT NULL,
    FLOW_DATE_START_MONTH NUMBER(2,0)    NOT NULL
)

And in this unit test:

Code: Select all

public void AddADeal()
{
	var em = new Entities();
	var deal = new Deal
				   {
					   DealTypeId = 1,
					   DateEntered = DateTime.Today,
					   DateOfDeal = DateTime.Today,
					   FlowDateStart = DateTime.Today,
					   FlowDateEnd = DateTime.Today,
					   EnteredBy = "SAMPLE",
					   LastUpdateUser = "SAMPLE",
					   LastUpdateTms = DateTime.Now,
					   RowVersion = 1
				   };
	var id = deal.DealId;
	em.AddToDeals(deal);
	var result = em.SaveChanges();
	Assert.IsTrue(result>0);
	Assert.AreNotEqual(id, deal.DealId);
}

I get the Can Not Convert error on this line:

Code: Select all

var result = em.SaveChanges();

Here is the content of the error:

Code: Select all

{"An error occurred while updating the entries. See the InnerException for details."}
Stack Trace:    at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
   at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
   at System.Data.Objects.ObjectContext.SaveChanges(Boolean acceptChangesDuringSave)
   at System.Data.Objects.ObjectContext.SaveChanges()
   at Model.ServerModelEF.Test.DealEfTest.AddADeal() in C:\_dev\Model.ServerModelEF.Test\DealEFTest.cs:line 47

InnerException:  {"An error occurred while preparing the command definition. See the inner exception for details."}
Stack Trace:     at System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
   at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(UpdateTranslator translator, Dictionary`2 identifierValues)
   at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
   at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

Inner Exception: {"Can not convert."}
Stack Trace:   at Devart.Data.Oracle.OracleUtils.a(Object A_0, OracleDbType A_1, Boolean A_2)
   at Devart.Data.Oracle.OracleParameter.c(Object A_0)
   at Devart.Data.Oracle.OracleParameter.get_OracleValue()
   at Devart.Data.Oracle.Entity.c.Clone()
   at Devart.Data.Oracle.Entity.h.a.o()
   at System.Data.Common.DbCommandDefinition.CreateCommandDefinition(DbCommand prototype)
   at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommand prototype)
   at Devart.Data.Oracle.Entity.OracleEntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
   at System.Data.Common.DbProviderServices.CreateCommand(DbCommandTree commandTree)
   at System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)

I installed the new devArt today. Because I was getting errors, I recreated my EF diagram from scratch (yeuch) in your EF Designer tool. I have some unit tests that read the data that are passing. The Add is failing though. Please help.

Devart Forums

Search found 33 matches

DevartEntityDeploy: Could not find a part of the path

dbForge for Oracle?

Generated (Ugly) SQL Problem

Me too