c# – 在实体框架(Oracle或SQL Server)中检测dbms类型

如果您创建一个类库@R_301_2495@案并安装NUnit和EntityFramework nuget包,则可以运行以下命令.

using Sy@L_874_11@.Data.Common;
using Sy@L_874_11@.Data.Entity;
using Sy@L_874_11@.Diagnostics;
using NUnit.Framework;

namespace efProviderChooser
{
    public class myThing
    {
        public int id { get; set; }
    }

    public class MyContext : DbContext
    {
        public DbSet<myThing> Things { get; set; }
    }

    public class Test
    {
        [Test]
        public void CanGetProvider()
        {
            var context = new MyContext();          
            var dbProviderFactory = DbProviderFactories
                                     .GetFactory(
                                       context.Database.Connection);

            Debug.WriteLine(dbProviderFactory.GetType());
            //gives one of 
            //Sy@L_874_11@.Data.EntityClient.EntityProviderFactory
            //Sy@L_874_11@.Data.odbc.odbcFactory
            //Sy@L_874_11@.Data.oleDb.oleDbFactory
            //Sy@L_874_11@.Data.OracleClient.OracleClientFactory
            //Sy@L_874_11@.Data.sqlClient.sqlClientFactory
            //this list Could change!

            // here I get sqlClient
            Assert.That(dbProviderFactory.GetType().ToString().Contains("sqlClient"));
        }
    }
}