Database Connection with access,excel,sql,oracle,sqlite using wpf.

Solution1 by thatraja is good and explains how to create WPF application with multiple databases.

I would like to provide some more details...

First of all, it won't be so easy. Why? There are several resons, but the most important is that, that each .NET Framework Data Provider[^] has got own set of objects, methods, etc. Follow the link to find out.

Of course, you can try to write "super-universal-Data-Access-Layer[^]" with overloaded methods[^] to insert, select, update and delete data. A connection object should be passed as an input parameter.

My advice: don't do that. There is too many things to make a mistake. Better move your focus on one, maybe two, databases.

with oracle i use this code hope it will help you

firstly ad reference Oracle.DataAccess
then addind namespace using Oracle.DataAccess.Client;
And using the following code
try
{
string MyConString = "Data Source=localhost;User Id= yourusername;Password=yourpassword;";
using (OracleConnection connection = new OracleConnection(MyConString))
{
connection.Open();
sqldb1 = "select * from DEMO_CUSTOMERS;";
using (OracleCommand cmdSe1 = new OracleCommand(sqldb1, connection))
{
DataTable dt = new DataTable();
OracleDataAdapter da = new OracleDataAdapter(cmdSe1);
da.Fill(dt);
db1.ItemsSource = dt.DefaultView;
}
connection.Close();

}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}