Tagged Questions
0
votes
2answers
67 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
73 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 ...
-1
votes
0answers
18 views
Delete Db element with EntityFrameWork [migrated]
I'm trying to implement a method that delete a element of a DB table.
The doesn't get any exception but the running code, the element still exists inside the table.
namespace SuitTest_tt_content_2
...
2
votes
2answers
82 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 - ...
1
vote
5answers
261 views
An XML file or Database?
I am re-writing a section of my site and am trying to decide how much of a rewrite this will be. At the moment I have a web service feed that generates an xml once per day. I then use this xml file on ...
4
votes
2answers
167 views
Storing data for use on Android and Windows Applications
I posted this last night on StackOverflow and was advised to move it over to StackExchange, thank you for taking a moment to look at my question.
I'm developing a project proposal for my final year ...
2
votes
1answer
97 views
How to deal with transactions when creating a database connection for each query
In line with this post here I am going to change my website to create a connection per query to take advantage of .NET's connection pooling. With this in mind, I don't know how I should deal with ...
6
votes
2answers
369 views
Creating database connections - Do it once or for each query?
At the moment I create a database connection when my web page is first loaded. I then process the page and run any queries against that conection. Is this the best way to do it or should I be creating ...
4
votes
4answers
699 views
Business Objects within a Data Access Layer
So I've been creating a data access layer via TDD and have approached somewhat of a concern. I'd rather not start down the wrong path, so I figured I'd ask you guys to see if my thoughts were in line ...
2
votes
1answer
200 views
Object orientated data structures in database driven applications
I've started working for a company that maintains a small/medium sized commercial website. The website is written in c# asp.net, and uses SQL Server as a database. The structure of the code is very ...
0
votes
2answers
102 views
Is hooking Data access method on wrong object detrimental for a developer
In a simple application I am creating there are Admin and users where admin can create users. Right now I am creating Classes that encapsulate database CRUD calls with methods.
For example: ...
6
votes
3answers
398 views
Best algorithm/practice when creating a search mechanism for your database?
I have been designing a database where it is very important to provide users with a good search mechanism. So I was wondering what some of the best practices are for using keywords to search over ...
0
votes
1answer
183 views
difference between Visual Studio and RADs?
What is the main difference between a Rapid Application Development tool like MonoDev and Visual Studio, is an RAD more focused on one thing? I'm looking to make a web application, are there ...
1
vote
2answers
298 views
Best practice to save data in different databases using C# ADO.NET
I would like to know if you guys have any best practice when dealing with transaction between different databases vendors.
For example, if you have a C# application that save customer data in two ...
8
votes
6answers
1k views
How to suggest using an ORM instead of stored procedures?
I work at a company that only uses stored procedures for all data access, which makes it very annoying to keep our local databases in sync as every commit we have to run new procs. I have used some ...
