Check if Local Database is Already Created C#

Question

Almost done with my C# Password Generator/Store. All the passwords are stored in a local encypted database that is hashed and also has a DB password. I am using sql express/compact(whatever it is called) to create the database manually. I was wondering if there was a way to check if a database was already created and has the right tables included. Also is there a way if the DB is not created to tell it to create an encrypted DB? Also have it create a folder in a speceific location too if that is not there also create it and store the DB inside.

Thanks

does the database exists on a sql server or a physical file? you can just check if the connection exists or if the file exists for that. — melaos
– melaos, Commented May 26, 2011 at 2:00

Bala R · Accepted Answer · 2011-05-26 02:02:41Z

2

You can run a query like this

  IF NOT EXISTS
   (  SELECT [name] 
      FROM sys.tables
      WHERE [name] = 'TableName`
   )
   CREATE TABLE TableName (Col1 int, Col2 int ... )

for each table in the right order.

answered May 26, 2011 at 2:02

Bala R

109k23 gold badges203 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pankaj · Accepted Answer · 2011-05-27 06:03:15Z

1

I was wondering if there was a way to check if a database was already created

Select * from sys.databases Where name = 'YourDatabaseName'

Alternative

Select * from sys.objects Where name = 'YourDatabaseName'

has the right tables included

Select * from sys.tables where name = 'YourTableName'

Alternative

Select * from sys.objects where name = 'YourTableName'

Also is there a way if the DB is not created to tell it to create an encrypted DB?

If Not Exists(Select * from sys.databases Where name = 'YourDatabaseName')
Begin
    --Create your database
End

Folder creation is the process during the database creation

edited May 27, 2011 at 6:03

answered May 27, 2011 at 5:58

Pankaj

10.2k40 gold badges152 silver badges298 bronze badges

Collectives™ on Stack Overflow

Check if Local Database is Already Created C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related