Database and .net

[Deleted member 61728]

Hi am wondering is it possible to make a simple console program using .net use a embedded or external database of some kind to hold or pull stuff from it .Is it possible to combine a very small database with the program .exe ?
If so what .net namespace or library has this ability ?

 

[~J~]

It's entirely possible yeah, but are you saying you're going to run a console specific application or a little program that runs once and pushes/pulls from a database?

 

[Deleted member 61728]

Yeah just a console app but using .net i want the database to hold a few strings so i can performs tests on them just wondered how.

 

[Engram]

SQLite is the classic "small database".

Check this out: http://sqlite.phxsoftware.com/

PS. If you just need to store a few strings couldn't you put them in an array or a resource file?

 

[Pho]

If you're using .NET can't you just create a local database? It's somewhere in the add file to project menu.

 

[Engram]

If you're using .NET can't you just create a local database? It's somewhere in the add file to project menu.

That's a SQL Server database though, isn't it?

 

[Pho]

Yeah, but it creates an sdf file with your project to store the data in, rather than needing a 'real' SQL server.

An empty SQL Server Compact Edition database for local data

I've never actually used it, so this is all assumptions .

Alternatively sqllite or xml would be fine I'm sure.

 

[lokkers]

If you're using .NET can't you just create a local database? It's somewhere in the add file to project menu.

The OP will need SQL Express (or SQL Server) installed, as IIRC the database gets "mounted" at runtime.

That's a SQL Server database though, isn't it?

The OP asked for a database??

EDIT: Ah got your last post Pho. Yeah, he could use Compact too.

 

[Randomface74]

The OP needs XML.

 

[lokkers]

The OP needs XML.

Surely that depends on what he actually wants to achieve

 

[Engram]

The OP asked for a database??

He did indeed. Although I got the feeling he was after something "lightweight".

 

[lokkers]

MSSQL in the form of SQL Express is pretty lightweight. And it offers excellent .NET compatibility.

 

[~J~]

An XML file with an XSD would be more than sufficient if it's a database (in the lowest form of the word) that isn't going to be holding vast amounts of data.

IF the OP has Access, then creating the database in that and then an ODBC connection would also be sufficient in a very simple database.

Too many options but not enough information to really give a wise answer, but ultimately what the OP asked for can be done with relative ease.

 

[nIckEl101]

You've got a number of options.

Adding an mdb database throught the project
using and external network acessible database
using XML to store the strings
using the app.config to store the strings

it depends on how many strings you're going to be holding, and the level of comfort you have with implimenting any of the options.

 

[Engram]

MSSQL in the form of SQL Express is pretty lightweight.

But you need to install SQL Server! The OP was talking about embedding the entire database in the EXE.

 

[~J~]

But you need to install SQL Server! The OP was talking about embedding the entire database in the EXE.

use a embedded or external database

No he wasn't.

 

[tonyyeb]

IF the OP has Access, then creating the database in that and then an ODBC connection would also be sufficient in a very simple database.

I would go for this personally. Two files in the mix then, an mdb and the exe.