Click here to Skip to main content
15,916,030 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionPorting DLL from VB6 to .NET platform. Pin
Kedar Potdar15-Jan-06 23:18
Kedar Potdar15-Jan-06 23:18 
QuestionSystem.Web.Mail.SmtpMail.Send() Pin
User 58385215-Jan-06 19:14
User 58385215-Jan-06 19:14 
AnswerRe: System.Web.Mail.SmtpMail.Send() Pin
tarasn15-Jan-06 21:28
tarasn15-Jan-06 21:28 
AnswerRe: System.Web.Mail.SmtpMail.Send() Pin
Guffa15-Jan-06 21:33
Guffa15-Jan-06 21:33 
GeneralRe: System.Web.Mail.SmtpMail.Send() Pin
User 58385215-Jan-06 21:45
User 58385215-Jan-06 21:45 
QuestionRepacing DB with XML files? Pin
wmostafaw15-Jan-06 8:26
wmostafaw15-Jan-06 8:26 
GeneralRe: Repacing DB with XML files? Pin
silkkeng15-Jan-06 11:15
silkkeng15-Jan-06 11:15 
AnswerRe: Repacing DB with XML files? Pin
Mike Burroughs15-Jan-06 17:29
Mike Burroughs15-Jan-06 17:29 
Hard to answer the question without understanding why you would want to do this? XML files are portable and easily readable and editable, but as an operational data store they are not very functional. The issues that I would see with this are:

1) Consistency. With a database system you are guaranteed data is consistent based on the queries run against it, even through a system crash. With XML files, writing to one file may succeed, writing to the next may fail. What state is your data in at that point?

2) Performance. Database systems are optimized for performance, especially query performance. For large data sets a database system is going to be able to query optimally even if the data set it is querying is to big to fit in memory. In order to get any performance out of XML you are probably going to have to load the whole thing into memory, which may be difficult if your data set gets big. XPath is pretty powerful but nobody claims it is a speed burner.

3) Data Relationship Maintenance. If you want to maintain relationships between data tables that are parts of separate documents, each with a separate schema, how are you going to load the relationship information into the DataSet?

4) Query Capability. You will loose significant query capability and performance using your model.

5) Multiuser Capability. Your system of files is a single user solution at best.


If you are building a stand alone, single user application that you expect to have a limited data set size and are dead set on XML files, then I would at least explore putting all the tables into one XML file. Otherwise stick with a database system.

XML files are best used for import and export of data and transfer of data between systems. Granted, XML files are cheap, but MySQL and SQL Server 2005 Express are free as well and much better options for a database engine.
QuestionAssembly Pin
Amit R15-Jan-06 5:35
Amit R15-Jan-06 5:35 
AnswerRe: Assembly Pin
Mike Burroughs15-Jan-06 17:37
Mike Burroughs15-Jan-06 17:37 
QuestionAnyone else having Errors with VS.NET 2005 Express Editions? Pin
M@dHatter14-Jan-06 17:57
M@dHatter14-Jan-06 17:57 
QuestionShared Method Pin
GaneshParam14-Jan-06 1:03
GaneshParam14-Jan-06 1:03 
AnswerRe: Shared Method Pin
Guffa14-Jan-06 9:06
Guffa14-Jan-06 9:06 
QuestionCan I pass remote objects as parameters? using .NET remoting Pin
fbrubacher13-Jan-06 11:32
fbrubacher13-Jan-06 11:32 
QuestionOnly on Friday the 13th: Worker Thread Duplicates Pin
RFID Chris13-Jan-06 9:29
RFID Chris13-Jan-06 9:29 
QuestionConvert .Net 2003 project to .Net 2005? Pin
Hardik Doshi12-Jan-06 19:23
Hardik Doshi12-Jan-06 19:23 
AnswerRe: Convert .Net 2003 project to .Net 2005? Pin
André Ziegler13-Jan-06 3:50
André Ziegler13-Jan-06 3:50 
QuestionVideo Conferencing Pin
hbjs12-Jan-06 15:03
hbjs12-Jan-06 15:03 
AnswerRe: Video Conferencing Pin
Christian Graus12-Jan-06 15:17
protectorChristian Graus12-Jan-06 15:17 
GeneralRe: Video Conferencing Pin
hbjs12-Jan-06 15:36
hbjs12-Jan-06 15:36 
GeneralRe: Video Conferencing Pin
Christian Graus12-Jan-06 15:47
protectorChristian Graus12-Jan-06 15:47 
GeneralRe: Video Conferencing Pin
hbjs12-Jan-06 16:01
hbjs12-Jan-06 16:01 
GeneralRe: Video Conferencing Pin
Christian Graus12-Jan-06 16:03
protectorChristian Graus12-Jan-06 16:03 
GeneralRe: Video Conferencing Pin
hbjs12-Jan-06 19:05
hbjs12-Jan-06 19:05 
GeneralRe: Video Conferencing Pin
Christian Graus15-Jan-06 11:06
protectorChristian Graus15-Jan-06 11:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.