T4Query.SqlServer
1.0.4
See the version list below for details.
dotnet add package T4Query.SqlServer --version 1.0.4
NuGet\Install-Package T4Query.SqlServer -Version 1.0.4
<PackageReference Include="T4Query.SqlServer" Version="1.0.4" />
paket add T4Query.SqlServer --version 1.0.4
#r "nuget: T4Query.SqlServer, 1.0.4"
// Install T4Query.SqlServer as a Cake Addin #addin nuget:?package=T4Query.SqlServer&version=1.0.4 // Install T4Query.SqlServer as a Cake Tool #tool nuget:?package=T4Query.SqlServer&version=1.0.4
------ Connection string Database in Sql Server SqlData.ConnectionString = "data source=<SeverName>;initial catalog=<TableName>;user id=<UserName>;password=<Password>;MultipleActiveResultSets=True;App=EntityFramework";
<SeverName>: Server connect Sql server. Ex.: .\SqlExpress <TableName>: Table in Database connect. Ex.: olitvn.com <UserName>: Username login in Sql server. Ex.: sa <Password>: Password login in Sql server. Ex.: t4vn.com
------ Before execute Transact-SQL statement or stored procedure new SqlData(<QuerySql>); OR new SqlData(<QuerySql>, <Parameter>); OR new SqlData(<QuerySql>, <CommandType>, <Parameter>);
<QuerySql>: String query in Sql Server <CommandType>: Is type System.Data.CommandType (Default CommandType.Text) <Parameter>: Array or olny one System.Data.SqlClient.SqlParameter
------ Execute Transact-SQL statement or stored procedure return result ExecuteNonQuery ExecuteScalar ExecuteDataTable ExecuteDataSet ExecuteXmlReader SqlDataReader FirstOrDefault IEnumerable ToList
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. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- 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.
Add function:
- ExecuteReader
- ExecuteXmlReader