Esempi in C# (CSharp) per ISqlService.ExecuteInsertToTable

Esempio n. 1

 private IList <IncidentActivationServiceModel> GetIncidentList()
 {
     try
     {
         var dataTable = _sqlService.ExecuteInsertToTable(GetListIncidentTextCommand, "ConnectToSupportExtensions");
         return(dataTable.Rows.Count == 0
             ? new List <IncidentActivationServiceModel>()
             : JsonConvert.DeserializeObject <List <IncidentActivationServiceModel> >(JsonConvert.SerializeObject(dataTable)));
     }
     catch (Exception e)
     {
         return(new List <IncidentActivationServiceModel>());
     }
 }