Imato.MsSql.ExternalData
2.1.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 Imato.MsSql.ExternalData --version 2.1.0
NuGet\Install-Package Imato.MsSql.ExternalData -Version 2.1.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="Imato.MsSql.ExternalData" Version="2.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Imato.MsSql.ExternalData --version 2.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Imato.MsSql.ExternalData, 2.1.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 Imato.MsSql.ExternalData as a Cake Addin #addin nuget:?package=Imato.MsSql.ExternalData&version=2.1.0 // Install Imato.MsSql.ExternalData as a Cake Tool #tool nuget:?package=Imato.MsSql.ExternalData&version=2.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Imato.MsSql.ExternalData
How to put data from external cmd process to SQL server
Using
Programm for produse data
- Create your own process to produce new data. Override CreateData in DataProcess
internal class DaysProcess : DataProcess<MonthDay>
{
public DaysProcess(string[] args) : base(args)
{
}
protected override IEnumerable<MonthDay> CreateData(
IDictionary<string, string> parameters)
{
....
}
}
- Create table for DTO class MonthDay in DB
create table ##test
(
Id int,
Name varchar(30),
Date datetime,
IsDayOf bit
)
- Run process
public static async Task Main(string[] args)
{
await new DaysProcess(args).RunAsync();
}
- Start your executable for producing data with parameters
>Imato.MsSql.ExternalData.Example.exe Year=2022 Month=10
Add special parameter for destination table
>Imato.MsSql.ExternalData.Example.exe Year=2022 Month=10 Table=##test
Override connection string if it isn't local
>Imato.MsSql.ExternalData.Example.exe Year=2022 Month=10 Table=##test ConnectionString=yourConnection
- Execute your cmd util in t-sql script
Create procedure execmd.sql in msdb.
Start
exec dbo.execmd 'Imato.MsSql.ExternalData.Example.exe Year=2022 Month=10 Table=##test'
Use data from ##test in t-sql script.
Programm for execute same command without result
- Create your own command executor Override StartCommand in Process
internal class SameProcess : CommandProcess
{
public SameProcess(string[] args) : base(args)
{
}
protected override Task StartCommandAsync()
{
switch Command:
.....
}
}
- Run process
public static async Task Main(string[] args)
{
await new SameProcess(args).RunAsync();
}
- Start your executable for execute command
>Imato.MsSql.ExternalData.Example.exe Command=Test
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net7.0 is compatible. 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net7.0
- FastMember (>= 1.5.0)
- System.Data.SqlClient (>= 4.8.5)
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 |
---|---|---|
2.6.2 | 374 | 12/12/2022 |
2.6.1 | 324 | 12/9/2022 |
2.6.0 | 311 | 12/9/2022 |
2.5.0 | 322 | 12/9/2022 |
2.4.0 | 338 | 12/8/2022 |
2.3.0 | 336 | 12/8/2022 |
2.2.0 | 331 | 12/8/2022 |
2.1.0 | 337 | 12/8/2022 |
2.0.0 | 378 | 12/2/2022 |
1.5.0 | 353 | 12/1/2022 |
1.4.0 | 355 | 11/29/2022 |
1.3.0 | 343 | 11/29/2022 |
1.2.0 | 385 | 11/28/2022 |
1.1.0 | 373 | 11/28/2022 |
1.0.0 | 371 | 11/26/2022 |
Ready to use