Question Getting away from ADOX

[JuggaloBrotha]

In an attempt to get away from ADOX I've managed to completely build an access database progromatically using SQL statements directly on the DB and get rid of the use of ADOX. The last step I have is physically creating a completely empty access database file, is this possible to do in pure .net code? I'm not finding any articles on this yet, I'm hoping someone knows of one that shows how to do this.

 

[JohnH]

Why not put a empty db file you prepared before in resources and use this each time you need to start a new?

 

[JuggaloBrotha]

That's the conclusion I reached after some more research, too.

 

[cjard]

Given that a brand new, blank access db is 64kb in size, I'd also recommend the same route (rather than writing the bytes yourself.. Jet DDL probably wouldnt work as it's a bit chicken and egg; you'd need an mdb to conenct to to exec the sql needed to create an mdb)