SqlWriter 1.0.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package SqlWriter --version 1.0.0
NuGet\Install-Package SqlWriter -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="SqlWriter" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SqlWriter --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SqlWriter, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install SqlWriter as a Cake Addin #addin nuget:?package=SqlWriter&version=1.0.0 // Install SqlWriter as a Cake Tool #tool nuget:?package=SqlWriter&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
static void Main(string[] args)
{
//insert itemlist valuelist
var insertSql = new SqlString();
insertSql.Insert("userlist", new string[] { "username", "password","enable","time"}, new object[] { "admin", "a_secret",false,DateTime.Now});
Console.WriteLine(insertSql.result);
Console.WriteLine("\n\r----------------------------------");
//delete
var deleteSql = new SqlString();
deleteSql.Delete("userlist");
deleteSql.Where("username", "hacker");
deleteSql.WhereAnd("password", "<script..");
Console.WriteLine(deleteSql.result);
Console.WriteLine("\n\r----------------------------------");
//update
var updateSql = new SqlString();
updateSql.Update("userlist", new string[] { "username", "password", "enable", "time" }, new object[] { "admin", "a_secret", false, DateTime.Now });
updateSql.Where("username", "godman");
updateSql.WhereAnd("password", "bequiet0123");
Console.WriteLine(updateSql.result);
Console.WriteLine("\n\r----------------------------------");
//select -> where ->whereand -> order
var selectSql0 = new SqlString();
selectSql0.Select(null, "userlist");
selectSql0.Where("username", "admin");
selectSql0.WhereAnd("password", "sercetX");
selectSql0.WhereAnd("isreal", true);
selectSql0.OrderBy(new OrderBy[] { new OrderBy("SignUpTime", Order.ASC), new OrderBy("followers", Order.DESC) });
Console.WriteLine(selectSql0.result);
Console.WriteLine("\n\r----------------------------------");
//select -> where ->whereand -> order
var selectSql = new SqlString();
selectSql.Select(new string[] { "sex", "age" }, "userlist");
selectSql.Where("username", "admin");
selectSql.WhereAnd("password", "sercetX");
selectSql.WhereAnd("isreal", true);
selectSql.OrderBy(new OrderBy[] { new OrderBy("SignUpTime", Order.ASC), new OrderBy("followers", Order.DESC) });
Console.WriteLine(selectSql.result);
Console.WriteLine("\n\r----------------------------------");
Console.Read();
}
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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.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.