Entity Framework 6 - Knowledge Base (KB)
180 results in tag: mysql
Using Entity Framework with MySQL
Can't find anything relevant about Entity Framework/MySQL on Google so I'm hoping someone knows about it.
asked by vintana
How to Make Entity Framework Queries Faster
I am using Linq-To-Entities to do a query which is returning only 947 rows but taking 18 seconds to run. I have done a "ToTraceString" to get the underlying sql out and ran the same thing directly on the database and get the same timing. ...I have used th...
asked by Calanus
How can I alter the Entity Framework database schema (mysql database)?
I use EntityFramework in a project to connect to a Mysql database. The provider is Devart Dot.connect....This application needs to connect to a database using connexion parameters given by the user at runtime. This includes of course the Mysql Database na...
asked by pierre
Timeout Expired While Generating Model in Entity Framework with MySQL
I've constructed a database in MySQL and I am attempting to map it out with Entity Framework, but I start running into "GenerateSSDLException"s whenever I try to add more than about 20 tables to the EF context....An exception of type 'Microsoft.Data.Ent...
asked by Nathan Taylor
How do I create a MySQL database connection string in a C# project without utilizing dialog boxes?
NOTE: Apparently, the reason the MySQL connector installation doesn't show up automatically in the Dialog Boxes for adding a data source is because the...Visual 2008 Express Edition...doesn't allow "3rd party integration" within the Visual Studio IDE. So,...
asked by Ben McCormack
Datetime format problem with Entity Framework and MySQL
I have a simple table with few date fields....Whenever I run following query:...var docs = ( from d in base.EntityDataContext.document_reviews select d ).ToList(); ...I get following exception:...Unable to convert MySQL date/time value to System.DateTime....
asked by effkay
LINQ to Entity Framework using a MySQL adapter to convert String to Long
I have a table with a column of type ...varchar... where the majority of rows have numerical looking values, that is, each string contains nothing but the digits 0 through 9....+------+ | n | +------+ | 123 | | 234 | | BLAH | -- This row is an excep...
asked by Walt Stoneburner
LINQ to Entities apps are being deployed.
I want to use L2E since it's very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, let's say, press a button that has some code that uses the entity I get this error:...specified store provider cann...
asked by Luiscencio
Entity Framework has encrypted columns.
Anyone figured out a good way to pull encrypted values from db through entity framework 4?...I got a MySql db with some columns encrypted with des_encrypt and need to be able to get those values as easy as possible, and also of course, update and insert t...
asked by Andreas
What am I doing wrong with MySQL and Entity Framework?
I am completely new to Entity Framework and even ADO.NET in general (don't typically do much work with databases)....I downloaded and installed ...MySQL Connector/NET 6.3.5.......I created a new C# project in Visual Studio 2010....I added a new ADO.NET En...
asked by Dan Tao
An overflow occurred due to an arithmetic operation.
After updating my website on ii7 on window server 2008 from framework 3.5 to work with framework 4 i got my c# base database class stop working copmlitly with this error: "Arithmetic operation resulted in an overflow". I am working with mysql server from ...
asked by cheinan
How to convert an integer to a string using the ToString() function in LINQ
When I try to use ToString() inside the below LINQ Lambda expression, I get an exception saying "LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression." ...query = q...
asked by CHash_Mike
Error 175: The data store provider supplied could not be located.
I'm using VS2010 with the ...MySQL .NET Connector.... My project that used to work started reporting:...Error 175: The specified data store provider cannot be found, or is not valid....I don't know why, though things got weird after a MS recommended hotf...
asked by Walt Stoneburner
The greatest tutorial for utilizing Entity Framework, POCO, and MySQL.
I am looking for a solid tutorial on using the Entity Framework with POCO (ie. not using the designer) using MySQL as the back-end. I am looking for something that is semi-in-depth covering stuff like attributes (like how to map a database table/field na...
asked by ryanzec
First, learn how to utilize MySql and Entity Framework 4.1 code.
I am trying to use MySQL database in MVCMusicStore...http://mvcmusicstore.codeplex.com/... instead of MSSQL.... I would like to learn Code first development with MySQL.... I had added these code to web.config...<connectionStrings> <add name="MusicStoreE...
asked by Dauren
Russian encoding issues in Entity Framework C# Insert Data
I'm using an EDM model in my project....When I insert russian words in the database via a post request I get ...??????...Controller:...[Authorize] [HttpPost] public string DescEdit(FormCollection formValues) { var CurrentUserPhoto = User.Identity.Name...
asked by Evgeniy Labunskiy
NullReferenceException: Entity Framework Code First + MySQL
I need to work with data in a couple of tables in an off site MySQL database we have limited access to and decided to use it as an opportunity to pick up some EFCF experience. No matter what I do i cannot get any data out of the MySQL database. Using MySQ...
asked by Hawxby
On Rebuild, Entity Framework Inserts Initial Data
I am using Entity Framework code-first with a MySQL data source....I've defined ...ContactType.cs... as follows:...public class ContactType { [Key] public int ContactTypeId { get; set; } [Required, StringLength(30)] public string DisplayN...
asked by Jeffrey Kevin Pry
The requested store provider cannot be identified in the configuration or is not valid, according to MySQL Entity Framework Error.
I have written an assembly in C# to perform all data access for a MySQL database. I have successfully used the assembly (a compiled dll) in my C# winform desktop application. But it only works on PCs that have had the "MySQL Connector Net 6.4.4" installed...
asked by Hoody
Why is there no Mysql Stored Procedure Parameter in the collection?
I have problem with entity framework and mysql. I have solved entity framework function parameters problem with ...this answer...But when I want to add some data with mysql stored procedure I have ...Parameter 'kick_Prod_StateID' not found in the collecti...
asked by Bilgehan
