Is there an easy way to take data from a Deedle dataframe and insert it into an existing SQL Server table using C#?
有没有一种简单的方法从Deedle数据帧中获取数据并使用C#将其插入到现有的SQL Server表中?
1 个解决方案
#1
1
There is a ToDataTable extension method. available on data frames.
有一个ToDataTable扩展方法。可用于数据框架。
This gives you a fairly simple way to get all the data from a data frame and it should not be hard to find code samples showing how to insert data from a DataTable into SQL database.
这为您提供了一种从数据框中获取所有数据的相当简单的方法,并且不难找到显示如何将数据从DataTable插入SQL数据库的代码示例。
- One SO answer showing this is: Insert entire DataTable into database at once instead of row by row?
一个SO答案显示:将整个DataTable一次性插入数据库而不是逐行?
#1
1
There is a ToDataTable extension method. available on data frames.
有一个ToDataTable扩展方法。可用于数据框架。
This gives you a fairly simple way to get all the data from a data frame and it should not be hard to find code samples showing how to insert data from a DataTable into SQL database.
这为您提供了一种从数据框中获取所有数据的相当简单的方法,并且不难找到显示如何将数据从DataTable插入SQL数据库的代码示例。
- One SO answer showing this is: Insert entire DataTable into database at once instead of row by row?
一个SO答案显示:将整个DataTable一次性插入数据库而不是逐行?