Hi everyone, a newbie question about Npsql 5.0.0
I'm following this tutorial here: http://zetcode.com/csharp/postgresql/ and just using the most basic example where I have a hardcoded connection string and want to print out the version of my local postgres DB.
The program runs successfully if I use
5.0.0-preview1 but fails when I use
5.0.0 with this "Unhandled exception. System.TypeInitializationException: The type initializer for 'Npgsql.TypeMapping.GlobalTypeMapper' threw an exception. ---> System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types." error - could someone please point me in the right direction? How should I configure my connection string for Npsql 5.0.0? thank you very much!
Hey there. We've updated from EFCore 2.6 -> 3.1 -> 5.0 recently (mid update to 3.1 we decided to go to 5.0 directly, so till running 2.6 in prod) and in the jump from 3.1 -> 5.0, I got this diff in my OnModelCreating (DB-first approach)
I tried google for info but didn't find anything helpful. Anyone that could fill me in on what this means? Anything I need to test somehow on the prod server?
Hi All, its my first time here in the Group,
I have question about replicating data into two different tables
Consider this example
I am getting some BookingData from one of the api as json => I am saving the data in the Table1 as
Id - Pk Bigint
UniqueID- unique string value
data - jsonb
these data I need to sent to other parties I can simply dump json and sent to others
Also once step completed I need these data need to be filtered from my UI application, which meanas i need to use normalized tables
Table2, Table3, Table4 with Pk-FK tables
question is it okay to write the data into diffrent places in tow different formats, so that my read or UI/API can be much easy to have complete filters
do I need to live with single table normalize all data, when you send again group together and sent to othres..
tell me whihc is option is good?
for me writing two places, so that UI/others can rely on the data..
select tbl1.*, array_agg(tbl2) from tbl1 left join tbl2 on tbl1.id = tbl2.tbl1_id group by tbl1.idcan be used to list all tbl1 items including all tbl2 items belonging to a tbl1 item