sqlite, decimal and non-US locale - System.FormatException: Input string was not in a correct format

[avestnik]

when I query decimal non-0 value from sqlite under non-US (Cyrillic to be specific, with comma as decimal separator) I get an exception: System.FormatException: Input string was not in a correct format. looks like there is a disagreement somewhere inside EF about what format to use during query and parsing

SELECT "q"."SalesWeight" FROM "Questions" AS "q" [I got it from ILogger]

An exception occurred in the data store while iterating the results of a query.
System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)
at System.Decimal.Parse(String s)
at Microsoft.Data.SQLite.Utilities.SQLiteTypeMap.<>c__DisplayClass252.<Add>b__27(Object o) at Microsoft.Data.SQLite.Utilities.SQLiteTypeMap.FromInterop(Object value) at Microsoft.Data.SQLite.SQLiteDataReader.GetValue(Int32 ordinal) at Microsoft.Data.SQLite.SQLiteDataReader.GetValues(Object[] values) at Microsoft.Data.Entity.Relational.RelationalObjectArrayValueReader.CreateBuffer(DbDataReader dataReader) at Microsoft.Data.Entity.Relational.RelationalObjectArrayValueReader..ctor(DbDataReader dataReader) at Microsoft.Data.Entity.Relational.RelationalObjectArrayValueReaderFactory.Create(DbDataReader dataReader) at Microsoft.Data.Entity.Relational.Query.RelationalQueryModelVisitor.CreateEntity[TEntity](IQuerySource querySource, QueryContext queryContext, QuerySourceScope parentQuerySourceScope, DbDataReader dataReader, Int32 readerOffset, IEntityType entityType) at lambda_method(Closure , DbDataReader ) at Microsoft.Data.Entity.Relational.Query.AsyncQueryingEnumerable1.AsyncEnumerator.d__1.MoveNext()

[ErikEJ]

Could you share your model and context code?

[avestnik]

it is a part of a quite big project. I will prepare repro over couple of days

[avestnik]

using Microsoft.Data.Entity;
using Microsoft.Data.Entity.Metadata;
using System.Linq;

namespace Console
{
    public class LocalContext : DbContext
    {
        public LocalContext(DbContextOptions options)
            : base(options)
        {
        }

        public DbSet<Question> Questions { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Question>().Key(q => q.QuestionId);
        }
    }
    public class Question
    {
        public int QuestionId { get; set; }
        public string Name { get; set; }
        public decimal SalesWeight { get; set; }
    }

    class Program
    {
        static void Main(string[] args)
        {
            DbContextOptions options = new DbContextOptions();
            options.UseSQLite("Filename=c:\\temp\\Questions.db");

            LocalContext context = new LocalContext(options);
       //     context.Database.EnsureDeleted();
            context.Database.EnsureCreated();

            var id = context.Questions.Max(q1 => q1.QuestionId) + 1;

            var q = new Question { QuestionId = id, Name = "Name", SalesWeight = 1.5m };
            context.Add(q);
            context.SaveChanges();

            var qs = context.Questions.ToList();
        }
    }
}

[ErikEJ]

That was quick, the good news are that test in DataCommon.SQLite fails with a similar error

[ErikEJ]

@dbis01 Pull request submitted aspnet/Microsoft.Data.Sqlite#59

[bricelam]

@dbis01 Is this fixed in the latest bits?

[avestnik]

Yes! Thanks a lot

[bricelam]

Thank you, @ErikEJ. I just typed git push 😉

[ErikEJ]

@bricelam Easy for you!