Application is split into several segments by utilizing principles of component-based development. The used architecture is MVC where each one of these segments is modular and based in different projects. We have two main applications ASP.NET Web application and Windows Forms Standalone application.
This application is for users (visitors) that only have limited functionality and can only view the data (added components).
This application is developed for the admin of the system and provides complete CRUD functionality.
In order to be able to connect MySQl and .NET you need:
- Running MySQL server
- Created database from the script file (located in the Database/MysqlScript directory)
- Plugins:
- MySql Connector for .NET (https://dev.mysql.com/downloads/connector/net/)
- This is mandatory
- MySQL for Visual Studio (https://dev.mysql.com/downloads/windows/visualstudio/)
- This is not mandatory but highly suggested (if you need Entity Framework,..)
- ALL IN ONE SERVER AND PLUGINS (https://dev.mysql.com/downloads/mysql/)
- Ikvm-8.0.5449.1 or later
- MySql Connector for .NET (https://dev.mysql.com/downloads/connector/net/)
- Add references for installed/downloaded plugins (Mysql.Data and Ikvm Core)
- If exceptions are thrown and everything is connected and should be working try adding references for all ikvm dll files instead of just Core file
- For the COM reflection, the com reflection project needs to be built which will create a COM assembly. Afterwards, in the COMComponentInspector component, the reference has to be set to the correct assembly (from COM assemblies), find COM_inspectLib and add it to the references. Also, remove the one that is already there, as the assembly path needs to be updated on each machine.