public void TestTable()
{
var args = new Query.QueryArgs("Server=192.168.100.12;Initial Catalog=InSysProMaxLive20181126;User ID=sa;Password=dev123sql$%^;");
using (var dfg = new ZTable(args, "tSellerHRIS", false))
{
dfg.Load(100);
}
}
/// <summary>
/// Class
/// </summary>
protected CoreController()
{
try
{
Sql = new Query.QueryArgs(Config.Get("SQLConnection").ToString());
Initializer();
}
catch (Exception ex)
{
Error = ex;
}
}
public ObjectTypeEnum GetObjectType(SqlConnection vConnection)
{
var type = new Query.QueryArgs(vConnection.ConnectionString).ExecScalar("SELECT [type] FROM sys.objects WHERE name = @ZTable", this.TableName).ToString().Trim();
switch (type)
{
case "U": this.ObjectType = ObjectTypeEnum.Table; break;
case "V": this.ObjectType = ObjectTypeEnum.View; break;
case "FN": this.ObjectType = ObjectTypeEnum.InlineFunction; break;
case "IF": this.ObjectType = ObjectTypeEnum.Function; break;
case "P ": this.ObjectType = ObjectTypeEnum.StoredProcedure; break;
}
return(this.ObjectType);
}
[Fact] //for testing
public void QueryFired()
{
var args = new Query.QueryArgs("Server=tcp:jollibeesvr.database.windows.net,1433;Initial Catalog=InSysJFCDirect_Test;Persist Security Info=False;User ID=jollibeeadmin;Password=P@ssw0rd12345;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
var cts = new CancellationTokenSource();
using (var sql = new QueryFire(args, cts.Token))
{
sql.Message += (s, e) => { };
Task.Run(() =>
{
Task.Delay(3000);
cts.Cancel();
});
sql.Execute("pComputeHours @ID, 1", 220);
}
}
