|
MamthaLalith wrote: embedded database to go up with C#
What do you mean by embedded database? Something like SQLite[^] ?
|
|
|
|
|
Yes Sql Lite and also someothers like firebird and perst
but honestly am not quite sure which one to use
do you have any idea which would be good and simple to work
Thanks,
Mamtha
|
|
|
|
|
Go with Sqlite. It's good and stable. You will get managed APIs also for accessing it.
|
|
|
|
|
Thanks,
and does SQL Lite support storing of binary data and image formats in it
just wondering,
Thanks.
|
|
|
|
|
|
|
SQL Compact Edition (SQL CE) is pretty good and you have the advantage of designing your database in visual studio. 
oooo, the Jedi's will feel this one....
|
|
|
|
|
|
Try MS SQL Compact
Regards,
Lev
|
|
|
|
|
Thanks Lev and Mirko
but as far as i know SQL Server CE isnt an open source one.
you guys worked on firebird or perst anytime
Thanks
Mamtha
|
|
|
|
|
SQL Server CE is free to download as well as to redistribute. Is it a requirement to use open source-material? If so, what are you planning on doing with the source?
Most of the time, it's about money, and it that case, "free" is just as good as "open source".
I are troll 
|
|
|
|
|
Thanks Eddy,
yes it is more or less means to the money, but am just wondering that i hope i need not run the CE on the client machines using my application.
mine is not a web but a windows application that i am looking to integrate the database to
Thanks,
Mamtha
|
|
|
|
|
Go for SQLite: it's opensource, there is a managed provider, compatible with linq and entity framework and fast.
|
|
|
|
|
Thanks Giorgi,
I hope sql lite support storing of binary data in it.
Thanks,
Mamtha
|
|
|
|
|
|
Giorgi Dalakishvili wrote: Yes, it does.
Thank You
|
|
|
|
|
You are welcome
|
|
|
|
|
SQL Server Express is free too, I use it for a few things.
Given that the out-the-door price is the same (free), the cost difference would be in:
1) maintenance -- Microsoft maintains it, perhaps more rigorously than a bunch of guys in their free time
2) support -- Millions of SQL Server users, many of them here on Code Project; go to the database forum, nearly all the questions are about SQL server, and most of the answers assume SQL Server
3) eventual migration to SQL Server when you realize you need something better -- you're already there
|
|
|
|
|
Hi,
I am processing a large xml file which is about 90MB as follows:
The problem is that every time I process this file, my machine really slows down even after I have completed my work and close the application.
I wonder if I should close the doc after usage?
Any suggestions please?
//xml file path refers to the location of the .xml file...
xmlDocument doc = new XmlDocument();
doc.load(xmlFilePath)
//processing on the file happens here...
|
|
|
|
|
The XmlDocument class has to load the whole document into memory to process it. For a large document you would be better off using an XmlReader[^]. This accesses the file as a stream, bit at a time, and allows you to move through it node by node.
(That said, your PC shouldn't slow down after you've closed the app. Have you got a separate thread or something that is keeping your app alive and not letting it close properly? There is no need to close/dispose of an XmlDocuemnt - Although you must remember to close an XmlReader if you switch to using that)
Simon
|
|
|
|
|
arkiboys wrote: I have completed my work and close the application.
Have you checked in the task manager to see if that application is still running after closing? I think you have some active threads which is keeping the application alive. If you use a separate thread to do this processing, consider making it as background thread so that it ends when the main thread ends.
Also as Simon said, XMLReader will be obvious here.
|
|
|
|
|
Yes, I have checked the task manager and noting seems to be running heavily...
Thanks
|
|
|
|
|
Hi,
I have a requirement that, need to create mail box programmatically using C#, It should run in both Exchange server 2003 and Exchange Server 2007.
I have try to create mailbox using CDOEXM, but this won’t support in Exchange Server 2007. Can anyone help me on this.
Ta
Yoons
|
|
|
|
|
How to compile a csproj dynamically.
I checked CompileAssemblyFromFile method in Microsoft.CSharp.CSharpCodeProvider but it accepts only cs files.
Thanks in advance
|
|
|
|
|
csproj files are xml scripts that are executed using msbuild.exe. the MsBuild engine can be invoked from code using the Microsoft.Build.BuildEngine.Engine[^] class.
Create the engine, set any properties you want to specify, and call BuildProjectFile()
Simon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
