How to import a large SQL query into Visual Studio database?
Solution 1:
As I see, your file has CSV format. There are many options to import CSV to MS SQL database.
- SQL Server Management Studio: select a database, then Tasks - Import data -> Flat File Source
- SQL: BULK INSERT query
- C#: SqlBulkCopy class. MSDN, Direct CSV read, CsvDataReader.