Tagged Questions
1
vote
2answers
240 views
Critique my database design and help me simplify my code
I wish to create a database for a webpage where users are able to add their own events to a timetable. Users will be able to decide if the events should be recurring (weekly) or not. Users should be ...
2
votes
3answers
4k views
How to improve performance in this database connection class?
This is my general database connection class. I am using this class to execute my queries through website. What would your suggestions about this to improve performance. Thank you.
MSSQL 2008 R2 SP1 ...
3
votes
1answer
2k views
asp.net (vb.net): handling of open database connection and calling shared function from web api
I'm working on an ASP.NET project using VB.NET that uses Dapper
and the code as implemented so far runs fine with just me testing.
In the example below, Dapper calls a stored proc.
But my I am ...
1
vote
4answers
933 views
Calling stored procedure with `sqlCommand`
I have the following code as part of an sqlcommand which is calling a stored procedure:
...
