Developers community number 1 connection string reference

Connection strings for EffiProz

.NET libraries for EffiProz

Developers Community

Find solutions and post questions regarding connection string related issues.

Forum 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;
 
 
Copyright © 2013 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.