Oracle DB record accessible once only using NetFrameworkCore for Oracle

asp.net-identity entity-framework-core oracle usermanager

Question

I have a simple web solution (incomplete) using NetFrameworkCore for Oracle.

See HomeController.CS & AspNetUser.CS -->

The issue is I have an AspNetUser record that was created in DB via Microsoft.AspNetCore.Identity.UserManager. This record is accessible by finding by ID, managed to retrieve record.

However, on stopping the solution and doing a re-run (without creating new AspNetUser), I cannot retrieve the record via the ID. Instead, a 500 error with invalid cast exception on Oracle.ManagedDataAccess.Client.OracleDataReader.GetDateTimeOffset() is thrown. The issue may not be table column related as re-creating the table allows the record to be accessible again albeit once as well.

What could be the issue then? I apologize as I am new to Oracle and net core web. Below are the links to the error and web solution.

Error 500: https://1drv.ms/u/s!AjZf_PiMM9Arg6QLX9dfqkqu_Piepw

Solution: https://1drv.ms/u/s!AjZf_PiMM9Arg6QKrT3AuP3QTJaQYQ?e=5lLU97

1
0
3/20/2020 9:10:14 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I have managed to resolve the issue of InvalidCastException. The current Oracle table was created manually without using EntityFrameworkCore tool.

After dropping the table and re-creating using the commands "add-migration " & "update-database", the table is accessible on subsequent reads.

The issue was with the column, LockoutEnd.

Changed from

"LockoutEnd" TIMESTAMP(7) NULL,

to

"LockoutEnd" TIMESTAMP (3) WITH TIME ZONE,
0
3/23/2020 2:59:26 AM

Related Questions

Facing Issue while connecting Entity framework with Oracle 11g using MVC 4

I am trying to connect to an Oracle Database through Entity Framework....I have created two projects: ...A data access project...MVC4 Web project...It is working fine if I try to connect using a console application and App.config, but facing issue when trying to connect using web application and web.config....I have added packages using Nuget in da...
asp.net-mvc-4 entity-framework entity-framework-6 oracle oracle11g
asked by AMDI

Calling an Oracle stored procedure with Entity Framework code-first and DevArt Drivers

I have an Oracle stored procedure that I am trying to call with EF code-first (...DbContext...) using the DevArt Oracle drivers (latest version). I don't know why this has to be so hard (I wish I was using SQL Server), but I cannot make it work. I am doing what is described in ...this post...I followed the answer that was supplied by the DevArt tea...
devart entity-framework entity-framework-6 oracle stored-procedures
asked by jeff.eynon

Calling Oracle stored procedure using Entity Framework with output parameter?

I have a simple Oracle stored procedure that gets three parameters passed in, and has one output parameter:...CREATE OR REPLACE PROCEDURE RA.RA_REGISTERASSET ( INPROJECTNAME IN VARCHAR2 ,INCOUNTRYCODE IN VARCHAR2 ,INLOCATION IN VARCHAR2 ,OUTASSETREGISTERED OUT VARCHAR2 ) AS BEGIN SELECT INPROJECTNAME || ', ' || INLOCATION |...
c# entity-framework entity-framework-6 oracle oracle-manageddataaccess
asked by Donny

How can I prepare WITH CLAUSE using Oracle .Net entity framework queries

I'm trying to achieve the below query with entity query. How WITH Clause is implemented?...WITH EVENTS AS (select * from EVENTS_ATCS WHERE ROWNUM <10) select * from EVENTS A LEFT JOIN ATCS_EVENT_MASTER B ON (A.TYPEID = B.EventId) AND ((A.BYTE1 >= B.GE_BYTE1 AND A.BYTE1 <= B.LE_BYTE1) OR (A.BYTE1 = B.E_BYTE1)) AND ((A.BYTE2 >= B.GE_BYTE2 AND A.BYTE2...
common-table-expression entity-framework entity-framework-6 oracle
asked by Rammohan

Cannot migrate Oracle database (initially create tables) because of insufficient privileges?

I'm new to Oracle DB and really not sure what kind of privileges I should setup for an user so that he can execute basic commands like create,drop,delete, insert, update, select tables....And actually I've setup all those privileges for my user account. But when running migrate, it failed with the following error printed in console window:...2019-0...
c# database-migration ef-migrations entity-framework-core oracle
asked by Hopeless

ASP .net core time out error using Oracle

I'm new to ASP .Net Core and am working my way through a demo project to learn the tech stack. ...My project is using .net core 2.2 and Oracle.ManagedDataAccess.Core and Oracle.EntityFramework.Core. ...I created a model and then went and scaffolded my view and controller through VS 2019. I've set up ...ConfigureService(...)... to use Oracle. I adde...
asp.net asp.net-core entity-framework-core oracle
asked by Scott Lee

How to fix 'Method 'get_Info' in type 'Oracle.EntityFrameworkCore does not have an implementation.'

I'm trying to connect to Oracle DB via EW. On method ...OnConfiguring... is error:...System.TypeLoadException: 'Method 'get_Info' in type 'Oracle.EntityFrameworkCore.Infrastructure.Internal.OracleOptionsExtension' from assembly 'Oracle.EntityFrameworkCore, Version=2.0.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342' does not have an implemen...
.net asp.net-core entity-framework-core oracle
asked by whoami

Core scaffolding Oracle DB will give multiple ID(primary key's) as result

When I scaffold this Oracle DB (database -first) and it generates me all models, contexts, FK relations ect. But it gives me an error in the context when I start Querying. (simple things as select * from (any Table)) ...The follow error comes up....System.InvalidOperationException...HResult=0x80131509...Message=The properties 'Address.AddressId', '...
asp.net-core-scaffolding entity-framework-core oracle
asked by Dinand

Oracle DB with .NET Core Using ODP.Net Provider - How to set the Schema

Having trouble getting things to work with an Oracle Database in .NET Core. ...I am able to create a connection to the database.... My problem seems to be when I try to execute a statement. I first was using EF Core with a DbContext to retrieve a single entity from the DB, in which case I get the exception on the following line:...var item = _con...
.net-core entity-framework-core odp.net oracle
asked by BioData41

Unable to hit oracle stored proc using .Net EF(2.2) Core repository pattern

ORA-00900: invalid SQL statement...This is the error i get when i am trying to hit a stored procedure(in Oracle) from my API....I am using Repository pattern with Entity framework.(EF Core 2.2)...This is my call,...return FetchWithStoredProcedure("PROC_GETMYPROC", new OracleParameter("PARAM1", OracleDbType.Int32, ParameterDirection.Input) { Va...
.net entity-framework-core oracle oracle-sqldeveloper repository-pattern
asked by Shekar.gvr

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow