ORM vs Stored Procedures : Which one to use ?

preview_player
Показать описание
ORM (Object Relational Mapper) vs Stored Procedures : Which one to use in Software Engineering?
The video discusses pro and cons between using ORM (E.g., Entity Framework, NHibernate ) and Stored Procedures

0:00 - What is ORM and Stored Procedures
1:18 - Benefits of Stored procedures
2:13 - What are the benefits of ORMs
4:22 - ORM vs Stored Procedure - Which one to choose

My Social Links
1. Twitter
2.Linked In
3.Blog

Subscribe to this channel for your regular updates by clicking the following link
  1. Vikas Kerni's Software Architecture Channel
  2. OBJECT Relations Mapper vs Sto
  3. software development
  4. entity framework
  5. Entityf
  6. Entity framework vs Stored Procedures
Рекомендации по теме
ORM vs Stored 0:05:30

ORM vs Stored Procedures : Which one to use ?

DONT USE AN 0:25:46

DONT USE AN ORM | Prime Reacts

Stored Procedures are 0:07:58

Stored Procedures are Better than Raw SQL

SQL vs ORM 0:00:39

SQL vs ORM - Which One To Choose For Database Interaction

Advanced SQL Tutorial 0:06:15

Advanced SQL Tutorial | Stored Procedures + Use Cases

Entity framework Vs 0:38:36

Entity framework Vs Dapper Vs Stored Procedure

Entity Framework vs 0:01:40

Entity Framework vs LINQ to SQL vs ADO.NET with Stored Procedures: A Comparative Guide

SQL Stored Procedures 0:44:34

SQL Stored Procedures - What They Are, Best Practices, Security, and More...

Is your ORM 0:04:01

Is your ORM vulnerable to SQL Injection?

Stored Procedure, ORM, 0:05:28

Stored Procedure, ORM, NoSQL

SQL : Using 0:01:29

SQL : Using ORM with stored procedures, a contradiction?

[preferencia] ORM VS 0:07:12

[preferencia] ORM VS views, procedure & functions

ORM's vs raw 0:07:52

ORM's vs raw SQL queries and when to use what?

Mapping Stored Procedure 0:25:13

Mapping Stored Procedure Parameter with Dapper ORM In MVC 5

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Software Engineering: Stored 0:03:02

Software Engineering: Stored procedures or ORM in web? (3 Solutions!!)

Object-Relational Mapping (ORM) 0:00:59

Object-Relational Mapping (ORM) explained for EVERYONE 🚀 with .NET 7, C# & Entity Framework

SA: Better way 0:27:57

SA: Better way to use SQL Server stored procedures and functions in VBA

Software Engineering: When 0:02:02

Software Engineering: When not to use ORM and prefer stored procedures? (2 Solutions!!)

Django : What 0:01:42

Django : What is the best way to access stored procedures in Django's ORM

ORMs and the 0:38:13

ORMs and the DBA: How to Keep Both Happy - Dan Mallott

The Best ORM 0:01:14

The Best ORM for C# and SQL

ORM Tools Are 0:05:34

ORM Tools Are Great But...

ORM vs SQL 0:28:10

ORM vs SQL ¿Cuándo usar cada uno? 🤔

Комментарии
Автор

Subscribe to this channel for your regular updates by clicking the following link

softwarearchitecturematter
Автор

I like the Store procedure Approach where we can easily establish a relationship between tables + performing better when we insert a large amount of data using XML + easy to deploy. I found the only drawback is unit testing.

ajitsaharan
Автор

Thank you for this video. It was really insightful

dowoyele
Автор

Hi Vikas. I love the video. Thanks for sharing

shekhardalvi
Автор

been 20 years building database driven application using java + oracle. I found that an app instilled with ORM ended up being a horrible nightmare. stored procedure is way much better in most aspect.

rayvid
Автор

Hi Vikas. I love the video. Very nice comparison.

I’m actually torn between the two. I had someone build an application for me using raw SQL queries via SQLAlchemy and then pass the result to Pandas. Now I’m having a different developer refactor the code to use the django ORM. As a non-developer, I’m not sure what is best for this application. Performance is not critical though the application should be robust. I do plan for the application to evolve considerably. I’m also concerned about finding developers in the future that can pick up up the code and work with it. Any guidance would be appreciated my friend.

kamildobrowolski
Автор

Complex queries can only be written in views and stored procedurs. So Sps are best. Big no to ORM

saimch.
Автор

ORM is a better solution overall I Believe.
1- Fast and continuous delivery
2 - Code versioning

FaizanPinjari
Автор

ORM.
project maintainable is first.
Performance is second.

santhoshm