|
|
|
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
|
|
|
|
|
Hi Simon, you are the man.....it is what exactly i wanted....thank you very much.....
|
|
|
|
|
No problem.
Simon
|
|
|
|
|
Hi,
When i try to connect diffrent ip addres the following exception are comming.
"Cannot block a call on this socket while an earlier asynchronous call is in progress.at System.Net.Sockets.Socket.ValidateBlockingMode()"
If i use same system, so the ip is same, its working properly. also in some diffrent systems connection is ok.
When i debug i get the LocalEndPoint = 0.0.0.0 : "port numbet".
Following are the code for connecting with listening server
m_sock = new Socket( AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp );
IPEndPoint epServer = new IPEndPoint( IPAddress.Parse( "listening server IP address" ), 399 );
m_sock.Blocking = true;
onconnect = new AsyncCallback( OnConnect );
m_sock.BeginConnect( epServer, onconnect, m_sock );
How can i rectify this?
Regards,
Yesuprakash
modified on Wednesday, December 17, 2008 3:00 AM
|
|
|
|
|
i've a form and when it loads it creates a new thread, with in that thread it creates another new thread , while in being in this thread i want to add a list view to the form, any suggestions ?
i tried
this.Container.Add(new ListView(),"lstvw");
lstvw.Items.Add(lst);
but the listview is not displayed on the form ;
|
|
|
|