score:3
These parts of the stack trace:
MySql.Data.Entity.EFMySqlDataReader.ChangeType(Object sourceValue, Type targetType) +566 MySql.Data.Entity.EFMySqlDataReader.GetValue(Int32 ordinal) +231 System.Data.Common.Internal.Materialization.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal) +215 System.Data.Common.Internal.Materialization.Shaper.GetPropertyValueWithErrorHandling(Int32 ordinal, String propertyName, String typeName) +68 lambda_method(Closure , Shaper ) +1088 System.Data.Common.Internal.Materialization.Shaper.HandleEntityAppendOnly(Func`2 constructEntityDelegate, EntityKey entityKey, EntitySet entitySet) +218 lambda_method(Closure , Shaper ) +291
suggest that the MySQL Linq provider is having problems with some of your data - if looks like there's a field which in your object model is defined as an int, but the corresponding data in the database isn't represented as an integer.
Without knowing more about your database and how you set up your Entity Framework model, I couldn't say exactly what the problem is.
Source: stackoverflow.com
Related Query
- Why is there an input string exception for a query without where clause?
- Why Same where clause need to write multiple times in a Linq Query for following SQL
- Is there any way to create a LINQ query as a variable without having the data source (yet)?
- Is there any default order in which where clause in LINQ query filters sequence
- How to query by where clause with EF code first
- LINQ Where clause throws casting exception from string to Guid even though comparison only contains Guids
- Query for selecting and anonymous object with where clause
- How can I check for null values in this linq query where clause
- Try to achieve EXIST in Linq, but Any() in where clause for Nested Query takes forever to process
- Build string for Linq WHERE clause depending on multiple checkbox choices
- Why the extension method of where for LINQ in this code would print out a single number while it shouldn't print anything at all?
- Why can't I use dictionary["key"] for a where clause in LINQ?
- Reusable LINQ query except for where clause
- Why StringComparison.InvariantCultureIgnoreCase throws exception in where clause
- Linq query for Where on the Joined table without needing join
- Linq query with string array in where clause
- Conditional Where clause in Linq query for specific cases
- dynamic query in where clause for linq using c#
- Using a string where clause with PredicateBuilder in LinqPad for creating dynamic where clause
- Why is the Where clause in this LINQ Query not appending?
- How to execute a linq query for each item in a list , use it in the where clause and return a collection from the result of each query?
- Is there a way that I can add a string containing a LINQ where clause to a list?
- Select multiple object in one query on a different where clause for each object
- How do I add a where clause to a field that is not part of the return set for LINQ query
- How to escape string for dynamic linq where clause
- vb.net linq where clause for mutiple search filter - same query but different where clause
- where Clause in Asp.net is returning null exception in the code below
- Is there a LINQ function for getting the longest string in a list of strings?
- Why there is two completely different version of Reverse for List and IEnumerable?
- Could not find an implementation of the query pattern for source type 'System.Data.Entity.DbSet'
More Query from same tag
- Merging two IQueryables into a Dictionary with LINQ
- Find the closest DateTime key in Dictionary<DateTime, double>
- DataGrid doesn't refresh after adding new data from another view WPF C#
- Find all subsets with Enumerable.Zip or bitwise AND logic
- Get indexes for intersection
- Filtering a list based on another list - LINQ
- Equivalent of INNER JOIN ... WHERE in NHibernate
- linq groupby question
- How to use one C# expression inside another C# expression for Entity Framework?
- Take pages and combine to list of pages
- Quickest way to do a [adsisearcher] and store in a hashtable or dictionary collection list
- How to Implement search method for db records with multiple filters using lambda expressions
- How to check record exists in group by subquery in linq to sql
- Create tree hierarchy in JSON with LINQ
- How to get items that were effective within a date range in linq
- Finding parent collection by filtering collection of complex type using LINQ
- Lambda function with two input parameter in linq Select clause
- copy user's selected items of one list to another by index
- Simple Linq to List(of T)
- Linq to Sql database query
- LINQ to SQL with JOIN, GROUP BY, HAVING and MAX
- Use Linq Expression object inside and outside query
- Linq - Get all keys from dictionary where all values in the value list are equal to criteria
- Retrieving records by collection IDs, LINQ
- LINQ count items created before or the same day past X days
- Deleting selected relations in many-to-many relationship in EF?
- Count total sum of the same product name in my ASP.NET MVC Project
- Nested LiNQ to XML
- Can I load hierarchical data with Entity Framework 4 using ".Include" and filter a Navigation Property based on some criteria
- Selecting all XML elements and their values dynamically using LINQ
