letarak

Wrong separator detection inside quotes

1

version 3.6.0 If we have value inside quotes and escaped quotes placed before separator, then parse result would be wrong test case: ``` var csv = @"John,Doe,120 any st.,""\""Anytown\"", WW"",08123";...

DO 7.1.1/7.2.0-Beta-1 Example, see generated sql queries private static async Task Main(string[] args) { try { DbHelper.ExecuteNonQuery("DROP DATABASE [DO-Tests]"); } catch (Exception) { } DbHelper.ExecuteNonQuery("CREATE DATABASE [DO-Tests]"); var currentConnection =...

DO 7.0.3 Fail to execute query that contains > 1 aggregate value by field with link access inside lambda expression Code sample using System.Linq.Expressions; using DoTest; using Microsoft.Data.SqlClient; using Xtensive.Orm;...

Wrong bulk update query

1

DO 7.1.1 Structure inner field bulk update produce wrong sql query, see code sample below ``` private static async Task Main(string[] args) { try { DbHelper.ExecuteNonQuery("DROP DATABASE [DO-Tests]"); } catch...

Session dispose exception

6

DO 7.0 Sorry, can not reproduce in test environment Catch this exception three times ``` System.ArgumentNullException: Value cannot be null. (Parameter 'node') at System.Collections.Generic.LinkedList`1.ValidateNode(LinkedListNode`1 node) at Xtensive.Collections.TopDeque`2.PopBottom() in /_/Orm/Xtensive.Orm/Collections/TopDeque.cs:line 180...

Does DataObject support sql 'date' type?

3

Found this old question https://support.x-tensive.com/question/6369/date-without-time seems to be it is was planned in 5.1.0 'added this to the feature list to implement' Was it done or maybe planned in future...

Do you have plans to add datetime2 precision support?

2

Sometimes, every byte counts And precision 2 vs 7 it is 6 bytes vs 8 bytes

Query translation exception

2

DO 7.0 ``` \\ OK _ = Query.All() .Select(it => Storage.All() .Select(e => e.NullableDateTime ?? DateTime.MinValue) .FirstOrDefault()) .ToArray(); \\ OK _ = Query.All() .Select(it => (Storage.All() .Select(e => e.NullableDateTime) .FirstOrDefault()...

Version 7.0.3 Similar to https://support.x-tensive.com/question/6718/wrong-sql-translation If query try select required link from entity, then INNER JOIN applied But if entity was got by FirstOrDefault inside query, then it is possible...

DO 7.1.1 Sample NB Code without PairTo association throw 'FilterProvider' exception ``` using DoTest; using Microsoft.Data.SqlClient; using Xtensive.Orm; using Xtensive.Orm.Configuration; internal class Program { private static async Task Main(string[] args)...