What tool to choose for the client and to work with the database using C #?

INITIAL DATA:

  1. the predominant type of relationship between tables 1: M;
  2. different requests will be used;
  3. The main client functionality is shown in the form "001_000_tst_Form1" of the attached file;

Those. It is necessary that you can use:

  • tabs on the form;
  • several tables on one form (panel);
  • several fields of tables are placed on the form and they can be edited and formatted;
  • the possibility of using additional buttons (not shown on the form);

BASIC REQUIREMENT:

  1. database tables are located on MySql;
  2. the client can be developed as a program or as a web;

FORMAL REQUIREMENT:

  1. Intuitive client development (based on the principle of Access or LightSwitch);
  2. the optimal process of updating the modified (formatted) data in the record. Those. the data is automatically updated in the source or updated by pressing a key;
  3. Ability to build data trees (menu) with the ability to search for items (see screen);
  4. the ability to build diagrams of various analytics based on data from tables;
  5. possibility of displaying table fields (see screen);
  6. the ability to display photos in the table;
    Those. there is a base of employees with photos.
    It is necessary that the photos of employees in the database are displayed both in the initial position of the table, and after filtering

Database file: http://transfiles.ru/7ug8a

enter image description here

enter image description here enter image description here

  • one
    in the current formulation of the question: the excel client (he knows how to analytics, even works with cubes), the developer of the mysql workbench, and not some C #. If you want to write everything yourself, then WinForms (original) should not be used exactly, it will take a lot of hands, but in the version from DevExpress or SyncFusion you can even have them. In the current formulation of the question there is not enough of a huge amount of information necessary, even for an approximate assessment of what specifically to use or not to use. There is no definite answer to your question, and the questionnaires are oftopic here. - rdorn
  • @rdorn 1. to the клиенту excel - I thought about it, but how to organize feedback in Excel? Those. so that the client can read, edit, format the data inside the cell, add, delete records in the tables that are on the server. 2. не хватает огромного количества информации - could you tell me what and where to look, read about this list of questions .. maybe you have a more complete questionnaire - koverflow
  • @rdorn 3. и ни какого C# what do you mean? Don't bother with C # at all? - koverflow
  • 2
    "No C #" related to the excel version, and nothing more. The "Detailed Questionnaire" is called the Technical Assignment, which needs to be shaken out of the client, and the more detailed and accurate the less will have to be redone. Feedback in excel can be organized by macros on VBA for example. Or to add your own plugin, it is more difficult, but it can be justified, again, without a clear TK, it is difficult to advise anything. Start by getting a clear TK from the client, then advice may not be needed. - rdorn
  • I would choose the c # windows forms tool, only with diagrams and photos inside the table would probably be straining. I usually solve all problems with standard features, without third-party components (they are like a black box). Think over the interfaces. Possibly the photo inside the table in the cell can not be visually displayed the best solution ... - IvanZakirov

1 answer 1

Good day!

When it comes to relational databases and C #, I advise you to use ORM Entity Framework 6 (manual) and a link to NuGET EF6 . Its main advantage is the convenience of creating an object model in your code with just a couple of clicks, as well as the simplicity of creating further queries to the database using the created object model and LINQ to Objects . ADO.NET is the last century, forget about it.

Your necessary functionality for displaying data, color display, tree and other things is fully satisfied with the technology of Windows Forms and its standard controls ( DataGridView , TreeView , TextBox , Chart ). Or, if you are familiar with XAML, you can use WPF technology.