<div>
thank you. as a sidenote, good, bad or indifferent, can you have a primary key that is a character string?
</div>


thank you. as a sidenote, good, bad or indifferent, can you have a primary key that is a character string?

<div>
Absolutely! &nbsp;But if it's longer than 16 bytes, I'd reconsider (for optimization reasons).
</div>


Absolutely!  But if it's longer than 16 bytes, I'd reconsider (for optimization reasons).

<div>
<div class="content wysiwyg-content">
i'm having trouble creating a one to many foreign key relationship between two InnoDB tables that I have created in my MySQL db using the workbench IDE. I'm using this in conjuction with vs 2010 and the entity framework. so i'm looking for some visual aids (tutorials preferably) that address this and show me the proper way to achieve this. Any suggestions and or suggested resources would be appreciated.
</div>
</div>


i'm having trouble creating a one to many foreign key relationship between two InnoDB tables that I have created in my MySQL db using the workbench IDE. I'm using this in conjuction with vs 2010 and the entity framework. so i'm looking for some visual aids (tutorials preferably) that address this and show me the proper way to achieve this. Any suggestions and or suggested resources would be appreciated.

FK relationship in MySQL in WorkBench IDE

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications