asp.net - How to generate the right connection string for MySql -

-

i have asp.net mvc site & using ef code first

as database, using mysql. not getting right connection string. if mssql have generate using visual studio itself.

is there quick way auto generate right connection string when using mysql.

thanks.

this useful 

<connectionstrings>    <add name="mycontext" providername="mysql.data.mysqlclient"     connectionstring="server=localhost;port=3306;database=mydbname;uid=my_user_id;password=my_password"/> </connectionstrings>

tipically my_user_id = root

https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html


Comments

Post a Comment

Popular posts from this blog

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more

python - Getting next two indexes regardless of current index -

-
i trying create mock rock, paper, scissors game each name having 2 enemies, must able grab values of names regardless of position. say given list: names = ["kings", "queens", "jacks", "jokers", "masons", "warriors", "soldiers"] and trying use logic indexes being values , gather next 2 values of indexes. each index return these values. 0 - 1, 2 1 - 2, 3 2 - 3, 4 3 - 4, 5 4 - 5, 6 5 - 6, 0 6 - 0, 1 so 'warriors' have enemies of: soldiers , kings below being current implementation: def state_to_text(self): names = ["kings", "queens", "jacks", "jokers", "masons", "warriors", "soldiers"] if self.state == 0: return str(names[1], names[2]) if self.state == 1: return str(names[2], names[3]) if self.state == 2: return str(names[3], names[4]) if self.state == 3: return str(names[4...
Read more

ruby - Prevent Custom Validation Error on Association -

-
i have app list , email models many many association. want users able add many emails lists @ once, have function in controller split emails custom textfield in new list form "emails" array. i want validation error if it's blank added custom validation on field in lists model: class list < applicationrecord has_and_belongs_to_many :emails #tried adding ", validates: false" here too, didn't work #custom attr_accessor :emails validates :emails, presence: true end it works great, except when try associate existing email list (in case user entered 1 in db), validation error. oddly, can prevent validation error when associating net new emails lists "(validation: false)" seen below, not when email exists already, if add save function , append "validation: false". part of controller in question is: emails.each |email| if email.where(email: email).blank? db_email = email.new( email: email ) db_email...
Read more