Connection strings for EffiProz

.NET libraries for EffiProz

EffiProz ADO.NET Provider

Type .NET Framework Class Library
Usage System.Data.EffiProz.EfzConnection
Manufacturer EffiProz

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