Techvani.MSSQlDBInfo
1.0.0
dotnet add package Techvani.MSSQlDBInfo --version 1.0.0
NuGet\Install-Package Techvani.MSSQlDBInfo -Version 1.0.0
<PackageReference Include="Techvani.MSSQlDBInfo" Version="1.0.0" />
<PackageVersion Include="Techvani.MSSQlDBInfo" Version="1.0.0" />
<PackageReference Include="Techvani.MSSQlDBInfo" />
paket add Techvani.MSSQlDBInfo --version 1.0.0
#r "nuget: Techvani.MSSQlDBInfo, 1.0.0"
#:package Techvani.MSSQlDBInfo@1.0.0
#addin nuget:?package=Techvani.MSSQlDBInfo&version=1.0.0
#tool nuget:?package=Techvani.MSSQlDBInfo&version=1.0.0
DataBaseInfo
This package provides all information about the given database ,you just need to provide valid connection string in constrictor of DataBaseInfo class.
Methods:
GetTables() Returns: List<string> of Table Names (e.g., “databaseSchemaName.TableName”).
GetSchemas() Returns: List<string> of Schema Names.
GetConstraints(“Schema_Name”,”Table_Name”) Returns: List<Object> , where object is of constraint type having two properties: “Contraint_Name” , “Contraint_Type” (e.g.,”Foreign Key”).
GetTablesBySchema(“Schema_Name”) Returns: List<string> of Table Names
GetViews() Returns: List<string> of View Names.
GetUserFunctions() Returns: Object of function type , having two properties:
- “Function_Name” ,
- List<object> of parameters (this list provides: “parameter_name”, “type” (e.g., “In” or “Out”), “DataType” (e.g., “int”,”vchar” etc), “Length”, “Position”).
- GetUserFunctionsBySchema(“Schema_Name”) Returns: Object of function type , having two properties:
- “Function_Name” ,
- List<object> of parameters (this list provides: “parameter_name”, “type” (e.g., “In” or “Out”), “DataType” (e.g., “int”,”vchar” etc), “Length”, “Position”).
- GetProcedures() Returns: Object list of procedure type, having two properties:
- “Procedure_Name” ,
- List<object> of parameters (this list provides: “parameter_name”, “type” (e.g., “In” or “Out”), “DataType” (e.g., “int”,”vchar” etc), “Length”, “Position”).
- GetProceduresBySchema(“Schema_Name”) Returns: Object list of procedure type, having two properties:
- “Procedure_Name” ,
- List<object> of parameters (this list provides: “parameter_name”, “type” (e.g., “In” or “Out”), “DataType” (e.g., “int”,”vchar” etc), “Length”, “Position”).
- GetColumns(“Schema_Name”,”Table_Name”) Returns: Object list of Column type, having three properties:
- “Column_Name” ,
- “Column_DataType”,
- “Maximum_Length”
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
.NET Core | netcoreapp3.0 is compatible. netcoreapp3.1 was computed. |
-
- System.Data.SqlClient (>= 4.8.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last Updated |
---|---|---|
1.0.0 | 615 | 12/27/2019 |