Re: [Firebird-net-provider] EF connectionstring with trusted authentication

[Parzival <par...@gm...>]

Hello all,

 

my mistake: I don´t have to send username nor password at all :-(

 

Niko

 

Von: Parzival [mailto:par...@gm...] 
Gesendet: Freitag, 20. Februar 2015 18:17
An: 'For users and developers of the Firebird .NET providers'
Betreff: [Firebird-net-provider] EF connectionstring with trusted
authentication

 

Hello all,

 

I am using firebird .net provider and EF to connect to the firebird DB. The
connection with the .net provider works fine with trusted authentication.
The Windows Username of the current user is sent without a password to the
database and it connects as expected.

 

 

When I try to do the same with EF I fail by removing the password.

 

   cU := System.Security.Principal.WindowsIdentity.GetCurrent()

   _currentUser := cU:Name

// this works

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" +
_server + ";initial catalog=" + _database + ";user id=" + _currentUser +
";role=BAURADAR_ADMIN;"  

 

// this does not work

_efsb:ProviderConnectionString := "character set=ISO8859_1;data source=" +
_server + ";initial catalog=" + _database + ";user id=" + _currentUser +
";password=mypassword;role=BAURADAR_ADMIN;"  

 

I have removed the connectionstring section from the app.config in order to
read the essential parameters (server, database) from a config file. 

 

Is there any special setting I have to add that trusted authentication works
with EF as well as it does with the .net provider?

 

Thanks

 

Niko