asp.net - Attempting to create an Entity Framework model from a MySQL database fails with an unexpected exception -

-

so, i'm trying set mysql , asp.net.

currently, have both visual studio 2013 , visual studio 2015 installed on pc. used installer mysql (basically 1 comes need started, including mysql visual studio): mysql installer

anyways, quick test made new asp.net mvc project, connected database in server browser (which works fine!). however, tried create ado.net model it. when come step of generating model database, error/exception:

error/exception message

this happens in both visual studio 2013 and visual studio 2015.

i have tried search way out of (i've tried different databases, used of sample databases included mysql server installed, still got same error), don't seem able find information on it. additionally, might worth noting when select version of entity framework use, this:

entity framework version select

which seems odd i'd think newest mysql installer did include mysql visual studio supports ef 6.x?

anyways, assistance or hints on problem appreciated :)

edit - narrowed down problem bit

so, found out problem occours whenever have database foreign keys in. still no clue why, databases without them can generate!

try run command on mysql workbench:

set global optimizer_switch='derived_merge=off'

good luck!


Comments

Post a Comment

Popular posts from this blog

java - Static nested class instance -

-
this question has answer here: java inner class , static nested class 23 answers i came across in java, know static nested class why create instance of 'static'. isn't whole idea of 'static' use without instance? understand concept of inner classes, why (and frankly how possible to) create 'instance' of 'static' member @ ? why this: 1- outerclass.staticnestedclass nestedobject = new outerclass.staticnestedclass(); 2- nestedobject.anestedclassmethod(); and not this: 1- outerclass outerinstance=new outerclass(); 2- outerinstance.staticnestedclass.anestedclassmethod(); use on inner classes, keyword static indicates can access inner class without instance of outer class. for example: public class outer { public static class inner { /* code here. */ } } with construction, can create instance of inn
Read more

c# - Bluetooth LE CanUpdate Characteristic property -

-
i building xamarin.forms cross platform mobile app, uses monkey.robotics bluetoth low energy functionality. connecting mbed based implimentation of custom gatt service . in xamarin c#, triggers characteristic. canupdate property in monkey.robotics? this standard example c# based on: if (characteristic.canupdate) { characteristic.valueupdated += (s, e) => { debug.writeline("characteristic.valueupdated"); device.begininvokeonmainthread( () => { updatedisplay(characteristic); }); isbusy = false; // spin until first result received }; isbusy = true; characteristic.startupdates(); } this has been working, since changed own custom gatt service connecting to, canupdate property false. property , how triggered? me debugging gatt service code. thanks monkey.robotics open sour
Read more

JavaScript - Replace variable from string in all occurrences -

-
ok, know if have character '-' , want remove in places in string javascript, ... someword = someword.replace(/-/g, ''); but, when applying array of characters, s not working ... const badchars = ('\/:*?"<>|').split(''); let filename = title.replace(/ /g, '-').tolocalelowercase(); (let item = 0; item < badchars.length; item++) { // below not work global '/ /g' filename = filename.replace(/badchars[item]/g, ''); } any ideas? /badchars[item]/g looks badchars , literally, followed i , t , e , or m . if you're trying use character badchars[item] , you'll need use regexp constructor, , you'll need escape regex-specific characters. escaping regular expression has been well-covered . using that: filename = filename.replace(new regexp(regexp.quote(badchars[item]), 'g'), ''); but , don't want that. want character class: let filename = title.replac
Read more