Single file database

Hi,

I'm new on .NET platform. Does the .NET 2.0 supports creation and use of a SQL driven standalone single file database or should I install a third party database like SQLite

Thanks



Answer this question

Single file database

  • awake

    .NET itself does not contain any databases, but it contains the support. You can use Access for example and withing .NET you can connect to an Access Database with OleDb.

    No extra components needed, only Access.


  • shainer0531

    This is correct, on the client machine you don't need access installed.


  • Mehmet Can

    You don't need Access installed on the target machine.  Only on the machine on which you actually develop the database.

  • betrl8thanever

    Another possible option is to install the free SQL Server Express 2005, which is an optional install with C# Express.  This would require that the clients machince also has SQL Server Express installed, but using the deployment mechanism in C# Express, this can be configured relatively easily. 

    Thanks,
    Luke Hoban
    Visual C# IDE Program Manager

  • tom ferguson

    Thanks!
  • Single file database