Import a CSV to a NEW table, how to Pragmatically Add or Modify a table in Lightswitch? RRS feed

  • Question

  • Hello,

    I know many ways to import data into MSSQL, but I don't know how to do it in conjunction with Lightswitch... Essentially, what I want to do is to import a CSV that has a lot of fields that I would rather not have to type in by hand.

    I've found tools and methods to import CSV to a table that already exists, but I'd like to make the table definition automatically, or at least in an automated fashion.

    I've tried before to use SSMS to connect directly to the MDF file in the project folders, but LS does not recognize changes that I make in there. I realize that I could move this database definition to a server and use it as an external data source, but then I lose the flexibility that I've been enjoying with the intrinsic database.

    Anybody got any ideas?

    Sunday, July 14, 2013 6:29 PM

All replies