creation of database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Using C# beta 2004 Express, I just downloaded sql beta 2005 express. But now
some questions:

1. Some turorials available somewhere to:
- create a database in code
- change structure of it
- loading / saving / indexing of data

2. same with local tables (mdb)

3. Are there not other (free) tables components available for .NET, like
memorytables, or ordinary .dbf tables where I have control myself over the
file saving ?
 
For creating the Tables and Such you will need to look at TSQL. Or look at
using the SQL-DMO Classes.

I know that there is talk about a managed version of DMO but as of yet I
have not seen any links or articles on it. You might be able to ask on the
channel9 forums for answers.
 
Hi Glenn,
For creating the Tables and Such you will need to look at TSQL. Or look at
using the SQL-DMO Classes.
Click to expand...

Not simple :(
I'm coming from Delphi. If I wants to create a project with a local database
in any format it take me 30 seconds mouseclicks and the project is up and
running, creating his own files at customar.

Maybe I'm missing something. Can you recommand me some example ? Unless I'm
totally wrong it seems I go back in time 20 years using dbf in .net coding
everyting.... (I hope I'm wrong :)
 
You have to remember that dbf are flat file databases and can be very
portable. SQL Server as in SQL Server 2005 Express is a full blown Database
Server. To create a database with this you have to first fire up the
management tools and create the database there, then you have to allocate
the permissions to that database. Once this is done you can then go to your
Visual Studio server manager and connect to your database, From there you
create the tables, stored procedures, and such.

To create stand alone database files (*.mdb) these are just access database
files and you have to ways to create them. the first is to use access to
create the DB, or use ADOX (Witch is unmanaged). To find out about ADOX you
will most likly have to go the the dotnet database groups to get some code.
 
Back
Top