DbPeekQueryLibrary 1.0.1
dotnet add package DbPeekQueryLibrary --version 1.0.1
NuGet\Install-Package DbPeekQueryLibrary -Version 1.0.1
<PackageReference Include="DbPeekQueryLibrary" Version="1.0.1" />
paket add DbPeekQueryLibrary --version 1.0.1
#r "nuget: DbPeekQueryLibrary, 1.0.1"
// Install DbPeekQueryLibrary as a Cake Addin
#addin nuget:?package=DbPeekQueryLibrary&version=1.0.1
// Install DbPeekQueryLibrary as a Cake Tool
#tool nuget:?package=DbPeekQueryLibrary&version=1.0.1
About
This package contains a language extension method to reveal a parameterized SQL statement written using a managed data provider in C# or VB.NET programming languages.
Example usage, a query has syntax issues which mainly come from a developer writing a query in code rather than writing the query in, for SQL-Server SSMS, for Oracle, Toad or Microsoft Access in Access.
Requirements
Queries use name parameters
, makes no sense to use this with string concatenated string as you can see
parameter values already.
For Oracle the parameter is prefixed with
:
,For SQL-Server
@
.For MS-Access (which many use
?
but not with this exension)@
.
Code samples
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
-
net5.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
No code changes, updated readme file