EffiProz ADO.NET Provider
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;