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); } }