Accessing SQL Database from C# Without SQL Server

[sampalmer21]

Is it at all possible to access a sql database, whether reading it or storing values to it, without having sql server installed or running as a process in the background? Perhaps this can be done using SMO?

I ask this question because my client does not want my application to install any sql rdbms (sql server, mysql, db2 etc.) on their machine. So is there a way to process data directly to a database file such as a Sql Server .mdf file?

[balame2004]

Is it at all possible to access a sql database, whether reading it or storing values to it, without having sql server installed or running as a process in the background? Perhaps this can be done using SMO?

I ask this question because my client does not want my application to install any sql rdbms (sql server, mysql, db2 etc.) on their machine. So is there a way to process data directly to a database file such as a Sql Server .mdf file?

Hi,


If you don't want to use server database (SqlServer,Orac le,etc) , please use MS Access to store/retrieve data. MS Access will act as Desktop database.

Cheers,
Balaji U