我正在尝试运行一个测试项目，但没有成功，因为npgsql连接失败。我已经重新安装了Npgsql、Npgsql.EntityFramework和EntityFramwork，但问题仍然存在。
结果消息：
TestUserControl.ControleBaseTest.TesteGetPermissoesUsuarioFixo测试方法引发异常：
System.NotSupportedException：无法确定类型为“Npgsql.NpgsqlFactory”的提供程序工厂的提供程序名称。请确保ADO.NET提供程序已安装或在应用程序配置中注册。
结果堆栈跟踪：
我有这个app.config文件:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
<entityFramework>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
<provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, Npgsql.EntityFramework"> </provider>
</providers>
<!--<defaultConnectionFactory type="Npgsql.NpgsqlFactory, Npgsql" />-->
<defaultConnectionFactory type="Npgsql.NpgsqlConnectionFactory, Npgsql" />
</entityFramework>
<system.data>
<DbProviderFactories>
<remove invariant="Npgsql" />
<add name="Npgsql Data Provider" invariant="Npgsql" support="FF" description=".Net Framework Data Provider for Postgresql" type="Npgsql.NpgsqlFactory, Npgsql" />
</DbProviderFactories>
</system.data>
</configuration>
And a DbConfig is...
public class CtxUser : DbContext
{
public CtxUser(string conexao) : base(conexao) { }
public CtxUser(DbConnection conexao) : base(conexao, true) { }
}
My Model...
[Serializable]
[Table("mytable", Schema = "public")]
public class Users
{
[Key, Column("userid")]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int UserId { get; set; }
[Column("login")]
public string Login { get; set; }
[Column("password")]
public string Password { get; set; }
}
我的逻辑类...
private DbConnection Conexao { get; set; }
public ControleBase(DbConnection connector)
{
if(conexao == null)
throw new ArgumentException("blah blah", "connector");
Conexao = conexao;
}
public Usuarios GetUser(int id)
{
if(id <= 0)
throw new ArgumentException("blah blah");
Users user;
using (var ctx = new CtxUser(Connection))
{
user = ctx.DbUser.Find(id);
}
return user;
}
我的测试方法...
[TestClass]
public class ControleBaseTest
{
private DbConnection Conexao
{
get
{
var cnxBuilder = new NpgsqlConnectionStringBuilder
{
Database = "mydatabase",
Host = "localhost",
Port = 5432,
UserName = "postgres",
Password = "postgres",
Enlist = true,
CommandTimeout = 30,
Timeout = 30,
Pooling = true,
MinPoolSize = 1,
MaxPoolSize = 20,
Compatible = new Version(2, 1),
PreloadReader = true
};
return new NpgsqlConnection(cnxBuilder);
}
}
[TestMethod]
public void TestGetUser()
{
IUserControl userControl = new ControleBase(Conexao);
var usuario = userControl.GetUsuario(9);
Assert.IsNotNull(usuario);
}
}
显然，这个测试仅用于测试与Npgsql和linq等的连接，以测试解决问题的方案。有人有主意吗？