Hello Rohit, Sure: First, here is my connection string:private const string ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog = StockDataDB; Integrated Security = True; Connect Timeout = 30; Encrypt=False"; Then, here is the C# code for the function that reads data which returns a List of candlesticks as well as a DataTable object (for easy databinding to charts, gridviews, etc...). It all works perfectly.

      /// <summary>
       /// Here we get a list of candlesticks and the DataTable obtained from the database
       /// Provide the Ticker to read (e.g. "IBM")
       /// The Period (e.g. Day, Week or Month)
       /// The startDate and endDate we are interested in
       /// </summary>
       /// <param name="Ticker"></param>
       /// <param name="Period"></param>
       /// <param name="startDate"></param>
       /// <param name="endDate"></param>
       /// <returns></returns>
       internal (List<StockAnalyzer.aCandlestick>, DataTable) GetDataTableFromDatabase(String Ticker, String Period, DateTime startDate, DateTime endDate)
       {
         // Create the DataTable 
         DataTable dataTable = new DataTable();
         List<StockAnalyzer.aCandlestick> candlesticks = null;

         // Connect to the database
         using (SqlConnection conn = new SqlConnection(ConnectionString))
         {
          // Define SQL command
          string sql = "SELECT [Date], [Open], High, Low, [Close], Volume,Peak, Valley,Ticker,Period FROM StockDataTable WHERE Ticker = @Ticker AND Period = @Period AND Date BETWEEN @StartDate AND @EndDate Order by Date";
          using (SqlCommand cmd = new SqlCommand(sql, conn))
          {
              // Use SQL Parameters to prevent SQL Injection attacks
              cmd.Parameters.AddWithValue("@Ticker", Ticker);
              cmd.Parameters.AddWithValue("@Period", Period);
              cmd.Parameters.AddWithValue("@StartDate", startDate);
              cmd.Parameters.AddWithValue("@EndDate", endDate);

              try
              {
                 // Open connection
                 conn.Open();
                 SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
                 // Fill the DataTable with the result set
                 dataAdapter.Fill(dataTable);
                 // Prepare to fill the associated list of candlesticks
                 candlesticks = new List<StockAnalyzer.aCandlestick>(dataTable.Rows.Count);
                 foreach (DataRow row in dataTable.Rows)
                 {
                   StockAnalyzer.aCandlestick cs = new StockAnalyzer.aCandlestick
                   (
                    Date: Convert.ToDateTime(row[0]),
                    Open: Convert.ToDouble(row[1]),
                    High: Convert.ToDouble(row[2]),
                    Low: Convert.ToDouble(row[3]),
                    Close: Convert.ToDouble(row[4]),
                    Volume: Convert.ToInt64(row[5]),
                    Peak: Convert.ToBoolean(row[6]),
                    Valley: Convert.ToBoolean(row[7]),
                    Ticker: Convert.ToString(row[8]),
                    Period: Convert.ToString(row[9])
                   );

                   candlesticks.Add(cs);
                 }
              }
              catch (Exception ex)
              {
                 // Log or handle the exception as needed
                 MessageBox.Show("Error: " + ex.Message);
              }
          }
         }

         // return the DataTable
         return (candlesticks, dataTable);
       }

This works without any hiccups. I would love to be able to do the same (simple) thing in Mathematica. 1) Connect to StockDataDB (the database)\ 2) Execute a (simple) SQL command to read the candlesticks associated with a particular Ticker, for a particular period (daily, weekly or monthly), between a starting and ending dates. Pretty simple, isn't it? After that, all the code I have already written and that knows how to read from a CSV file can take over by doing things like plotting, finding trendline patterns, finding Elliott Waves, etc... I would be immensely grateful for a (simple) solution.