Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > ORM Profiler> Oracle string parameters showing as object
 

Pages: 1
ORM Profiler
Oracle string parameters showing as object
Page:1/1 

  Print all messages in this thread  
Poster Message
jovball
User



Location:
USA
Joined on:
23-Jan-2005 19:53:47
Posted:
393 posts
# Posted on: 11-Jun-2019 05:47:20.  
I'm trying to use ORM Profiler with EF6 and Oracle. The string parameters are all coming back as type of object. As a result, the parameter values are getting inlined.

In the sample below, the
Code:
:p__linq__0
parameter value is 'ABC01' and the p__linq__1 value is a date as shown. All other parameters seem to be correct except for any of the various character data types.


Code:

                WHERE ((("Extent1"."IMPD_BMP_ID_FROM_USER" = /* Type: OBJECT. */ /* :p__linq__0 */)
                         OR (("Extent1"."IMPD_BMP_ID_FROM_USER" IS NULL)
                             AND (/* Type: OBJECT. */ /* :p__linq__0 */ IS NULL)))
                        AND ("Extent1"."IMPD_INSTALLED_DATE" = '20190202' /* :p__linq__1 */)




I'm not sure if this is an issue with ORM Profiler, EF6, Oracle or a combination. I was trying to create a pure ADO.NET example but I can't figure out how to initialize the connection for that.

This query executes but doesn't get intercepted by ORM Profiler.

Code:

            var table = new DataTable();

            using (var cnn = new OracleConnection(_login))
            {
                using (var cmd = new OracleCommand(query, cnn))
                {
                    cmd.CommandType = System.Data.CommandType.Text;
                    var creationDate = new DateTime(2019, 1, 1);
                    cmd.Parameters.Add("CREATION_DATE", OracleDbType.Date, creationDate, ParameterDirection.Input);

                    using (var dataAdapter = new OracleDataAdapter(cmd))
                    {
                        dataAdapter.Fill(table);
                        Console.WriteLine($"Rows: {table.Rows.Count}");
                    }
                }
            }



Joel Reinford
LLBLGenPro Version: 5.5.3
Templates: Adapter
Framework: .Net 4.6
Database: SQL Server 2012/2014, DB2 v10
 
Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14498 posts
# Posted on: 11-Jun-2019 18:29:57.  
Which ORM Profiler version are you using?

How to hook up the ORM Profiler Interceptor... check this document



  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.