Menu
I am trying to add a reference to the above assembly but it does not appear in my ASP.NET MVC .NET 4 (Not client) applications Assembly list. Does anyone know how to reference this Assembly?
820
Management. Common namespace resides in the Microsoft. SqlServer. ConnectionInfo.
The SMO assemblies are installed by default into the Global Assembly Cache (GAC) with the SQL Server SDK option. The assemblies are located in C:\Program Files\Microsoft SQL Server\130\SDK\Assemblies.
From the Add New Item window, select ADO.NET Entity Data Model and set its Name as NorthwindModel and then click Add. Then the Entity Data Model Wizard will open up where you need to select EF Designer database option. Now the wizard will ask you to connect and configure the Connection String to the database.
The Microsoft.SqlServer.Management.Common namespace resides in the Microsoft.SqlServer.ConnectionInfo.dll assembly.
Microsoft.SqlServer.Management.Common Namespace (MSDN)
Assuming the default installation folders you can find the Microsoft.SqlServer.ConnectionInfo.dll assembly in:
C:\Program Files\Microsoft SQL Server\XXXX\SDK\Assemblies
Where XXXX represents the version of SQL Server you're running:
80 -> SQL Server 2005 90 -> SQL Server 2008 100 -> SQL Server 2008R2
If you're running SQL Server 32bit on x64 then instead of c:\Program Files use c:\Program Files (x86).
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
