❔ 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•3y ago
Message Not Public
Sign In & Join Server To View
im using mssql 2019 developer edition on sql server 2019 evaluation
Unknown User•3y ago
Message Not Public
Sign In & Join Server To View
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 libraryand that https://stackoverflow.com/questions/1260952/how-to-execute-a-stored-procedure-within-c-sharp-program but i want the persistence to c# objects directly
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•3y ago
Message Not Public
Sign In & Join Server To View
oke
Unknown User•3y ago
Message Not Public
Sign In & Join Server To View
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-classUnknown User•3y ago
Message Not Public
Sign In & Join Server To View
ye exactly, i just wanted to confirm that i can directly map it to c# objects
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.