Sql Server project stuff...

Dear folks,

I’ve created a Sql Server Project from my Visual Studio 2005 with Visual Basic.

When I try to add GetCommand it doesn’t appear at all, intelligense doesn’t show me that method. Why?

I don’t get the point. What else/assembly is needed?

Dim oCommandAsNew SqlCommand

Dim oPipeAsNew SqlPipe

oCommand = SqlContext.?

Thanks in advance for your comments and thoughts,

[2208 byte] By [enricvives] at [2007-12-22]
# 1
What does intellesense show you? Is it showing you only the methods for object or another set of methods?
JaredParsonsMSFT at 2007-8-30 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 2

Hi Jared,

Isavailable,Pipe,TriggerContext,WindowsIdentity properties and Equals, ReferenceEquals methods

Nothing else.

How odd!

enricvives at 2007-8-30 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 3
I'm stuck with that. Any idea?
enricvives at 2007-8-30 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 4

You're accessing the SqlContext class statically/shared. The intellesense you're listing is the correct intellesense for that class.

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.server.sqlcontext_members.aspx

GetCommand is not a member of SqlContext. Is there a different class you meant to call that on?

JaredParsonsMSFT at 2007-8-30 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 5

Hi again,

Word of honour that I've got a spanish magazine which inform you that such method exists...

he stares the following:

SqlContext provides you integrated object such as connection, command, pipe

[...]

Using GetCommand you'll obtain a command object, whose connection property is already configured in order to connect to database.

I am trying to get in touch with the writer of such issue (article refering MDBO)

Meanwhile, thanks a lot for your help.

enricvives at 2007-8-30 > top of Msdn Tech,Visual Basic,Visual Basic General...