npgsql/npgsql

Npgsql is the .NET data provider for Postgresql. It allows any program developed for .NET framework to access a Postgresql database server. It is implemented in 100% C# code. Postgresql versions since 9.0 are officially supported, others may work.

Alberto Passalacqua

@AlbertoPa

hmm is the syntax of that query as you have it in the code?

Amit Hansda

@amitHansda

@AlbertoPa yes, correct

Alberto Passalacqua

@AlbertoPa

ok, just asking in case you typed it here...

shouldn't it be x => x ....

Amit Hansda

@amitHansda

@AlbertoPa Sorry typo there..Corrected it. As I mentioned nothing getting returned here. If I exclude Where clause I see the value in query result

Alberto Passalacqua

@AlbertoPa

so you want all users where the alias contains that string :-?

Amit Hansda

@amitHansda

@AlbertoPa Yes, and I am using EF Core

AlbertoPa @AlbertoPa tries

Alberto Passalacqua

@AlbertoPa

What about:

var usersWithAliasSomeValue = dbContext.Users.Where(u => u.Aliases.Contains("somevalue")).ToList();

I assume Aliases is a list of strings?

Amit Hansda

@amitHansda

What about:

var usersWithAliasSomeValue = dbContext.Users.Where(u => u.Aliases.Contains("somevalue")).ToList();

Nope, does not work. Am I missing any using statement specific to npgsql?

Alberto Passalacqua

@AlbertoPa

if you miss a using statement, it would not compile

does not work as in? empty result?

Amit Hansda

@amitHansda

Yes. No result

[]

Alberto Passalacqua

@AlbertoPa

and Aliases is a list of strings?

Amit Hansda

@amitHansda

@AlbertoPa Yes, Aliases is a list of string, The table get successfully created in database with Aliases column type text[]


        public class User{
            public int Id { get; set; }
            public string Username{get;set;}
            public List<string> Aliases {get;set;}
        }

Alberto Passalacqua

@AlbertoPa

Take a look at the suggested queries: https://www.npgsql.org/efcore/mapping/array.html

Amit Hansda

@amitHansda

@AlbertoPa Basically trying the simple thing this document mentions https://www.npgsql.org/efcore/mapping/array.html

Alberto Passalacqua

@AlbertoPa

ah ok, sorry for linking then :-)

hmm

Amit Hansda

@amitHansda

@AlbertoPa As the document suggest the equivalent query works on pgsql query tool

select * from "Users" Where 'somevalue' = ANY("Aliases")

Alberto Passalacqua

@AlbertoPa

yep

I guess I would test if it can find one user with a given alias to see what goes wrong

Alberto Passalacqua

@AlbertoPa

(bypassing where)

Amit Hansda

@amitHansda

Hi Guys,
Got a question. I have a column having type as text[], while storing data I am facing no problem. but while querying its not returning anything. e.g.
var query = dbContext.Users.Where(x=>x.Aliases.Contains("somevalue")).Select(a=>a);

Solved!! Upgraded to 5.0.0-rc1

dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 5.0.0-rc1

Thanks @AlbertoPa for your time :)

Alberto Passalacqua

@AlbertoPa

ohhh

you really don't need that "select" :P

you want a list, so a ToList(); is probably a better idea

Amit Hansda

@amitHansda

@AlbertoPa Yeah

Filip Makowski

@fmakowski

Hey! I have a question regarding JsonDocument.GetProperty(string) method, which doesn't seem to exist even though it is used in the API reference

unfortunately using RootElement leads to The LINQ expression could not be translated

of course I can solve that by adding AsEnumerable() before where, but that kind of defeats the purpose

using JsonElement instead of JsonDocument as a property type for a column doesn't solve that either

what am I doing wrong? any advice?

Filip Makowski

@fmakowski

obviously I can make POCO out of those JsonDocuments, but I have to admit, I think this is quite limiting

Filip Makowski

@fmakowski

removing reference to Newtonsoft.Json is not helping either

Emill

@Emill

@roji do you have some quick start guide to set up the dev environment?

I get this:

1>C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\Bin\Microsoft.Common.CurrentVersion.targets(1175,5): error MSB3644: The reference assemblies for .NETFramework,Version=v5.0 were not found. To resolve this, install the Developer Pack (SDK/Targeting Pack) for this framework version or retarget your application. You can download .NET Framework Developer Packs at https://aka.ms/msbuild/developerpacks

but I'm not sure which one to download

Emill

@Emill

nevermind got it working by installing VS 2019 Preview 3

Shay Rojansky

@roji

@fmakowski yeah, as discussed in npgsql/doc#58 are incorrect - GetProperty is a method on JsonElement, so you need to call JsonDocument.RootElement. But you're saying you have issues using JsonElement too?

jberzy

@jberzy

@Brar Hi, are you still planning to ship replication in the 5.0 timeframe?

Skeferstat

@Skeferstat

Hi, I get an exception

Detail = "Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information."

How I can enable this? I Use asp.net core. Thanks!

Yoh Deadfall

@YohDeadfall

@Skeferstat, the exception already point you what you should do: add Include Error Detail=true to the connection string.

pm64

@pm64

Is there an issue with EDB Stack Builder right now? Have tried running it several times today .. it hangs on "Connecting to server..." when initiating the Language Pack download.

2 replies

Shay Rojansky

@roji

@jberzy yeah, that is the plan - though we're definitely cutting it very short :)

jberzy

@jberzy

@roji fingers crossed. Let me know if I can be of any assistance with testing. Thanks

Shay Rojansky

@roji

@jberzy will do. Please follow npgsql/npgsql#1520 and post there.

Where communities thrive

People

Repo info

Activity