Entity Framework 6 - Knowledge Base (KB)
180 results in tag: mysql
Using MySQL with Entity Framework
Can't find anything relevant about Entity Framework/MySQL on Google so I'm hoping someone knows about it.
asked by vintana
How to optimize Entity Framework Queries
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 to change the database - Schema used by Entity Framework (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
Entity Framework with MySQL - Timeout Expired while Generating Model
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 set up a connection string for a MySQL database in a C# project without using 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
Entity Framework - MySQL - Datetime format issue
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
Converting String to Long ...in LINQ to Entity Framework using a MySQL adaptor
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
Deploying applications that use LINQ to Entities
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
Encrypted columns with Entity Framework
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
MySQL with Entity Framework - what am I doing wrong?
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
Arithmetic operation resulted in an overflow
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 use ToString() method to convert an integer to string inside 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 specified data store provider cannot be found
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
best tutorial for using the 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
How to use MySql and Entity Framework 4.1 code first
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
Entity Framework C# Insert Data russian encoding problems
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
Entity Framework Code First + MySQL... NullReferenceException
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
Entity Framework Inserting Initial Data On Rebuild
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
MySQL Entity Framework Error - The specified store provider cannot be found in the configuration, or is not valid
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 Mysql Stored Procedure Parameter not found 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
Page 1 of 9
