zzz projects Entity Framework 6 EF 6
Home EF Core 5 Articles Knowledge Base Online Examples
  • Home
  • EF Core 5
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

180 results for: 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.
.net ado.net entity-framework mysql
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...
entity-framework mysql performance
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...
c# connection database entity-framework mysql
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...
edmgen entity-framework mysql
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,...
.net c# datasource entity-framework mysql
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....
entity entity-framework mysql
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...
entity-framework linq linq-to-entities mysql type-conversion
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...
c# entity-framework linq-to-entities mysql winforms
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...
c# encryption entity entity-framework mysql
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...
.net entity-framework mysql nullreferenceexception visual-studio-2010
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 ...
asp.net entity-framework mysql
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...
c# entity entity-framework linq mysql
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...
.net dataprovider entity-framework mysql visual-studio-2010
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...
asp.net-mvc c# entity-framework mysql
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...
code-first entity-framework mysql
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...
asp.net-mvc c# entity-framework mysql
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...
asp.net-4.0 c# entity-framework mysql
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...
c# entity-framework mysql
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...
c# entity-framework mysql
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...
c# entity-framework mysql stored-procedures
asked by Bilgehan

Page 1 of 9
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now