GradeXpertContext is the name of my class the inherits from DbContext.Ĭan you please tell me what I need to do in order to be able to query data and start writing Linq queries etc. This is usually achieved by setting the correct library directory. Make sure youre using the static library, the.dll will give you new issues that you dont need to worry about. The problem I have, is that as soon as I try query something - I get the following error:ĬS0120 An object reference is required for the non-static field, method, or property 'GradeXpertContext.System' Confirm the name by going to the mysql folder which holds the binaries. I then added a reference to my own dll that contains my dbContext - the UI refreshes and the list of tables and relationships shows correctly. If I connect to MySQL directly - I can see the tables, but tables do not relate to each other,so Linq queries become cumbersome. MySQL Cluster is a real-time open source transactional database designed for fast, always-on access to data under high throughput conditions. The database has no physical foreign keys defined at all - each table has a PK and fields that would link to PKs in other tables, but PKs are not physically defined in the database - all logical PKs. I have a poorly designed MySQL database that I need to connect to (an existing system I have been asked to write some web interfaces to) - I cannot modify the database schema at all. I followed various links I found on the web to add a custom database connection using my own dbContext in my own DLL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |