Want your feedback on my first object in C# (with sample solution now!)

[jmcilhinney]

What do you mean by a "shared property"? Are you using "shared" in the VB.NET sense, which is "static" in C#? Also, what class are you using this in? I would think that this should be an abstract method of the base class that you override in the derived PreparedStatement classes.

    public abstract class Parent
    {
        public abstract IDbConnection GetConnection();
    }

    public class Child1 : Parent
    {
        public override IDbConnection GetConnection()
        {
            return new OleDbConnection();
        }
    }

[dee-u]

Yup, I meant abstract, have you tried your sample code if it works? I think I have also something along such line and encountered an error, can't test for now since I don't have IDE here... And I am thinking of probably using like the ff but encountered an error also , I'm just freehand typing it, don't know if it's 100% correct...

public class Child
{	
	private OleDbConnection conn1 = new OleDbConnection;
	private SqlConnection conn2 = new SqlConnection();
	private IDbConnection conn3;

	public void SetConnection(int pType)
	{
		switch
		{
			case is 1:
				conn3 = conn1;					
				break;
			case is 2"
				conn3 = conn2;
				break;

			default;
				conn3 = conn1
				break;
		}
	}

	public IDbConnection GetConnection()
	{
		return conn3;		
	}

}