using System;

using bcpSimpleLibrary; //<==記得using，nuget搜尋bcpSimpleLibrary

public class Program

{

    static void Main(string[] args)

        {

            //7月20號筆記

            try

            {

                //==========匯出CSV==========

                using (var db = new YourDbContext())//linqToSQL的DbContext

                {

                    var sql = @"你的SQL select語法，FROM資料表的名稱要含DB名稱".Render(new { ecid = 8 }).RemoveNewLine();

                    var sqlScript = db.ExportToCsv(

                        sql,

                        new ExportSettings()

                        {

                            CsvFileName = "Product_{{ecid}}_{{date}}.csv".Render(new { ecid = 8, date = DateTime.Now.ToString("yyyyMMdd") }),

                            ExportFolder = "d:\\Export_{{ecid}}\\".Render(new { ecid = 8 })

                        }

                    );

                }

                //==========壓縮檔案==========

                 var zipcmd = db.ZipSingleFile(

                    "d:\\7za.exe", //你的azip執行檔路徑

                    "d:\\你的CSV名稱.csv",

                    "d:\\壓縮後路徑\\壓縮檔名稱.7z");

                //==========上傳FTP==========

                 Ftp.UploadSingleFileToFtpServer(

                    "ftp://主機Ip/壓縮檔名稱.7z",  //遠端ftp主機url，注意，要含檔名

                    "ftp帳號",  //帳號

                    "ftp密碼",  //密碼

                    "d:\\壓縮後路徑\\壓縮檔名稱.7z") //要上傳的檔案路徑

                    );

                //==========解壓縮檔案=========

                 var uzip = BCP.UnZipSingleFile(

                    "C:\\7za920\\7za.exe", //你的azip執行檔路徑

                    sourceZipFilePath: "D:\\ftp\\壓縮檔名稱.7z", //ftp上傳後壓縮檔路徑

                    destFileFolder: "D:\\ftp\\" //解壓縮檔存放路徑

                 );

                //==========匯入資料=========

                var cmd = BCP.ImportFromCsvToAzureSQL(new AzureImportSettings()

                {                    

                    AzureServerName_beginwith_tcp_endwith_portnum = "tcp:主機名稱.database.windows.net,1433", //azure上sql server主機名稱                    

                    AzureUserName_username_at_servername = "資料庫帳號@主機名稱",

                    AzureSQLPassword = "資料庫密碼",

                    CsvFileFullPath = "csv檔案路徑",

                    ImportDbName = "匯入資料庫名稱",

                    ImportTableName = "匯入資料表名稱",

                    bcpFullFilePath = "C:\\bcp.exe" //bcp檔案路徑

                });

​

​

            }

            catch (Exception e)

            {

                Console.WriteLine(e.Message);

            }

        }

}