Tagged Questions
0
votes
2answers
142 views
Mapping a legacy database to ORM using wrapper classes
I want to use an ORM with a legacy database, but I don't want to expose some of the underlying data types. For example, some of the columns are nullable doubles or floats and I want my domain model to ...
-5
votes
2answers
108 views
Where should I keep the central database and which database would be appropriate? [closed]
I am developing a gym software in C# as a window application but need to connect it to a central server so that people can install it on their PC's and connect to the same database. I want to package ...
2
votes
2answers
189 views
Moving from local storage to a remote database: how should I cache the data locally?
I have a .NET (C#) application that I am releasing soon, which also has some support files. Right now I am storing those files as .txt files, and I update them as necessary whenever the application ...
5
votes
1answer
160 views
Entity Framework as a type checking/verification system for database code
When I read pro and con lists of using Entity Framework (or any modern ORM really), I'm surprised that the following point doesn't arise (self quote):
Using strongly-typed domain entities allows ...
2
votes
2answers
314 views
Data representation with C# and WPF
I'm developing an application handling DB parts. I retrieve the data from the DB with stored procedures and prepared statements. Now I want to display the data in the GUI.
What is the current ...
-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 ...
0
votes
1answer
364 views
Increase application performance [closed]
I'm writing a program for a company that will generate a daily report for them. All of the data that they use for this report is stored in a local SQLite database. For this report, the utilize ...
4
votes
6answers
437 views
Should I have a separate method for Update(), Insert(), etc., or have a generic Query() that would be able to handle all of these? [closed]
I'm currently trying to write a class library for a connection to a database. Looking over it, there are several different types of queries: Select From, Update, Insert, etc.
My question is, what ...
7
votes
4answers
630 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 ...
-1
votes
2answers
491 views
Fitting it together, database, reporting, applications in C#
Introduction
Preamble
I was hesitant to post this, since it's an application whose intricate details are defined elsewhere, and answers may not be helpful to others. Within the past few weeks (I was ...
-1
votes
4answers
951 views
Application connecting to database server
I'm working on an application which requires user credentials and so on. So a database is required on the backend.
What is the best practice to connect to a database without hardcoding your password ...
1
vote
2answers
461 views
Generate sequence of string of 4 characters
I'm facing problem with generating character sequence for SMS tracking. there should be a easy to enter code send with all the outgoing messages. Reply SMS will map with that code.
I can't generate ...
0
votes
2answers
591 views
WCF Service in an N-tier Application
Is it recommended to use a WCF Service Library in developing an N-Tier Windows Application? Also is it better to use the VS wizards to create the DataTables and DataSets? And if so should I add all of ...
2
votes
1answer
781 views
Using WCF as an API for Database access by the GUI, or no?
Originally I asked this question on Stackoverflow but I was suggested to move the question here.
I've asked this question a while ago in MSDN forums but I'd like a second opinion from ...
2
votes
2answers
226 views
How would you transfer data between your data structures and databases?
I'm learning programming in school and I have this question that's bugging me about data structures and transferring the information stored inside them to databases. We're doing just small systems - ...
