Search found 33 matches
- Thu 08 Jul 2010 05:37
- Forum: Entity Developer
- Topic: DevartEntityDeploy: Could not find a part of the path
- Replies: 7
- Views: 3712
- Wed 09 Jun 2010 20:31
- Forum: Entity Developer
- Topic: DevartEntityDeploy: Could not find a part of the path
- Replies: 7
- Views: 3712
- Tue 08 Jun 2010 14:18
- Forum: Entity Developer
- Topic: DevartEntityDeploy: Could not find a part of the path
- Replies: 7
- Views: 3712
- Mon 07 Jun 2010 18:45
- Forum: Entity Developer
- Topic: DevartEntityDeploy: Could not find a part of the path
- Replies: 7
- Views: 3712
DevartEntityDeploy: Could not find a part of the path
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.
"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.
- Fri 26 Mar 2010 14:14
- Forum: dbForge for Oracle
- Topic: dbForge for Oracle?
- Replies: 1
- Views: 2899
dbForge for Oracle?
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
- Tue 23 Feb 2010 16:15
- Forum: dotConnect for Oracle
- Topic: Generated (Ugly) SQL Problem
- Replies: 1
- Views: 1303
Generated (Ugly) SQL Problem
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:
When I execute this query, the generated SQL looks like (hold your nose) this:
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:
A diff. on these two SQL files shows some obvious differences re: the where clause, and this one weird difference:
vs.
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
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);
}
Code: Select all
SELECT "UnionAll3".C2 AS C1,
"UnionAll3".C3 AS C2,
...See attached file...
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...
Code: Select all
"UnionAll3".C71 AS C70,
"UnionAll3".C1 AS C71,
Code: Select all
"UnionAll3".C1 AS C70,
"UnionAll3".C71 AS C71,
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
- Mon 28 Dec 2009 18:39
- Forum: Entity Framework support
- Topic: LINQ to Oracle or Entity Framework?
- Replies: 7
- Views: 3828
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.
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.
- Wed 09 Dec 2009 03:53
- Forum: Entity Framework support
- Topic: Entity Developer and generated Foreign Key Names
- Replies: 4
- Views: 2154
- Wed 09 Dec 2009 03:49
- Forum: Entity Developer
- Topic: Column and Table comments
- Replies: 11
- Views: 3506
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!
- Wed 09 Dec 2009 03:47
- Forum: Entity Developer
- Topic: Error: An item with the same key has already been added.
- Replies: 6
- Views: 6748
- Wed 09 Dec 2009 03:45
- Forum: dotConnect for Oracle
- Topic: Cannot Convert error.
- Replies: 9
- Views: 2831
- Fri 04 Dec 2009 00:54
- Forum: Entity Developer
- Topic: Error: An item with the same key has already been added.
- Replies: 6
- Views: 6748
- Wed 02 Dec 2009 21:16
- Forum: Entity Developer
- Topic: Error: An item with the same key has already been added.
- Replies: 6
- Views: 6748
- Tue 24 Nov 2009 14:10
- Forum: Entity Developer
- Topic: Column and Table comments
- Replies: 11
- Views: 3506
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.
- Tue 24 Nov 2009 02:58
- Forum: dotConnect for Oracle
- Topic: Cannot Convert error.
- Replies: 9
- Views: 2831
Me too
I do not have a clob. I do have this table:
And in this unit test:
I get the Can Not Convert error on this line:
Here is the content of the error:
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.
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
)
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);
}
Code: Select all
var result = em.SaveChanges();
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)