Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

How is the actual database created?

I have this code (below)... my question is: if the database file does NOT exist, which one of these statements creates it?  (not the tables, but the actual file 'r64.sdb')  Is it the SQLiteConnection statement?
dbPath = Environment.GetFolderPath (Environment.SpecialFolder.MyDocuments);
	        db = Path.Combine (dbPath, "r64.sdb");
	        
			bool exists = File.Exists (db);  //  check to make sure it exists
			
			conn = new SqliteConnection("Data Source=" + db);

Open in new window

0
rmmarsh
Asked:
rmmarsh
1 Solution
 
CHutchinsCommented:
It has to be making a call to another script to create the file from what I can tell form the last line.
the last line looks like a Connection creation and data source - + db is making a call to a variable
0
 
rmmarshAuthor Commented:
By trial and error I figured it out... conn.Open creates the database, based on the contents of db.  Thanks for your help... I appreciate it.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now