Devart Forums

Shalex wrote:We are investigating the issue. We will notify you about the results as soon as possible.

I am curious about it.

Regards from Berlin

We created sequences in combination with triggers in our Oracle database. Before inserting a new record the trigger fetches a autoincrement value from the sequence and sets the value in the autovalue column of the table.

AndreyR wrote:Thank you for the report, we will investigate the reasons of this behaviour.
I will let you know about the results of our investigation.

Any news in this matter?

AndreyR wrote:We recommend you to create an EntitySQL query where the WHERE clause contains a condition:

Code: Select all

where property IN ({first thousand from array}) AND property IN ({second thousand from array})...

I have the same problem I tried to solve the way you recommend.
Unfortunately the IN-Clause is translated in a concatenation of ORs in this way

WHERE A.myID= 1 OR A.myID=2 OR A.myID=3 OR A.myID=4 ...
instead of
WHERE A.myID IN {1,2,3...} OR A.MyID IN {1000, 1001,...} and so on.

AndreyR wrote: Add this function to the Devart Entity model. There will be an error about the composable functions, that is correct. Now you have a stored function available in SSDL.
At this point you can use this function in a query like in the following example:

Using an Oracle function works great. Thanks for your support

I work with DevArt dotConnect for a while now and I am very satisfied so far.
But I noticed two exceptions in my output window of my VS .NET 2010 which occur all again and again.

"System.Net.Sockets.SocketException" in System.dll and "System.InvalidOperationException" in Devart.Data.dll

Anybody an idea what the reason might be?

Can´t anybody help?

Hallo Andrey,

Its nearly right. What I need is the employees department he himself belongs for the most time. It has to look something like this:
Unfortunately I get an error "E.ID invalid identifier".

AndreyR wrote:Could you please provide a DDL script of your db objects?

It was just a hypothetical database. My database is much more complex.
Using the example of the Northwind database imagine the table 'Territories' owns additional column of type double 'TerritoryArea'.
My EntitySQL query has to fetch the data of employee with the ID e.g. 1 and the territory he belongs to with the largest area.

Cheers
bolek75

AndreyR wrote:Here is the code:

Code: Select all

SELECT E.SurName, E.FirstName, E.Department.DeptName, 
          MIN(SELECT VALUE ED.EntryDate FROM Empldeparts AS ED WHERE ED.EmplID=E.ID) FROM Employees AS E

Hallo AndreyR,

thanx for your help. The sub clause with MIN works fine. But how to retrieve the department name. Employee has a collections of departments not a single department reference as suggested by your SQL.

Cheers
bolek75

In my winform app using EF4 and dotConnect for Oracle I am switching betwenn SQL Server 2005 and Oracle 10g Express Edition. I am using 2 separate EDMX. I noticed that the performance on the Oracle DB is worse than on a sql server.
E.g. loading my master object plus details in my winform takes 700 msec on sql server, the same operation takes round about 3000 msec connecting to the oracle database.
Does anybody have some general hints on this problem?

Cheers
bolek

I have to use EntitySQL. How would you express this in EntitySQL?

Hi folks,

I have problems expressing something like this in my EntitySQL using dotConnect for Oracle because it is resulting in a exception "Oracle is not supporting OUTER APPLY". Now I cant find an alternative and dont know what to do.

SELECT E.SurName, E.FirstName, E.Department.DeptName, (SELECT TOP(1) ED.EntryDate FROM MyEFContainer.EmployeeDepartments AS ED WHERE ED.EmplID=E.EmplID ORDER BY ED.EntryDate) FROM MyEFContainer.Employees AS E;

The scenario is as follows. An Employee belongs to min. 1 department at a given time. My query has to fetch all employees with the department they belong to for the longest time.

Let's assume I have 3 entities
Entity 1: (ID, SurName, FirstName)
Entity 2: (ID, DeptName)
Entity 3: (ID, EmplID, DeptID, EntryDate)

Cheers
bolek75

I have this hypothetical scenario. An employee can be related with one or more departments. But in case of a relation only one department is his main department.
Three entities are involved 'Employee', 'Deparment' and 'EmplDepartment'.
At this point I have to use EntitySQL instead of LINQ To Entities, because my customers have different EntitySQL-statements which can be imported in my app.
I have define the following statement, which was translated to TSQL but Oracle throws an error 'invalid identifier' relating to the EmployeeID in a sub-select.

My EntitySQL:

string sql = "SELECT VALUE E FROM EmplEntities.Employees AS E WHERE E.EmployeeID=1";
var query = MyDbContext.CreateQuery(sql, new ObjectParameter[0]).
Select( empl => new {
EmplID = empl.EmployeeID,
EmplName = empl.EmployeeName,
MainDept = empl.EmployeeDepartments.Where(ed1 => ed1.IsMain ==true).Select(ed2 => ed.DepName).FirstOrDefault()
});
this.dataGridView1.DataSource = query.ToList();


Regards
bolek75

AndreyR wrote:Open the model in VS 2010, select the correct .tt code generation template, right-click the model
and choose Create Model from Database.
You will obtan the DDL script.

Where do I get the correct generation template for the Oracle db from?