Explore tweets tagged as #sqlquery
Looking like Entity Framework Core and .SqlQuery is my new go-to for data access. Faster performance than Dapper (according to my unofficial benchmark) and way easier. Just a hair slower than raw ADONET access. DbContext is minimal.
8
10
118
Dapper and Entity Framework Core SqlQuery jockeying for king of speed BenchmarkDotNet is included by default in the latest versions of LINQPad which makes it stupid easy to benchmark code While Dapper once claimed the performance crown other options are investing in
7
7
85
34
6
59
How EF Core became closer to Dapper? One feature made this happen, and it's: Raw SQL queries for unmapped types. From now on, your queries can return any mappable type without including it in the EF model. The recommended method to use for this feature is SqlQuery<T> for
2
18
95
*Transforming Data: Enrichment & Cleaning Magic* Tools: SQL server & MsExcel Unlock the full potential of your data with Excel and SQL Server's powerful tools #dataenrichment
#datacleaning
#datawrangling
#databasemanagement
#sqlquery
#microsoftexcel
#sqlserver
#dataexpert
0
6
17
0
42
222
Day 11 #20dayswithdata SQL Basics I wrote a SQL query to retrieve all the Columns from a Bikeshare dataset Table. #hertechtrailacademy #HTTDataChallenge #SQLBasic #SQLQuery #BigQuery
@phaibooboo
0
2
3
It's Saturday Let's talk SQL #databasemanagement
#sqlquery
#dataanalyst
#dataprofessional
#dataexpert
#dataanalyticstrainer
#techtrainer
0
2
9
EF Core 8 examples for SqlQuery 🔹(No stored procedures, no SQL injection issues) 🔹After running inspect logs under the app folder 🔹 Two databases, two DbContext https://t.co/nyDp1J2JDf
#efcore #efcore8 #efpowertools #csharp #sqlserver
3
6
51
With EF8, you can compose raw SQL queries and LINQ. The SqlQuery method returns an IQueryable, meaning you can call any LINQ method. The resulting SQL will be a nested query, which isn't ideal. However, the database can optimize this. What do you think about this EF feature?
5
16
135
Several days ago I posted a question to what was wrong with a method using EF Core SqlQueryRaw where the solution was to use SqlQuery. At least one person asked about using a stored procedure. I did not include an example for a stored procedure but its easy, create the stored
0
0
42
RoadMap to Learn SQL . . . . . . . . . #SQL #Database #SQLServer #MySQL #PostgreSQL #DataAnalytics #SQLQuery #DataScience #DatabaseManagement #SQLTips #Programming #Code #DataEngineer #Tech #SoftwareDevelopment #SQLPerformance #BackendDevelopment #CloudComputing #SQLTutorial
0
0
5
This question was asked in a #PwC Interview, Here's my solution #sqlskills #sqlquery #sqllearning #sqlmastery #flights #origin #destination #databasequeries #dataretrieval
0
0
0
#day60 "📊 SQL Challenge: Find all workers with the letter 'a' in their first name! 🔍 #DataEngineering #SQLQuery #DataAnalysis #StrataScratch #100daysofcodechallenge
0
0
16
Day 11 #20dayswithdata SQL query to retrieve all columns from different tables. #SQLBasics
#SQLQuery.
0
0
4
0
1
2
Day 7 of #LeetCode SQL 50 👨💻 Problem: Customers Who Never Order #100DaysOfCode #SQLChallenge #LearnInPublic #CodeNewbie #DevJourney #DataWithSQL #TechTwitter #DatabaseDesign #SQLQuery #WomenWhoCode #DataScience #DataAnalytics #SQLforDevelopers #DailySQL
1
0
13
How to calculate Month On Month Sales pct Change using SQL. Similar idea can be applied for Year, Quarter , Weeks anytime frame really. #InterviewQuestion #SQL #Programming #DataAnalysis #SQLQuery
0
0
1