[Firebird-net-provider] [Fwd: Speedup for the embedded .Net provider I think I can get it to work at 10x the speed. (so it is comparable to the server version)]

2006-11-02 Thread Carlos Guzmán Álvarez
I have pending the review of this email that a user has sent to try to give a speed up on the embedded server support i have done a quick review ( haven't time for more until now ) i will try to do a quick review tomorrow. I have forwarded it to list to hear comments on the changes the use pro

Re: [Firebird-net-provider] deploying application

2006-11-02 Thread Carlos Guzmán Álvarez
Hello: > I have FirebirdSql.Data.FirebirdClient.dll installed to the GAC on the > server and I put it into the application folder as well. > > Is this what you meant? Yes. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com -

Re: [Firebird-net-provider] Another question about typed datasets in .NET

2006-11-02 Thread VS-Polis
Title: Jürgen Thomas Hello Daniel, I tried to solve this problem, too. Take a look at: Tool CreateTypedDataset.exe http://www.mycsharp.de/wbb2/thread.php?threadid=27421 This application calls any important information from the database (tables, fields, primary and unique keys, foreign keys),

Re: [Firebird-net-provider] Another question about typed datasets in .NET

2006-11-02 Thread Daniel Hahn
I already tried this. But when I create the typed dataset directly in VB 2005 and the use this dataset, it's empty after filling it with a fbtableadapter. Am Donnerstag, 2. November 2006 15:06 schrieb Jiri Cincura: > Why don't you create typed dataset dyrectly in dataset designer? > > -- > Jiri

Re: [Firebird-net-provider] Another question about typed datasets in .NET

2006-11-02 Thread Jiri Cincura
Jiri Cincura wrote: > dyrectly He wants to say "directly". :D -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support web services, security? Get st

Re: [Firebird-net-provider] Another question about typed datasets in .NET

2006-11-02 Thread Jiri Cincura
Why don't you create typed dataset dyrectly in dataset designer? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support web services, security? Get

[Firebird-net-provider] Another question about typed datasets in .NET

2006-11-02 Thread Daniel Hahn
Hello all. As I learned from earlier mails today the best way of creating a typed dataset is to 1. Read the firebird db into an untyped dataset, 2. To write the xmlschema and 3. To create a typed dataset using this schema. This works with the tables - but! How can I also get constraints like fo

Re: [Firebird-net-provider] Batch Select with Firebird provider

2006-11-02 Thread Carlos Guzmán Álvarez
Hello: > Does anyone know if it is possible to do a batch select with the > Firebird .NET provider? Batch commands are not supported. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Using Tomcat but

Re: [Firebird-net-provider] Batch Select with Firebird provider

2006-11-02 Thread Jon Ege Ronnenberg
Your are dead on Dean. My setup is a hosted webserver and a inhouse database so fewer roundtrips to the db would significant increase performance. That being said, I see a lot of ideas here that I'm not sure is worth implementing. Ahh I just took a second look of my example and it doesn't show what

Re: [Firebird-net-provider] Batch Select with Firebird provider

2006-11-02 Thread Dean Harding
The problem is not with the processing done by the server - the difference would be miniscule (there might be differences in the fact that there is only one execution plan cached for multiple executions, rather than 3 separate ones, but you'd barely notice that). The difference is a simple matter

[Firebird-net-provider] Problem with FbDataAdapter

2006-11-02 Thread mn
FbDataAdapter does not handle correctly Update method because of   protected override int Update(DataRow[] dataRows, DataTableMapping tableMapping) implementation   Here is the case:   we have a table named zones created as follows   CREATE TABLE zones ( zone_id   INTEGER  NOT NULL, /* pk

Re: [Firebird-net-provider] FbCommand and 'using' statement

2006-11-02 Thread Jiri Cincura
Jon Ege Ronnenberg wrote: > not > supported - I think in this forum. But hey - I'm glad it works now. It's really weird. FbCommand always implemented IDisposable, so using keyword (same as calling Dispose) is OK. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -