public static Message MsSqlSelect(this Message message, MsSqlConnectionConfig config, string selectStatement) { Logger.Debug("Step"); var adapter = new SqlDataAdapter(selectStatement, config.ToConnectionString()); var dataSet = new DataSet(); adapter.Fill(dataSet, "ResultTable"); var result = new XDocument(new XElement("MsSqlSelectResult")); foreach (DataTable table in dataSet.Tables) { var doc = new XElement(table.TableName); foreach (DataRow row in table.Rows) { var xmlRow = new XElement("Row"); foreach (DataColumn column in table.Columns) { xmlRow.Add(new XElement(column.ColumnName, row[column.Ordinal].ToString())); } doc.Add(xmlRow); } result.Root.Add(doc); } message.SetPayload(result.ToString()); return message; }
public static Message MsSqlSelect(this Message message, MsSqlConnectionConfig config, string selectStatement) { Logger.Debug("Step"); var adapter = new SqlDataAdapter(selectStatement, config.ToConnectionString()); var dataSet = new DataSet(); adapter.Fill(dataSet, "ResultTable"); var result = new XDocument(new XElement("MsSqlSelectResult")); foreach (DataTable table in dataSet.Tables) { var doc = new XElement(table.TableName); foreach (DataRow row in table.Rows) { var xmlRow = new XElement("Row"); foreach (DataColumn column in table.Columns) { xmlRow.Add(new XElement(column.ColumnName, row[column.Ordinal].ToString())); } doc.Add(xmlRow); } result.Root.Add(doc); } message.SetPayload(result.ToString()); return(message); }
public static Message MsSqlSelect(this Message message, string selectStatement) { if (!message.Variables.ContainsKey("Db.Host") || !message.Variables.ContainsKey("Db.Port") || !message.Variables.ContainsKey("Db.Username") || !message.Variables.ContainsKey("Db.Password") || !message.Variables.ContainsKey("Db.Database")) throw new InvalidOperationException("Configuration incorrect"); var config = new MsSqlConnectionConfig { Host = message.Variables["Db.Host"].ToString(), Port = int.Parse(message.Variables["Db.Port"].ToString()), Username = message.Variables["Db.Username"].ToString(), Password = message.Variables["Db.Password"].ToString(), Database = message.Variables["Db.Database"].ToString() }; return message.MsSqlSelect(config, selectStatement); }
public static Message MsSqlSelect(this Message message, string selectStatement) { if (!message.Variables.ContainsKey("Db.Host") || !message.Variables.ContainsKey("Db.Port") || !message.Variables.ContainsKey("Db.Username") || !message.Variables.ContainsKey("Db.Password") || !message.Variables.ContainsKey("Db.Database")) { throw new InvalidOperationException("Configuration incorrect"); } var config = new MsSqlConnectionConfig { Host = message.Variables["Db.Host"].ToString(), Port = int.Parse(message.Variables["Db.Port"].ToString()), Username = message.Variables["Db.Username"].ToString(), Password = message.Variables["Db.Password"].ToString(), Database = message.Variables["Db.Database"].ToString() }; return(message.MsSqlSelect(config, selectStatement)); }