Df.EntityFrameworkCore.Oracle 1.4.0

.NET Standard 2.0
Install-Package Df.EntityFrameworkCore.Oracle -Version 1.4.0
dotnet add package Df.EntityFrameworkCore.Oracle --version 1.4.0
<PackageReference Include="Df.EntityFrameworkCore.Oracle" Version="1.4.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Df.EntityFrameworkCore.Oracle --version 1.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Df.EntityFrameworkCore.Oracle, 1.4.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Df.EntityFrameworkCore.Oracle as a Cake Addin
#addin nuget:?package=Df.EntityFrameworkCore.Oracle&version=1.4.0

// Install Df.EntityFrameworkCore.Oracle as a Cake Tool
#tool nuget:?package=Df.EntityFrameworkCore.Oracle&version=1.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Df.EntityFrameworkCore.Oracle

Entity, Framework, EF, Core, Data, O/RM, entity-framework-core,Oracle

Df.EntityFrameworkCore.Oracle is an Entity Framework Core provider built on top of Oracle.ManagedDataAccess.Core. It allows us to use the Entity Framework Core ORM with Oracle. Async functions in this library properly implement Async I/O at the lowest level.

Getting Started

Here is a console application sample for accessing a Oracle database using Entity Framework:

② Put Df.EntityFrameworkCore.Oracle into your project's .csproj file

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>netcoreapp2.0</TargetFramework>
  </PropertyGroup>

  <ItemGroup>
	<PackageReference Include="Df.EntityFrameworkCore.Oracle" Version="1.0.0" />
  </ItemGroup>
  
</Project>

③ Implement some models, DbContext in Program.cs. Then overriding the OnConfiguring of DbContext to use Oracle database. Besides. Finally to invoking Oracle with EF Core in your Main() method.

using System;
using System.Collections.Generic;
using System.Linq;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;

namespace OracleTest
{
    public class User
    {
        public int UserId { get; set; }

        [MaxLength(64)]
        public string Name { get; set; }
    }

    public class Blog
    {
        public Guid Id { get; set; }

        [MaxLength(32)]
        public string Title { get; set; }

        [ForeignKey("User")]
        public int UserId { get; set; }

        public virtual User User { get; set; }

        public string Content { get; set; }

    }

    public class MyContext : DbContext
    {
        public DbSet<Blog> Blogs { get; set; }

        public DbSet<User> Users { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
            => optionsBuilder
                .UseOracle(@"DATA SOURCE=127.0.0.1:1521/tjims;PASSWORD=test;PERSIST SECURITY INFO=True;USER ID=test;");
    }

    public class Program
    {
        public static void Main()
        {
            using (var context = new MyContext())
            {
                // Create database
                context.Database.EnsureCreated();

                // Init sample data
                var user = new User { Name = "Yuuko" };
                context.Add(user);
                var blog1 = new Blog {
                    Title = "Title #1",
                    UserId = user.UserId,
                    Tags = new List<string>() { "ASP.NET Core", "Oracle", "Df" }
                };
                context.Add(blog1);
                var blog2 = new Blog
                {
                    Title = "Title #2",
                    UserId = user.UserId,
                    Tags = new List<string>() { "ASP.NET Core", "Oracle" }
                };
                context.Add(blog2);
                context.SaveChanges();

                context.SaveChanges();

                context.SaveChanges();

                // Output data
                var ret = context.Blogs
                    .Where(x => x.Tags.Object.Contains("Df"))
                    .ToList();
                foreach (var x in ret)
                {
                    Console.WriteLine($"{ x.Id } { x.Title }");                
                    Console.WriteLine();
                }
            }
            Console.Read();
        }
    }
}

Contribute

One of the easiest ways to contribute is to participate in discussions and discuss issues. You can also contribute by submitting pull requests with code changes.

License

MIT

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.4.0 452 9/29/2019
1.3.0 299 9/25/2019
1.2.0 308 9/25/2019
1.1.0 330 9/25/2019

2019-09-29
- Better fix for exceptions with sorting
- Fix ORA-00936: missing expression

2019-09-25
- Forked project & made various fixes
- Fix paging issues
- Fix ORA-00972: identifier is too long
- Fix ORA-00918: column ambiguously defined
- Various fixes for code first migrations creation