Visual Studio, Asp.net connection string

Question

In the Visual Studio, it will generate datasource like this :

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:AdventureWorksConnectionString1 %>" 
        SelectCommand="SELECT top 10 * FROM [Address]">
    </asp:SqlDataSource>

when run it, it will say 'invalid object'. then I found it out, it should be

[AdventureWorks].[Person].[Address]

The connection string is

 <connectionStrings>
        <add name="AdventureWorksConnectionString1" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

Then how to config in VS to use this format ?

What does your connection string look like? Maybe apart from what Oded already pointed out, the Initial Catalog=AdventureWorks is missing and your query is directed against the master database. — Filburt
– Filburt, Commented May 10, 2012 at 13:48

Oded · Accepted Answer · 2012-05-10 15:52:38Z

2

The default schema for the logged in database user is probably [dbo], not [Person]. You need to qualify the schema name in such a case.

Your select command should be:

SELECT top 10 * FROM [Person].[Address]

edited May 10, 2012 at 15:52

answered May 10, 2012 at 13:43

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Oded Over a year ago

@user595234 - Apologies, you are correct. You need to qualify the schema if the user is not setup to use that one by default.

Collectives™ on Stack Overflow

Visual Studio, Asp.net connection string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related