My code reads via one connection and writes via another. I dont want to accidentally write with the read connection. How can i make the connection readonly? I am using SQLite ATM and will convert sections of code to tsql when the prototype is over.
+1
A:
You can add Read Only=True to the read-only connection.
Data Source=filename;Read Only=True;
Sam
2010-01-05 03:41:40