Interface called without implementing all methods

[tshad]

I am a little confused here.

I was under the impression that before you can use an interface (and you
can't instantiate an interface), you have to implement all the methods.

But I am trying to set up a Generic DataBase class and this seems to work.
I am not instantiating the IDbConnection interface and am not defining any
of the methods (ChangeDatabase , Close, CreateCommand, Open).

In the following I am defining dbConn as an IDbConnection and am passing it
back as an IDbConnection type:
*************** *************** *************** *************** ********
Sub LoadGrid3()
Dim dbConn As IDbConnection = _
GetConnection(" Persist Security Info=False;Data Source=AW;Initi al
Catalog=Inter")
Dim dbCmd As SqlCommand = New SqlCommand("Get Users", dbConn)
dbCmd.CommandTy pe = CommandType.Sto redProcedure

dbCmd.Parameter s.Add("@UserID" ,SqlDBType.Int) .value = 1
dbConn.Open()

DataGrid1.DataS ource = dbCmd.ExecuteRe ader
DataGrid1.DataB ind()
End Sub

Function GetConnection(C onnectString As String) As IDbConnection
Dim cnn As New SqlConnection(C onnectString)
return cnn
End Function
*************** *************** *************** *************** **************

Why does this work????

Thanks,

Tom

[=?Utf-8?B?SmFjcXVlcw==?=]

I'm not so sure about the first part of your post, but with regards to the
part about "Why does this work?"... It's because your method 'GetConnection'
is instantiating a SqlConnection object and passing that back to the caller.
In other words your function is not actually returning an IDbConnection, but
rather an instance of a SqlConnection object.

Hope it helps
Jacques

[sloan]

http://sholliday.space s.live.com/Blog/cns!A68482B9628 A842A!126.entry

it you take a look there, and look at the IAnimal / AnimalFactory example.
you can see what's going on
(as far as the design pattern goes)
Aka, you can write this code.

IAnimal ian = new Dog();

as long as Dog : IAnimal
( : = implements of course )


"tshad" <tf*@dslextreme .comwrote in message
news:e$******** ******@TK2MSFTN GP02.phx.gbl...

>I am a little confused here.

I was under the impression that before you can use an interface (and you
can't instantiate an interface), you have to implement all the methods.

But I am trying to set up a Generic DataBase class and this seems to work.
I am not instantiating the IDbConnection interface and am not defining any
of the methods (ChangeDatabase , Close, CreateCommand, Open).

In the following I am defining dbConn as an IDbConnection and am passing
it back as an IDbConnection type:
*************** *************** *************** *************** ********
Sub LoadGrid3()
Dim dbConn As IDbConnection = _
GetConnection(" Persist Security Info=False;Data Source=AW;Initi al
Catalog=Inter")
Dim dbCmd As SqlCommand = New SqlCommand("Get Users", dbConn)
dbCmd.CommandTy pe = CommandType.Sto redProcedure

dbCmd.Parameter s.Add("@UserID" ,SqlDBType.Int) .value = 1
dbConn.Open()

DataGrid1.DataS ource = dbCmd.ExecuteRe ader
DataGrid1.DataB ind()
End Sub

Function GetConnection(C onnectString As String) As IDbConnection
Dim cnn As New SqlConnection(C onnectString)
return cnn
End Function
*************** *************** *************** *************** **************

Why does this work????

Thanks,

Tom

[Barrie Wilson]

"tshad" <tf*@dslextreme .comwrote in message
news:e$******** ******@TK2MSFTN GP02.phx.gbl...

>I am a little confused here.

I was under the impression that before you can use an interface (and you
can't instantiate an interface), you have to implement all the methods.

you're not "calling an interface" as your Subject suggests; you're declaring
dbConn as being of type IDbConnection and you will get no complaint from the
compiler on this. If, on the other hand, you create a new class and
implement IDbConnection

class newClass : IDbConnection

you *must* implement all the members in the interface.

Importantly, notice that SqlConnection DOES implement all of the members of
interface IDbConnection. Accordingly, when you pass dbConn around to a
method expecting an IDbConnection type, you're ok.

I'm not clear why you need to declare dbConn as type IDbConnection here but
perhaps you have reasons to do so.

>
But I am trying to set up a Generic DataBase class and this seems to work.
I am not instantiating the IDbConnection interface and am not defining any
of the methods (ChangeDatabase , Close, CreateCommand, Open).

In the following I am defining dbConn as an IDbConnection and am passing
it back as an IDbConnection type:
*************** *************** *************** *************** ********
Sub LoadGrid3()
Dim dbConn As IDbConnection = _
GetConnection(" Persist Security Info=False;Data Source=AW;Initi al
Catalog=Inter")
Dim dbCmd As SqlCommand = New SqlCommand("Get Users", dbConn)
dbCmd.CommandTy pe = CommandType.Sto redProcedure

dbCmd.Parameter s.Add("@UserID" ,SqlDBType.Int) .value = 1
dbConn.Open()

DataGrid1.DataS ource = dbCmd.ExecuteRe ader
DataGrid1.DataB ind()
End Sub

Function GetConnection(C onnectString As String) As IDbConnection
Dim cnn As New SqlConnection(C onnectString)
return cnn
End Function
*************** *************** *************** *************** **************

Why does this work????

Thanks,

Tom