SasukeVita
SasukeVita
Temporary Fix: https://github.com/linq2db/linq2db/blob/19134a465471211c8cb78a121d4b73b75d546d6c/Source/LinqToDB.Templates/LinqToDB.ttinclude#L96 ```C# where GenerateSchemaAsType && p.Schema != null && !p.IsDefaultSchema && !schemas.ContainsKey(p.Schema.Trim('"')) ``` https://github.com/linq2db/linq2db/blob/19134a465471211c8cb78a121d4b73b75d546d6c/Source/LinqToDB.Templates/LinqToDB.ttinclude#L205-L209 ```C# var schema = t.Schema != null && schemas.ContainsKey(t.Schema.Trim('"')) ? schemas[t.Schema.Trim('"')] : null; if...
temporary workaround, make function overloading then cast to original param ```sql CREATE OR REPLACE FUNCTION "Member"."fnTest2"(input1 integer, input2 integer) RETURNS smallint LANGUAGE sql AS $function$ SELECT "Member"."fnTest2"(input1, input2::smallint); $function$ ;...
its not just smallint, other type data may need cast too ex: DLL ```sql CREATE OR REPLACE FUNCTION "Member"."fnTest3"(input_var date) RETURNS integer LANGUAGE sql AS $function$ SELECT 1; $function$ ;...
> > > That's quite hard to decide how to fix it and postgresql [documentation](https://www.postgresql.org/docs/current/typeconv.html) doesn't help much here... I think for now I will just add type hint (::smallint)...
to store generated query from raw sql which return only 1 column, then execute later at same time with other query i see the sample: https://linq2db.github.io/api/LinqToDB.Sql.html#LinqToDB_Sql_AliasExpr ```c# db.FromSql($"select 1 as...
```c# var q1 = db.FromSqlScalar($"SELECT 1"); //or db.FromSql($"SELECT 1"); not work var q3 = (from x in db.Table1 where q1.Contains(x.Value1) select x); q3.ToArray(); //not work ``` Error: Npgsql.PostgresException: '42883: operator...
btw the row count is work fine ```c# var f1 = db.FromSql("SELECT 1").Any(); var f2 = db.FromSql("SELECT 1 LIMIT 0").Any(); var f3 = db.FromSql("SELECT 1").Count(); ```
btw i test this using ef6, im not using core yet, hope will be fixed for ef6 too
This is the first time i was migrating our project from sql server to postgre. In sql server there is tinyint as byte in C#. In postgre there is no...
thanks for workaround got this worked too ```C# var query = (from x in db.TableName join y in db.TableStatus on x.Id equals y.StatusId into z from status in z.DefaultIfEmpty() select...