C# (CSharp) Microsoft.Data.Sqlite SqliteCommand.ExecuteScalar Examples

Example #1

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlite("Filename=TestDatabase.db", options =>
            {
                options.MigrationsAssembly(Assembly.GetExecutingAssembly().FullName);
            });
            using (SqliteConnection con = new SqliteConnection("Data Source=TestDatabase.db;"))
                using (Microsoft.Data.Sqlite.SqliteCommand command = con.CreateCommand())
                {
                    con.Open();
                    command.CommandText = "SELECT name FROM sqlite_master WHERE name='Personas'";
                    var name = command.ExecuteScalar();

                    if (name != null && name.ToString() == "Personas")
                    {
                        return;
                    }
                    // acount table not exist, create table and insert
                    command.CommandText = "CREATE TABLE Personas (Nombre VARCHAR(50),Apellidos VARCHAR(50),DNI VARCHAR(10),Sexo VARCHAR(10), FechaNacimiento TEXT, Direccion VARCHAR(50),Pais VARCHAR(50), CodigoPostal int)";
                    command.ExecuteNonQuery();
                }
            base.OnConfiguring(optionsBuilder);
        }