Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

options.UseOracle() not available in EF Core

Using EF Core with Oracle.ManagedDataAccess.Core(2.18.3)

Not able to invoke the "options.UseOracle" method when trying to add DB context.

Compiler throws the error: 'DbContextOptionsBuilder' does not contain a definition for 'UseOracle' and no accessible extension method 'UseOracle' accepting a first argument of type 'DbContextOptionsBuilder' could be found (are you missing a using directive or an assembly reference?)

Please see code below, its the last line that does not compile, My nuget reference includes Oracle.ManagedDataAccess.Core(2.18.3)

using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.HttpsPolicy;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using EfGetStarted.AspNetCore.NewDb.Models;
using Microsoft.EntityFrameworkCore;
using Oracle.ManagedDataAccess.Client;

namespace EfGetStarted.AspNetCore.NewDb
{
    public class Startup
    {
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            services.Configure<CookiePolicyOptions>(options =>
            {
                // This lambda determines whether user consent for non-essential cookies is needed for a given request.
                options.CheckConsentNeeded = context => true;
                options.MinimumSameSitePolicy = SameSiteMode.None;
            });


            services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);



            var ora_conn = "User Id=xyz;Password=pwd;Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = ORA01)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = ora1)))";
            services.AddDbContext<BloggingContext>(options => options.UseOracle(ora_conn));


        }
like image 846
5 revs, 2 users 83%user1106925 Avatar asked Oct 24 '18 15:10

5 revs, 2 users 83%user1106925


1 Answers

Try

PM> Install-Package Oracle.EntityFrameworkCore -Version 2.18.0-beta3
like image 111
Thorsten Avatar answered Sep 24 '22 06:09

Thorsten