Connection strings for EffiProz

.NET libraries for EffiProz

EffiProz ADO.NET Provider

Type .NET Framework Class Library
 Usage System.Data.EffiProz.EfzConnection
 Manufacturer EffiProz
More info and class library downloads

Set example values

In-Memory Database

    
Connection Type=Memory;Initial Catalog=myDataBase;User=myUsername;Password=myPassword;
 
 

File Database

    
Connection Type=File;Initial Catalog=C:\myFolder\MyDB;User=myUsername;
Password=myPassword;
 
 

Embedded Resource Database

    
Connection Type=Resource;Initial Catalog=EffiProz.Test.Resources.TestDB;User=myUsername;
Password=myPassword;
 
 

With Auto Commit

    
Connection Type=Memory;Initial Catalog=myDataBase;Auto Commit=True;User=myUsername;
Password=myPassword;
 
 

With Auto Shutdown

    
Connection Type=File;Initial Catalog=C:\myFolder\MyDB;Autoshutdown=True;User=myUsername;
Password=myPassword;
 
 

Read Only Connection

    
Connection Type=Memory;Initial Catalog=myDataBase;Readonly=True;User=myUsername;
Password=myPassword;
 
 

With Transaction Isolation Level

    
Connection Type=Memory;Initial Catalog=myDataBase;Auto Commit=False;
Isolation level=serializable;User=myUsername;Password=myPassword;
 
 

With Pooling

    
Connection Type=Memory;Initial Catalog=myDataBase;Pooling=True;User=myUsername;
Password=myPassword;
 
 

Enlist in distributed transaction

    
Connection Type=File;Initial Catalog=C:\myFolder\MyDB;Enlist=True;User=myUsername;
Password=myPassword;
 
 

With Encryption

    
Connection Type=File;Initial Catalog=C:\myFolder\MyDB;Cipher name=Rijndael;
Cipher key=oOEWVlhLZlOigUFYZVtlQ4SPjZkzg5KEGRXBPLUa6Eo=;Cipher iv=wVavg5JdMB6jjtpWYyLa4A==;
User=myUsername;Password=myPassword;
 
 

File in My Documents folder

Connect to a File database in "My Documents" folder from a Silverlight OOB application

    
Connection Type=File;Initial Catalog=|My Documents|\MyDB;User=myUsername;
Password=myPassword;
 
 

Popular