Tagged Questions
0
votes
0answers
16 views
Wise way to implement a website login and database tables for a small shop [duplicate]
Im building this website for a small store and i was told that its better not to keep the login and the rest of the users information on the same table.
Now im wondering, what is the best way to ...
0
votes
0answers
37 views
T-SQL Issues With Defining 'AS' [migrated]
I am creating a fully dynamic application but have ran into a bit of a hiccup. There are multiple 'undefined' fields that can be defined by the users. The only problem is redisplaying them. Currently ...
4
votes
1answer
150 views
Algorithm to denormalize database
I have built a QlikView script generator (QVS), that can be used to generate large script files for data imports from SQL Server to QlikView.
QlikView does not like 'fully' normalised database ...
0
votes
1answer
106 views
Concurrency checking with Last Change Time
I have an app with the following three tables
Email (emailNumber, Address)
Recipients (reportNumber, emailNumber, lastChangeTime, status)
Report (reportNumber, reportName)
I have a C# application ...
-1
votes
1answer
133 views
Address search from large text file
Basically I want to develop a Address lookup(part of my project) using C# (and I can use SQL if necessary). I have a very large text file which have all the UK address and postcodes. Addresses needs ...
-1
votes
1answer
191 views
keeping connection open all time in sql
I have developed a Windows application in c# in which multiple users can add some numbers and their name and can view the data entered. The problem that I have is that the sever is on my laptop and ...
7
votes
4answers
629 views
Best C# database communication technique
A few days ago, I read an answer stating that writing queries within your c# code are long gone.
I'm not sure what the specific person meant with the comment but, it got me thinking. At the company ...
4
votes
2answers
248 views
Proper Data Structure for Commentable Comments
Been struggling with this on an architectural level.
I have an object which can be commented on, let's call it a Post. Every post has a unique ID.
Now I want to comment on that Post, and I can use ...
-2
votes
2answers
105 views
Proper Method name for XML builder [closed]
I think this is the right stack for this.
I have a helper class which builds CAML queries (SharePoint XML for getting list items from SQL)
There is one method that is flexibly used to build the ...
4
votes
3answers
273 views
Appropriate use of SQL CLR
We have some back end processes that runs* on our sql server (SQL Server), they involve processing claims. This requires both data manipulation (biz logic) and data read/write to tables. The biz ...
2
votes
1answer
435 views
Best way to remove list items from an existing record
Ok more of a conceptual question here:
Say I have an existing record of type Meeting. When I go to edit the meeting I have a listbox with all current meeting participants, and one with all employees. ...
0
votes
1answer
615 views
Database Driven Web Application, C# Front-End and F# Back-End meaning
Hi I am an intern working with ASP.NET.
My current task is to make a website which will incorporate some jquery viewing features. This project seems to me will be primarily dealing with reading data ...
-1
votes
1answer
233 views
what is the best way to implement a multiplayer match making system in ASP.net/C# [closed]
OK I am going to try to make this as simple as possible. This is what I have:
an asp.net/c# website
a MSSQL DB
a table on the DB with user information (user ID, username, arbitrary user rating)
Now ...
2
votes
1answer
355 views
Sanity of design for my in-memory object representations of database rows
I've been trying to revise the structural design of the C#.NET-based system I'm currently working on. The new design involves a rather light-weight object-relational mapping framework (we're trying ...
0
votes
2answers
211 views
How to solve a fundamental cloud data storage dispute?
I'm working for a company that has recently hired me to create a new version of their existing software, which is now over 12 years old. The new software is a complete re-write of the old and they ...
