Sample.DBUtility.Core
1.0.7
dotnet add package Sample.DBUtility.Core --version 1.0.7
NuGet\Install-Package Sample.DBUtility.Core -Version 1.0.7
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="Sample.DBUtility.Core" Version="1.0.7" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Sample.DBUtility.Core --version 1.0.7
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Sample.DBUtility.Core, 1.0.7"
#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 Sample.DBUtility.Core as a Cake Addin
#addin nuget:?package=Sample.DBUtility.Core&version=1.0.7
// Install Sample.DBUtility.Core as a Cake Tool
#tool nuget:?package=Sample.DBUtility.Core&version=1.0.7
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Sample.DBUtility.Core
DBUtility Example
// 1. 專案中建立目錄夾 "SqlCommands"
// 2. 新增 SqlCommands\xxx.sql
SELECT email FROM member WHERE email = '{0}'
// 3. 開啟 .csproj 加入
<ItemGroup>
<Content Include="SqlCommands\**\*" CopyToOutputDirectory="Always" />
</ItemGroup>
// 4. 設定連線字串
"MyDemoDBConnection": "server=;user id=;password=;port=;database=;Max Pool Size=100;Min Pool Size=5"
// 5. snippet code
public class someclass{
private static readonly NLog.Logger _logger = NLog.LogManager.GetCurrentClassLogger();
private static readonly MySQLUtility _dbUtil = MySQLUtility.instance;
private static readonly Utility _utility = Utility.instance;
private readonly string _connString = "";
public someclass(MySQLUtility db){
_connString = _utility.GetConfigField("MyDemoDBConnection");
}
public async Task demo()
{
try
{
string strSQL = "read_xxx.sql_full_text";
string[] conditions = {"demo@email.com"};
List<DBModel> lstxxx = await _db.GetDataFromMySQL<DBModel>(_connString,conditions, strSQL);
}
catch (Exception e)
{
_logger.Trace(e.StackTrace);
_logger.Error(e.Message);
}
}
}
MongoUtility Example
// 1. 設定連線字串
"MongoDBConnectionString": "mongodb://id:password@domain:port/db?authSource=admin&retryWrites=true&w=majority"
// 2. snippet code
public class someclass{
private static readonly NLog.Logger _logger = NLog.LogManager.GetCurrentClassLogger();
private static readonly MongoUtility _mongoUtil = MongoUtility.instance;
private static readonly Utility _utility = Utility.instance;
private readonly string _connString = "";
public someclass(){
_connString = _utility.GetConfigField("MongoDBConnectionString");
}
public void demo()
{
try
{
// Query
FilterDefinition<DBModel> filter = Builders<DBModel>.Filter.Regex(o => o.field, new BsonRegularExpression($"/search value/"));
List<DBModel> respRecords = await _mongoUtil.GetDataFromMongo(_connString, "Database", "Collection", filter, 0, 50);
// Insert
_mongoClient.InsertMongo<DBModel>(_connString."Database", "Collection", respRecords);
}
catch (Exception e)
{
_log.Trace(e.StackTrace);
_log.Error(e.Message);
}
}
}
ElasticsearchUtility Example
// 1. 設定連線字串
"ElasticSearchConnection":{
"node":"http://domain:port",
"authorization":"Base64.Encode(id:password)"
}
// 3. snippet code
public class someclass{
private static readonly NLog.Logger _logger = NLog.LogManager.GetCurrentClassLogger();
private static readonly ElasticsearchUtility _esUtil = ElasticsearchUtility.instance;
private static readonly Utility _utility = Utility.instance;
private readonly Dictionary<string, object> _dictEsConn;
public someclass(ElasticsearchUtility esClient){
_dictEsConn = _utility.GetConfigSection("ElasticSearchConnection");
_esUtil.SetupConnection(_dictEsConn["node"].ToString(), _dictEsConn["authorization"].ToString());
}
public void demo()
{
try
{
// Insert
bool isSuccess = await _esUtil.InsertES("index", new List<DBModel>());
// Query
List<DBModel> resp = await _esUtil.SimpleQueryES<DBModel>("index", q => q.Match(m => m.Field(f => f.field_name).Query("search value")));
}
catch (Exception e)
{
_log.Trace(e.StackTrace);
_log.Error(e.Message);
}
}
}
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
- MongoDB.Driver (>= 2.21.0)
- MySql.Data (>= 8.1.0)
- NEST (>= 7.17.5)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.