Koneksi (Connection strings for 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

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

Share : Koneksi (Connection strings for EffiProz)

Related Posts

Koneksi (Connection strings for EffiProz)

4/ 5

Oleh Unknown