Devart Forums

phowe

I gave up in frustration and completely uninstalled and re-installed DbMonitor. I had to do it twice since the uninstall does not clean out the related registry keys, which is where the settings that were hiding the event window are stored.

Once I uninstalled the software, deleted ALL the registry keys related to DbMonitor, and re-installed it, I got the event window back.

phowe

Sorry, I could not find a forum particular to DbMonitor, but I have a problem with it - I have lost the event window and cannot get it back!

The help says "This is the main dbMonitor window, which displays database event log. To display it choose Events from the View menu.

There's just one problem - there IS NO "Events" option in the view menu!

Can anyone help? All of the "request support" links on here flame out with the browser telling me they have a redirect loop!

Help!

Thanks,
Peter

phowe

I need to execute a stored procedure that does a whole bunch of work and returns several "out" parameters, but none of them are cursors or result sets (all scalar values.) My code looks like this:

Code: Select all

 
OracleCommand command = GetStoredProcCommandAndConnection("IP_APP_PKG.QUICKENTRY_ENTERPAYCHECK");

command.Parameters.Add("p_pclient_id", OracleDbType.Number, Convert.ToDecimal(pClientId),
                         ParameterDirection.Input);
command.Parameters.Add("p_userid", OracleDbType.Number, Convert.ToDecimal(userId),
                        ParameterDirection.Input);
command.Parameters.Add("p_employeename", OracleDbType.VarChar, employeename,
                       ParameterDirection.Input);
command.Parameters.Add("o_pagenmumber", OracleDbType.Number, dPageNumber, 
                       ParameterDirection.InputOutput);
command.Parameters.Add("o_no_of_pages", OracleDbType.Number, dNumberOfPages, 
                       ParameterDirection.Output);
command.Parameters.Add("o_ppagesize", OracleDbType.Number, dPageSize, 
                       ParameterDirection.Output);
command.Parameters.Add("o_totalemployees", OracleDbType.Number, dTotalEmployees,
                       ParameterDirection.Output);
command.Parameters.Add("o_sortorder", OracleDbType.VarChar, sortOrder, 
                       ParameterDirection.Input);
command.Parameters.Add("o_message", OracleDbType.VarChar, ParameterDirection.Output);

command.ExecuteScalar();  // TODO: Is this the right method to execute?

I don't know if ExecuteScalar will return all of the "out" parameters, of if I should use another method.

Anyone that knows the answer, please help.

Thanks,
Peter

phowe

We are past this issue, but ended up dropping out of the Entity Framework space in order to make the calls, using good old OracleConnection and OracleCommand objects. We realize the EF world is oblivious to whatever happens in the stored procs, and that we must deliberately attach or include any entities in a context if we want what happens in the stored proc to be reflected in the contexts.

Thanks,
Peter

phowe

Post has a broken link and I think that document has what we need! This link is broken:

http://www.devart.com/blogs/dotconnect/ ... plate.html.

Can someone point me to a working link? Thanks!

phowe

We are hip-deep in a project that accesses an existing database (albeit not that well designed) with C# and Entity Framework 5 using a code-first approach (was recommended since we did not want to "get married" to the poor database design.)

All has gone about as well as can be expected, until now when we need to call a stored procedure. The procedure has a number of IN parameters and a single OUT parameter (string result, either empty string or error message.)

Any help in the form of good documentation or sample code would be MOST helpful.

Versions: Oracle 11g server, dotConnect 7.9.333, VS2012 C#

Thanks,
Peter

phowe

I finally got things working with a lot of trial and error. I don't know if my solution is the official way to do things, so if you can point me to the "official" way to accomplish what I described, I can make sure I am doing things by the book.

Thanks.

phowe

Hi,

We have a couple of tables in our database that include BLOB columns, and are trying to map two different classes to the table, one with the BLOB and one without, so we don't have to retrieve all that extra data just to show a list of available rows. Once a row is selected, we want to use the other (derived) class to retrieve the same row WITH the BLOB column.

We are using EF 5 code first approach to an existing database, and the latest dotConnect. When we run the queries, we get this error:

"ORA-00904: \"Extent1\".\"Discriminator\": invalid identifier"

I understand how a discriminator column would work in EF, but the two classes are not SUPPOSED to be different, we just want the two versions for efficiency. Can someone tell me how I would set up the code model to accomplish this?

Thanks,
Peter

phowe

I found the problem, I wrote a Winforms app and declared the OracleMonitor object in the forms class - when I moved it to the static class in program.cs everything started working again. Sorry if I sent anyone on a wild goose chase.

Peter

phowe

I downloaded and installed dbMonitor, and it was working fine. I did not deliberately change any settings, but now the only thing that dbMonitor shows is a message "dotConnect for Oracle monitoring is started," everything else it used to show (SQL statements, etc.) is missing.

Any idea what might have been inadvertently changed to hide or eliminate all of the important stuff?

Thanks,
Peter

phowe

Still waiting to see if I have to spend the time on the sample project...

phowe

Here is what the Modules window shows:

Code: Select all

	
Devart.Data.dll	                C:\WINDOWS\assembly\GAC_MSIL\Devart.Data\5.0.792.0__09af7300eec23701\Devart.Data.dll     5.0.792.0	
	Devart.Data.Oracle.dll	C:\WINDOWS\assembly\GAC_MSIL\Devart.Data.Oracle\7.9.333.0__09af7300eec...   	      7.9.333.0	
	Devart.Data.Oracle.Entity.dll	C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Devart.Data.Oracle.Entity\v4....  	      7.9.333.0

The small test project is something I will have to work on if this does not tell you anything.

Peter

phowe

I downloaded and re-installed as the revision history mentioned a bug fix related to this Oracle exception, but I am still getting it with the new version. I am trying to code for eager loading in EF 5:

Code: Select all

    var q = db.Users
              .Include("Profiles")
              .Include("ProfileDivs")
              .Include("ProfileDepts")
              .Where(usr => (usr.UserName == uName) && (usr.PclientId == pClient));

but when I have more than one .Include() call in the query, I get the exception.

Can anyone help?

Thanks,
Peter

phowe

Hi,

Sorry again for the lousy attitude yesterday.

The biggest problem I have right now is trying to get the EF Power Tools to work. My first "run" with Oracle's data provider did not go well. We have 379 tables in our application's schema but the Power Tools created close to 3,000 entity classes, so they obviously grabbed EVERYTHING from the server including all the Oracle system tables, etc. The connection we used was specific to the application but the Power Tools seemed to have a mind of their own once connected to the database.

The second attempt did not go much better. That one was with dotConnect, which sat for at least a day, saying it was "generating entity classes" but I ended up having to kill it off.

We really would like to be able to specify a subset (i.e., bounded context) for the Power Tools to do their reverse-engineer magic on, but cannot find any way to do that. Once the program gets the database connection, it just grinds until it's finished or killed off.

Thanks,
Peter

phowe

My apologies for the sarcastic remark, I think I was under the impression that there was a development community behind the forum in addition to your company.

I finally got some output from my test application, but am dismayed that I needed to write the mapping class myself, I thought the EF Power Tools were going to do that for me, but they do not seem to work as advertised when not connected to SQL Server (Microsoft's issue, not yours...) Admittedly, our database is quite large, and the program sat for over a day just generating the entity classes. A great feature would be the ability to specify a subset (bounded context) of the database at a time rather than trying to bite it all off at once. Toad's schema browser tells me there are 379 tables...

Devart Forums

Search found 20 matches

Re: Using dotConnect for Oracle, having trouble with DbMonitor

Using dotConnect for Oracle, having trouble with DbMonitor

Not sure which OracleCommand method to use

Re: NEED SOME HELP: Need to call stored procedure using entity Framework 5 code first

Re: Calling user Defined oracle functions using Code First

NEED SOME HELP: Need to call stored procedure using entity Framework 5 code first

Re: Problem with inheritance, EF 5, and dotConnect for Oracle

Problem with inheritance, EF 5, and dotConnect for Oracle

Re: dbMonitor suddenly stopped working

dbMonitor suddenly stopped working

Re: Still getting ""ORA-12704: character set mismatch" with 7.9.333

Re: Still getting ""ORA-12704: character set mismatch" with 7.9.333

Still getting ""ORA-12704: character set mismatch" with 7.9.333

Re: Trouble using Entity Framework 5 Power Tools with Oracle 11g and dotConnect

Re: Trouble using Entity Framework 5 Power Tools with Oracle 11g and dotConnect