We recommend using Visual Studio 2017

DatabaseMapping Class

The DatabaseMapping object represents a SQL Server database mapping.


Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public sealed class DatabaseMapping

The DatabaseMapping type exposes the following members.

Public methodDatabaseMappingInitializes a new instance of the DatabaseMapping class for the specified login, database, and user.

Public propertyDBNameGets the name of the database in which the login is mapped to the database user.
Public propertyLoginNameGets the name of the login that is mapped to the user in the database.
Public propertyUserNameGets the database user that is mapped to the login in the database.

Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToStringReturns a string that represents the DatabaseMapping object. (Overrides Object.ToString().)

A login allows access to SQL Server, though it does not allocate permissions at a database level. Each login requires mapping to a database user within each database. The information about each mapping is stored in the DatabaseMapping object. Every login has a database mapping for each database that it can access.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions