❔ Csharp equivalent of JPA Stored Procedure Persistence

What is something of an equivalent to the java jpa persistence in c# https://www.baeldung.com/spring-data-jpa-stored-procedures it calls a procedure in my MSSQL server and then it converts them to Persistent Objects. i have not found of an equivalent in c# to call stored procedures+ converting them to objects straight away
12 Replies
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
Joreyk ( IXLLEGACYIXL )
im using mssql 2019 developer edition on sql server 2019 evaluation
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
Joreyk ( IXLLEGACYIXL )
using System.Data.SqlClient; more or less that stuff currently https://www.mssqltips.com/sqlservertip/5771/querying-sql-server-tables-from-net/ so the built in sql library im open for other libraries never used an extra library
Joreyk ( IXLLEGACYIXL )
Stack Overflow
How to execute a stored procedure within C# program
I want to execute this stored procedure from a C# program. I have written the following stored procedure in a SqlServer query window and saved it as stored1: use master go create procedure dbo....
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
Joreyk ( IXLLEGACYIXL )
ahh thanks yes thats what im looking for db.Query<CustomTest>("GetRequestTest".... from https://stackoverflow.com/questions/31333937/dapper-call-stored-procedure-and-map-result-to-class
Unknown User
Unknown User2y ago
Message Not Public
Sign In & Join Server To View
Joreyk ( IXLLEGACYIXL )
ye exactly, i just wanted to confirm that i can directly map it to c# objects
Accord
Accord2y ago
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server