EnsureDeleted in Entity Framework in C# Tip #108 #linq #codingforbeginners #codingbasics #sqlserver #webdevelopment #softwareengineer #visualstudiocode #databases #softwaredeveloper #computerscience #codinglife #sql #learncoding #csharp #dotnet #coding #datascience #learntocode #vscode #visualstudio
#sql
18 posts11 participants4 posts today
Continued thread
Fun fact: #SQL is over 50 years old now.
Do any of the litany of frameworks stay relevant for 50 weeks?
When I was on the bird site, I followed the #SQL hash tag to learn about Structured Query Language, databases, and the like.
I follow #SQL in the Fediverse too.
But here, the vast majority of posts are about frameworks, ORM's, and other tools folks can use so they don't have to learn (or understand) a 4G language that's likely a lot simpler than the other tech complexities they've mastered.
I don't know how we got here.
Why Migrations are needed in Entity Framework in C# Tip #107 #coding #dotnet #csharp #sql #linq #codingforbeginners #codingbasics #sqlserver #webdevelopment #softwareengineer #visualstudiocode #databases #softwaredeveloper #computerscience #codinglife #learncoding #datascience #learntocode #vscode #visualstudio
Seems interesting: Enhanced #SQL error messages facilitate faster error fixing
SpringerLinkEnhanced SQL error messages facilitate faster error fixing - Empirical Software EngineeringError messages are one of the primary ways software developers communicate with database management systems in SQL query writing tasks. Even though reading and interpreting error messages is a significant part of a software developer’s work, the error messages of SQL compilers have received criticism in terms of readability and their perceived detrimental effects on user experience. Consequently, redesigned SQL error messages have also been proposed to tackle the problems in current error messages. In this study, we examine the effects of enhanced error messages on query writing from several perspectives. The results indicate that when compared to PostgreSQL error messages, the enhanced error messages facilitate faster error fixing, as well as perceived benefits in error finding and error recovery confidence. Our results are applicable in industry, where development time is of significant importance, as well as in educational contexts, where user experience, user confidence, and perceived support in learning play an important role.
| R.I.P Natenom 
Starting a Data Science journey?
These 3 skills are your foundation:
Python / R – Programming for data work
SQL – Manage and extract from databases
Statistics – Understand and model your data
Learn Data Science at TCCI in Ahmedabad
Demo of EnsureCreated with Entity Framework C# Tip #106 #codingbasics #codingforbeginners #linq #sqlserver #coding #dotnet #sql #csharp #visualstudio #webdevelopment #softwareengineer #visualstudiocode #vscode #databases #softwaredeveloper #computerscience #learntocode #codinglife #datascience #learncoding
EnsureCreated with Entity Framework C# Tip #105 #codingforbeginners #codinglife #computerscience #databases #linq #sqlserver #coding #vscode #sql #dotnet #softwaredeveloper #visualstudiocode #softwareengineer #learntocode #datascience #webdevelopment #codingbasics #visualstudio #learncoding #csharp
Create table with Entity Framework C# Tip #104 #codingbasics #codingforbeginners #codinglife #computerscience #databases #linq #sqlserver #coding #vscode #dotnet #softwaredeveloper #visualstudiocode #softwareengineer #learntocode #datascience #webdevelopment #sql #visualstudio #learncoding #csharp
Database Migrations and Entity Framework in C# Tip #101 #datascience #dotnet #learncoding #computerscience #codinglife #softwaredeveloper #codingforbeginners #visualstudiocode #softwareengineer #vscode #codingbasics #coding #sql #visualstudio #sqlserver #csharp #databases #learntocode #linq
Remove a column from table manually Entity Framework in C# Tip #100 #visualstudiocode #softwareengineer #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife #softwaredeveloper #vscode #linq #codingbasics #coding #sql #visualstudio #sqlserver #csharp #databases
Using Keyword Explained and Entity Framework in C# Tip #97 #linq #softwaredeveloper #vscode #codingbasics #sqlserver #visualstudio #learntocode #databases #csharp #visualstudiocode #softwareengineer #coding #sql #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife
Database Connections in Entity Framework Core Application in C# Tip #96 #vscode #codingbasics #visualstudio #databases #computerscience #codingforbeginners #learncoding #codinglife #softwareengineer #coding #visualstudiocode #dotnet #softwaredeveloper #sql #datascience #sqlserver #learntocode #csharp #linq
Simple Entity Framework Core Application in C# and VS Code Tip #95 #visualstudiocode #softwareengineer #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife #softwaredeveloper #vscode #linq #codingbasics #coding #sql #visualstudio #sqlserver #csharp #databases
Install Entity Framework in VSCode Project for C# Tip #94 #linq #softwaredeveloper #vscode #codingbasics #sqlserver #visualstudio #learntocode #databases #csharp #visualstudiocode #softwareengineer #coding #sql #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife
Install Entity Framework in VSCode Project for C# Tip #94 #linq #softwaredeveloper #vscode #codingbasics #sqlserver #visualstudio #learntocode #databases #csharp #visualstudiocode #softwareengineer #coding #sql #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife
MySQL Study Plan for Data Analysis #dataanalytics #sql #datascience
Book Free Book Free Call Consultation: www.bepec.in/registration-form. source
https://quadexcel.com/wp/mysql-study-plan-for-data-analysis-dataanalytics-sql-datascience/
QuadExcel.com · MySQL Study Plan for Data Analysis #dataanalytics #sql #datascience - QuadExcel.comBook Free Book Free Call Consultation: www.bepec.in/registration-form. source
Supabase MCP can leak your entire SQL database
｢ The cursor assistant operates the Supabase database with elevated access via the service_role, which bypasses all row-level security (RLS) protections. At the same time, it reads customer-submitted messages as part of its input. If one of those messages contains carefully crafted instructions, the assistant may interpret them as commands and execute SQL unintentionally ｣
https://simonwillison.net/2025/Jul/6/supabase-mcp-lethal-trifecta/
Simon Willison’s WeblogSupabase MCP can leak your entire SQL databaseHere's yet another example of a lethal trifecta attack, where an LLM system combines access to private data, exposure to potentially malicious instructions and a mechanism to communicate data back …
'This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts.'
eric.ed.govERIC - EJ1468081 - Using LEGO® Brick Data to Teach SQL and Relational Database Concepts, Information Systems Education Journal, 2025This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts. This dataset is well-suited for introductory and advanced database assignments and end-of-semester group projects. The data is freely available from Kaggle.com and contains eight tables with 633,250 rows of data on 11,673 LEGO® sets sold between 1950 and 2017. As a guiding example, I introduce an example group project assignment designed to provide students hands-on experience with database management and SQL queries. I also discuss tips, suggestions, and lessons learned from using the data for group projects over the past five years. While LEGO® bricks have been widely used in educational settings, including college and computer classrooms, this is the first work to discuss the use of LEGO® data in a college database course.