C#

Tejendrasing wrote:

can anyone please have any suggestion on my approach?

..do you know the decorator-pattern?

Act as if you are programming against a single connection (program against the IDb-interface); inherit your own connection-object and IDbCommand, and implement the distribution there against the list of actual connections.

Should work, and could be executing the commands async for all sources, and report back any exceptions

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Tejendrasing wrote:

the entered information need to save to 35 databases at one time

Jayme65 wrote:

The interface will be an office with a desktop and some usual items like pens, papers, telephone, lamp, etc...

public int SelectedIndex
    {
    get { return comboBox1.SelectedIndex; }
    set { comboBox1.SelectedIndex = value; }
    }

private int index = 0;
private void button1_click(object o,EventArgs e)
    {
    Form2 F2 = new Form2();
    F2.SelectedIndex = index;
    F2.ShowDialog();
    index = F2.SelectedIndex;
    }

private int index = 0;
private void button1_click(object o,EventArgs e)
    {
    Form2 F2 = new Form2();
    F2.SelectedIndex = index;
    if (F2.ShowDialog() == DialogResult.OK)
        {
        index = F2.SelectedIndex;
        }
    }

private int index = 0;
private Form2 F2;
private void button2_Click(object o, EventArgs e)
    {
    F2 = new Form2();
    F2.SelectedIndex = index;
    F2.FormClosed += F2_FormClosed;
    F2.Show();
    }
private void F2_FormClosed(object sender, FormClosedEventArgs e)
    {
    index = F2.SelectedIndex;
    }

zead jalil wrote:

Please let me know the Best way to get the Best Performance of the EF.