Devart Forums

hom_rcp

I had a bug in an older version of Devart Dot Connect and you gave me an advice which was to make an upgrade to a newer version. After the upgrade, now I'm working on the version 7.0.25.0 and a new bug appeared.
In entity model / Oracle. The data model is not creating a custom class automatically for procedures after dragging them to the diagram as it used to do. Any hlep

hom_rcp

In Visual Studio 2008, When I update model from database and add a procedure from a package, all the procedures will be added to the entity modal which is not expected. Please tell me if there is any workaround.

hom_rcp

I have Entity Model version: 7.0.25.0. I'm facing a problem when adding a procedure that returns sys_refcursor, the Entity Model doesn't always generate a complex type.

This's the deceleration of my procedure:

Code: Select all

procedure get_items (p_user_id in number, rec_out out sys_refcursor) ;

Any help!

hom_rcp

Thanks for the reply but my application is WPF xBap application so, I cannot use SQLDataSource.

hom_rcp

I'm using Oracle - Devart Entity Model version 6.10.103.0. Working with an Oracle engine version 10.2.0.4.

The following code gives a strange exception:

Code: Select all

using (var entitie = new Gw7Model.Gw7Entities())
{
    string username = "mohd";
    var user = entitie.Employees.FirstOrDefault(p => p.Name.ToLower() == username);
}

Exception:
An error occurred while executing the command definition. See the inner exception for details.
Inner Exception:
{"ORA-00904: \"TOLOWER\": invalid identifier"}

Any help?

hom_rcp

I'm using Devart - Dot Connect for Oracle. I'd like to implement lazy load feature in a Data Grid View. The records are retrieved from an Oracle procedure - refCursor, which returns a DataReader.

I wonder if you could help me with the standard way to implement this feature in Devart tools.

Regards,
Homam.

hom_rcp

Naming rules - FirstLetterUpercase doesn't work correctly in Entity Model in the version: 6.30.160.0 After it was working well before the upgrade.

All the generated classes and their members are generated with full uppercase names.

Any idea?

hom_rcp

Hi, I have an already LINQ Connect modal (Oracle) from previous version (5.*), and now I updated the library to the latest version.

When I create a new LINQ connect item, everything is OK. but when I try to add a new Function with a Complex Type to an already LINQ Connect modal, it doesn't generate code for this function and add it only in the dbml file!

I wonder if you could find this problem and tell me what should I do to solve it.

Regards,

Homam.

hom_rcp

I edited the question, thanks.

hom_rcp

Hi,
I have a very big problem for me appears with a few steps

* Select on the following view in Oracle

Code: Select all

create or replace view Test_View as
select "ID","USR"
from Test_Table@link_DB;

The link is to Oracle database (eveything is Oracle)
* Using Entity MODAL (Oracle)

That's all,
When I open the page the following exception will be shown (from the first time or after a postBack)

Code: Select all

distributed transaction already begun  "ORA 02046 "

Stack trace:

Code: Select all

   at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at System.Data.Objects.ELinq.ObjectQueryProvider.b__2[TResult](IEnumerable`1 sequence)
   at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
   at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
   at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
   at WebApplication3._Default.Button1_Click1(Object sender, EventArgs e) in D:\FutureGate\Workflow Solution\WebApplication3\WebApplication3\Default.aspx.cs:line 29
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Any help!

Devart Forums

Search found 10 matches

A New bug in entity model/Oracle appeared after I made an upgrade

In VS 2008, adding a procedure to Entity Model causes adding all procedures in the package.

The Entity Model doesn't always generate a complex type for procedures

Re: How to implement lazy load feature with dot connect?

Exception: {"ORA-00904: \"TOLOWER\": invalid identifier"}

How to implement lazy load feature with dot connect?

Naming rules - FirstLetterUpercase doesn't work correctly

LINQ Connect doesn't generate code for Function

distributed transaction already begun ORA 02046 - using Link