All Questions
23
questions
3
votes
1
answer
246
views
Calculating all flight connections
I am working on an API to return all the possible flight route between point A and B. I have a set of data which includes the flight number, airline, departure airport, destination airport, departure ...
5
votes
2
answers
144
views
Combining SQL Tables into One Table in New DB with Similar Fields
I have a SQL Server Database filled with Reports all having the same schema.
What I've done is created a .NET application to automate the process of adding all reports to a new table.
How can the ...
-1
votes
2
answers
92
views
Improving predominance for updating 40000 records using entity framework [closed]
I have Two tables Circuit and Tag,
Circuit
------------------
Id Name Path
Tag
-----------
Id Name Circuit_Id
Now I have to loop through all the tags and ...
1
vote
1
answer
52
views
SQL subquery to determine whether or not a particular row is the first item that matches the subquery
Here is my VB.NET and SQL query (which is one of the things I'm particularly interested in having critiqued):
...
31
votes
6
answers
3k
views
Extensible code to support different HR rules
Recently, I got challenged to code with following bullet points:
Extensible code to support different annual leave rules for HR departments
Maintainable code to add/change the existing rules without ...
2
votes
3
answers
6k
views
Parameterized search query in C#
In the UI I have a single search text box into which users can type a query. The query will split the string and compare each word to each configured column in the database and return the matches.
...
2
votes
0
answers
33
views
Validate User By Comparing against SQL Data
I'm currently building a Windows Form Application using Visual Studio 2015 and the Visual Basic.NET programming language.
On the main form there is a Tab Control and an ActiveX PDf viewer control. ...
2
votes
1
answer
629
views
Disposing of an SQL dataset
I am getting a compiler warning when running my code analysis. It is CA2202. It is saying that I have not properly disposed my dataset through all exception paths. Here is the code:
...
1
vote
1
answer
207
views
Optimise MSSQL Connection .NET Helper Library
I recently posted my old .NET MSSQL Wrapper to be code reviewed: .NET MSSQL Wrapper
I had some good feedback and based on that, I was able to re-factor it quite a bit and ended up with the following ...
9
votes
5
answers
56k
views
Transaction handling for multiple SQL statements
In this code I update two tables called Payment and SalaryTrans. First I insert records (Salary payments) to ...
4
votes
1
answer
2k
views
Data Access Layer method with transaction handling
I just want to know whether I've done transaction handling well. Also what about the other types of transactions available in .NET with regard to this code snippet?
Also are there any redundant ...
10
votes
4
answers
7k
views
Find if value exists using SQL True/False Return
Aim: To Assess if one, or more, examples of a value exists in a Database in the quickest time as I only needs a True/False result.
The variable is Alphanumeric.
Question: Is this the quickest and ...
8
votes
1
answer
3k
views
Fluent Nhibernate
I'm very new to NHibernate and DB. I have three tables which are connected with many to many relationship.
Here are the tables creation Script:
...
1
vote
2
answers
970
views
Exposing WCF Service with dynamic search operation
I have this WCF service providing search functionality - to be used by our client in his web application. There can be any number of search parameters and possible nesting of ...
-1
votes
2
answers
25k
views
Insert to datagridview when SELECT query has WHERE condition [closed]
I use this code to Load and Insert data to a table using a DataGridView in a C# windows application.
...