Posts

Showing posts with the label Efcore

EFCore - Parallel Async

This is no longer needed but maybe can be used for real-time example projects. Currently dont have any use for it. https://stackoverflow.com/questions/44063832/what-is-the-best-practice-in-ef-core-for-using-parallel-async-calls-with-an-inje https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/ I've also been moving away from EF in favor for Dapper, still using tasks that might be unless until I write myself an example.

Randomly Return Rows in EFCore with Postgresql

Currently working on a random list motorcycles to display on my front. At the moment don't have any priority listening on my site for clients other than the list of bikes I'm trying to sell personally as a source of income. For now this is what I did and its just these two parts to get things going. something . OrderBy ( r => Guid . NewGuid ()). Take ( 3 ) If you don't already have the extension this command will check and install for you. CREATE EXTENSION IF NOT EXISTS "uuid-ossp" ;

Entity Framework: ToListAynsc & WhereAsync

When upgrading aspnet mvc applications I like to take a look on how I can convert the api's to async. This sometimes is really easy but as things get more complex my queries do as well. So this is a list of ways you can form a where clause on top your  async  but note not all solutions take advantage of it. Notes on EFCore Entity Framework Core provides a set of asynchronous extension methods that can be used as an alternative to the LINQ methods that cause a query to be executed and results returned. Examples include  ToListAsync() ,  ToArrayAsync() ,  SingleAsync() , etc. There are not async versions of LINQ operators such as  Where(...) ,  OrderBy(...) , etc. because these methods only build up the LINQ expression tree and do not cause the query to be executed in the database. https://codereview.stackexchange.com/questions/32160/filtering-a-collection-by-an-async-result Filtering a collection by an async result ,  built an extension method called WhereAsync. publ

PostGreSql and EFcore: Cheatsheet

Rather then writing a separate article on Postgresql and another one with Efcore, I'll place my notes here. I currently only seem myself using it with EFcore and instead using mongodb with nodejs. Redis is still on my list of things to use more extensively in the future. https://wiki.postgresql.org/wiki/First_steps https://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation https://stackoverflow.com/questions/40614466/postgresql-9-5-allow-remote-connections-without-editing-pg-hba-conf-file https://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/ https://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge http://www.postgresqltutorial.com/postgresql-insert/ https://stackoverflow.com/questions/10335561/use-database-name-command-in-postgresql https://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-using-psql https://stacko

Popular posts from this blog

UI-Bootstrap Collapsible Sticky Footer

Installing Windows on Acer chromebook 15 cb3-532

Aspetcore: NLog with Postgresql