Tagged Questions
3
votes
1answer
222 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 ...
0
votes
2answers
192 views
Critique my Database design/help me simplify my C# code please
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 ...
1
vote
4answers
738 views
Calling stored procedure with `sqlCommand`
I have the following code as part of an sqlcommand which is calling a stored procedure:
Dim groupObj
If groupId = 0 Then
groupObj = DBNull.Value
Else
groupObj = groupId
End If
Dim siteObj
...
2
votes
3answers
2k 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 ...
