Devart Forums

lancelotti

Pinturiccio wrote:Please make sure that:
1. You have deleted all assemblies with name, starting with "Devart", from GAC;
2. You have deleted all assemblies from the folders c:\Program Files (x86)\Common Files\Devart\ and d:\Program Files (x86)\Devart\

None of this folders exists. I'm trying to do this from days and days =[

I've tried to install every version since 2011 until now and the same error... I'm almost reinstalling Windows.

lancelotti

I have the same problem with no solution until now.

I've uninstalled all Devart products, cleaned GAC, cleaned Windows Registry and same error on install new Devart Version.

I've tried everything that are saying in forums and so on.

The error persist:
"Devart.Data assembly version 5.0.272.0 is found in Global Assembly Cache.
This product is compatible with Devart.Data.dll version 5.0.431.0."

lancelotti

AndreyR wrote:Our code creates a sequence and a BEFORE INSERT trigger initializing the auto-increment column.

Can I get this generated Id automatically after SaveChanges?

lancelotti

Shalex wrote: Please try using the Unicode=true; connection string parameter to use unicode at transport level when Direct=true.

I'd ever tried it before.

lancelotti

When I using Direct=true, Oracle doesn't understand some characters like — and “.

When I switch Direct=false it works.

I use BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1.

Thanks.

lancelotti

If I want to filter results by DateTime.Now it doesn't work.

Like this:

Code: Select all

var capa = from c in db.CapaAgendamentos where c.Publicacao <= DateTime.Now select c;

This is the SQL shown in debug mode... if I test directly in Oracle, it works.

Code: Select all

SELECT * FROM SITE.TD_CAPA_AGENDAMENTO WHERE PUBLICACAO <= (CURRENT_DATE)

Directly in Oracle it returns only rows that "PUBLICACAO" was in the past hours, but in EntityFramework, it returns rows in the future too.

Any idea?

Ps. In the future I mean in the next hours, but not in the next days.

[UPDATE]
If I define a variable first, it works. Ex.:

Code: Select all

DateTime now = DateTime.Now;
var capa = from c in db.CapaAgendamentos where c.Publicacao <= now select c;

lancelotti

It works...

Code: Select all

var tmp = db.Relacionadas.First(r => r.NoticiaId == noticia.Id);
db.DeleteObject(tmp);

But it not.

Code: Select all

var tmp = db.Relacionadas.Where(r => r.NoticiaId == noticia.Id);
db.DeleteObject(tmp);

It I try .First() / .Single() ou etc, it works, but if I try to delete all objects in relation .Any() / .ToList() / .Select(), it doesn't.

I got this error in the second case
The object cannot be deleted because it was not found in the ObjectStateManager.

Any idea? Tks.

lancelotti

I've created a materialized view on Oracle but Entity Developer doesn't see it as a view nither as a table.

How can I map it?

lancelotti

AndreyR wrote:I have sent you a sample MVC project.

Can you send it to me too? I'm trying Visual Studio 2010 and MVC2, but I'm getting the same error and workaround doesn't work.

lancelotti

It works if I put the full path... now I'll try the relative one!

lancelotti

Now I got "The specified metadata path is not valid. A valid path must be either an existing directory, an existing file with extension '.csdl', '.ssdl', or '.msl', or a URI that identifies an embedded resource."

lancelotti

Can someone tell me how to do this work?
There is a tutorial?

I create the edml, csdl, ssdl, msl and other files, but where I should put it?

When I run the projet I got: "Unable to load the specified metadata resource. "
Here is the connection string
"metadata=res://*/OdiarioModel.csdl|res://*/OdiarioModel.ssdl|res://*/OdiarioModel.msl;provider=Devart.Data.Oracle;provider connection string=""User Id=xxx;Password=xxx;Server=xxx;Direct=True;Sid=xe;Persist Security Info=True""", "OdiarioEntities")

My files are in the root path of an MVC 2 project.

lancelotti

I'm with the same problem... Windows XP or 7 -> Visual Web Developer 2010 Beta 2 -> dcoracle560pro

lancelotti

Any progress with this?
Thanks

lancelotti

Yes, Entity Framework generete a 1 to 0...1 while Linq to SQL generate a 1 to *

Code: Select all

CREATE TABLE "PESSOA"
  (
    "ID" NUMBER(9,0) NOT NULL ENABLE,
    CONSTRAINT "PESSOA_PK" PRIMARY KEY ("ID") ENABLE
  );


CREATE TABLE "ALUNO"
  (
    "PESSOA" NUMBER(9,0) NOT NULL ENABLE,
    CONSTRAINT "ALUNO_PK" PRIMARY KEY ("PESSOA") ENABLE,
    CONSTRAINT "ALUNO_PESSOA_FK1" FOREIGN KEY ("PESSOA")   REFERENCES "PESSOA" ("ID") ENABLE
);

Devart Forums

Search found 16 matches

Same problem, no solution

Direct mode and some characters

DateTime.Now in Where Clause

DeleteObject for more than one element

Entity Developer and Materialized View

Visual Webdeveloper 2010 Express and Entity FrameworK