I downloaded it from NuGget System.Data.SQLite and cannot connect to the creater connection. From here the problem follows I can not create strictly typed DataSet. Ideas 2 are the first to abandon strict typing and fill out DS with my hands, I don’t really like it, a lot of letters like that, the second option will reach api generation and force it to run on something like a library, if you honestly like even less than the first option. Smacks of love for bicycles. So I ask your opinion in the studio how to deal with the existing problem? Or do I really need to stuff a DataSet with my hands?

  • one
    "I can't create a strongly typed DataSet" - is it really needed? use the DataAdapter to populate the DataSet, and then simply bind it to the UI. - Stack
  • Do you mean to make a bunch of adapters for each table and where can I fill them with DS? - user197567
  • for each table is not needed. because there is a DataAdapter.Fill (DataSet) - Stack
  • Something I do not really understand you. Do you propose to create an empty DataSet Create DataAdapters by number of tables, describe their commands, and then record the operation of each adapter in DS? - user197567
  • one DataSet and one DataAdapter, see How to fill Dataset with multiple tables? - Stack

1 answer 1

Install System.Data.SQLite globally: add it to the GAC, list what you usually have in app.config, in machine.config.

After that, restart the studio and then you can create a typed dataSet through the wizard.