dotnet-db-samples

dotnet-db-samples copied to clipboard

Oracle.EntityFrameworkCore does not delete sequences in compatibility mode

1

When `UseOracleSQLCompatibility("11")` option is set, identity columns are created with sequence+trigger. But the sequence is never deleted when unapplying an migration - this causes some manual interaction, where one needs...

jhouben98

ORA-02292: integrity constraint violated - child record found

1

## Bug report In the following scenario: - Vehicle, class which has a property, Driver. - Car, child of Vehicle. - Driver, which has a list of Vehicles. - Driver...

javiercoll

Connection failed on 3.21.4 but working on 2.19.91

7

Hi, We are moving from ```Oracle.ManagedDataAccess.Core 2.19.91``` to ```Oracle.ManagedDataAccess.Core 3.21.4``` and after update we are not able to connect to the database. Database version is ```12.1.0.2.0 - 64bit Production```. We...

wahmedswl

Performance counters based on Event Source in .NET Core

13

Are there plans about implementation performance counters based on Event Source? SqlClient Data Provider for SQL Server already have it: https://github.com/dotnet/SqlClient/pull/719

rfatkullin

Oracle.EntityFrameworkCore CLR Type mapping issue with Timestamp With Local Time Zone

3

Using the current latest Oracle.EntityFrameworkCore (5.21.3), I think there's a bug using TIMESTAMP WITH LOCAL TIME ZONE columns. Oracle.ManagedDataAccess expects to use CLR type DateTime, but Oracle.EntityFrameworkCore requires DateTimeOffset. I...

fultke01

Udt using EntityFramework core

6

Now that #56 is done, can we get UDT support in Oracle.EntityFrameworkCore too? Would be nice to just entity.Property(e => e.ComplexValue).HasColumnType("ComplexType").HasColumnName("ComplexValue") and map it to a C# class.

Regenhardt

Oracle.EntityFrameworkCore not supported converters for System.Guid type

3

I use strongly-typed entity identifiers of type System.Guid (for example): ``` public class OrderIdValueConverter : ValueConverter { public OrderIdValueConverter(ConverterMappingHints mappingHints = null) : base( id => id.Value, value => new...

elmanav

is it possible to specify Tablespace on Entity Framework core OnModelCreating

7

For tables and indexes? Thanks

omora

Oracle.EntityFrameworkCore update statement and checking rows affected

4

When creating an update the following SQL is generated: ```sql DECLARE v_RowCount INTEGER; BEGIN UPDATE "MyTable" SET "Processed" = :p0, "Updated" = :p1 WHERE "Id" = :p2 AND "Type" =...

SierraNL

Memory leak on Oracle 11.2 with LONG datatype in .net core 3.1 on Linux

5

Hi, I got the following config: * Oracle Database 11g Release 11.2.0.4.0 - 64bit Production on Linux * Net core 3.1 and Oracle.ManagedDataAccess.Core 3.21.1 - **Linux** * Table with LONG...

skaeff