dbx-sql-csharp
0.0.3
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 dbx-sql-csharp --version 0.0.3
NuGet\Install-Package dbx-sql-csharp -Version 0.0.3
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="dbx-sql-csharp" Version="0.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add dbx-sql-csharp --version 0.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: dbx-sql-csharp, 0.0.3"
#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 dbx-sql-csharp as a Cake Addin #addin nuget:?package=dbx-sql-csharp&version=0.0.3 // Install dbx-sql-csharp as a Cake Tool #tool nuget:?package=dbx-sql-csharp&version=0.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
var connection = new Connection(
hostname,
httpPath,
accessToken);
var cancellationToken = new CancellationToken();
await connection.OpenAsync(cancellationToken);
const string sql = "select * from db.table where year_month='202212' limit 100000";
var sw = new Stopwatch();
sw.Start();
var count = 0;
using (var cursor =
connection.GetCursor(maxRows: 100000, canReadArrowResult: true, canReadCompressed: true))
{
try
{
await cursor.ExecuteAsync(sql, cancellationToken);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
await cursor.CloseAsync(cancellationToken);
await connection.CloseSessionAsync(cancellationToken);
throw;
}
await foreach (var row in cursor.GetRowAsync(cancellationToken:cancellationToken))
{
Console.WriteLine($"{row[0]}");
count++;
}
}
sw.Stop();
Console.WriteLine($"Time: {sw.ElapsedMilliseconds} ms");
Console.WriteLine($"Received {count} rows");
await connection.CloseSessionAsync(cancellationToken);
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 | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.1 is compatible. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | 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.1
- Apache.Arrow (>= 10.0.1)
- ApacheThrift (>= 0.17.0)
- IonKiwi.lz4.managed (>= 1.0.7)
- Microsoft.Data.Analysis (>= 0.20.1-preview.22573.9)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.