Devart Forums

I removed all the elements and added only those that were in our staging environment and now it works. It is entirely possible that the original model had pipelined functions.

Curious why you need the metadata during this time instead of at compile time?

-Joe

Does the Context object query Oracle when instantiated?

And if so, what is it querying for?

I'm getting this error when we are moving to staging environment but I can't pinpoint why/what it's asking oracle for, some kind of meta-data or something?

-Joe

i will email you the schema. it's not many tables but the tables have many columns. no complex types. at least none that i created, i'm assuming these aren't derived from the DB.

System.InvalidCastException: Object must implement IConvertible

I have a table with a VersionNumber column, not sure if this is related. But there are about 50 columns in this table, not sure which is throwing the error. I removed the VersionNumber column, but for some reason the generated SQL is still pulling this from the database. Any idea what's going on?

-Joe

SQL log here:


SELECT VersionNumber FROM dbo.ContactBase WHERE ContactId = @key1
-- key1: Input UniqueIdentifier (Size = 0; DbType = Guid) [71618408-7613-de11-bc5e-005056a0787b]
-- Context: Devart.Data.SqlServer.Linq.Provider.SqlDataProvider Model: ap Build: 2.50.24.0

The error is definitely being thrown from Oracle.

Also - I must be missing something because I did the above and I don't see anything being written to the console outside of exceptions.

-Joe

It appears I found the problem. When a default value for a single character column (char(1)) in oracle the default value in the generated code is producing something like:

_XyzFlag = @"'N'";

This seems to be trying to insert the value as it is, with the tic marks. That would cause the error since you are trying to insert 3 characters into a 1 character length field. This might be a wide-spread default value bug.

In order to get the row inserted I am over-riding the default value in the object to be just "N".

-Joe

I'm doing what should be inserts but I'm getting a 'data too large for column' error. I can't figure out which column it's referring to so I'd like to see the generated SQL statement. Is it possible?

I'm using LinqConnect for Oracle.

The model isn't loading the sequences back into the diagram when I re-open the designer after adding sequences, saving, and closing it.

This is rather irritating as I've gone through several times adding all my sequences, only to open and have it over-write the file again removing them.

-Joe

I'm using the wizard from LinqConnect inside VS 2010.

Set IdGenerator to Sequence and specify a sequence name.

Save the document.

Close.

Open.

Sequence is no longer set.

Hi,

I noticed the tool does not identify relationships across schemas. Is there something I'm missing or is that a known issue?