如何在C#中为SQL Server表创建Deedle数据帧

本文关键字:创建 Deedle 数据帧 Server SQL 中为 | 更新日期: 2023-09-27 18:00:56

我正试图从云上的SQL Server实例中填充Deedle数据帧,但遇到了一些问题。我正试图轻松地将表加载到Deedle Dataframe中。现在我只能打印表格了。

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using Deedle;
using DeedleCustomNamespace;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
namespace ConsoleApplication3
{
    class Program
    {
        static void Main(string[] args)
        {
            string cs = "Server=somedb.database.windows.net;Database=somedb;User Id=SomeUser;Password=SomePassword;";
            SqlConnection myConnection = new SqlConnection(cs);
            try
            { myConnection.Open(); }
            catch (Exception e)
            { Console.WriteLine(e.ToString()); }
            try
            {
                SqlDataReader myReader = null;
                SqlCommand myCommand = new SqlCommand("SELECT * FROM Table1", myConnection);
                myReader = myCommand.ExecuteReader();
                while (myReader.Read())
                {
                    Console.WriteLine(myReader["Column1"].ToString());
                    Console.WriteLine(myReader["Column2"].ToString());
                }
            }
            catch (Exception e)
            { Console.WriteLine(e.ToString()); }
            try
            { myConnection.Close(); }
            catch (Exception e)
            { Console.WriteLine(e.ToString()); }
        }
    }
}

如何在C#中为SQL Server表创建Deedle数据帧

namespace ConsoleApplication3
{
    class Program
    {
        static void Main(string[] args)
        {
            string cs = "Server=somedb.database.windows.net;Database=somedb;User Id=SomeUser;Password=SomePassword;";
            SqlConnection myConnection = new SqlConnection(cs);
            try
            { myConnection.Open(); }
            catch (Exception e)
            { Console.WriteLine(e.ToString()); }
            try
            {
                SqlDataReader myReader = null;
                SqlCommand myCommand = new SqlCommand("SELECT * FROM Table1", myConnection);
                myReader = myCommand.ExecuteReader();
                var SomeDataframe = Frame.ReadReader(myReader);
                SomeDataframe.Print();
            }
            catch (Exception e)
            { Console.WriteLine(e.ToString()); }
            try
            { myConnection.Close(); }
            catch (Exception e)
            { Console.WriteLine(e.ToString()); }
        }
    }
}