firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[Alessandro P. <pet...@in...>]

""Peter Jacobi"" <pj...@wa...> ha scritto nel messaggio
news:403E73F2.11159.130DA2D@localhost...

> The sad fact is, that this field will also happily hold 'PPP' and 'EEE'
or=
>
> 'P=D6' but not '=D6=D6', if you see what is going on here. (Perhaps the
NE=
> T
> provider actually manages to forbid these INSERTs, but with the C API or
> ISQL it's possible.)
>

Yes, you're right, all char fields are not trimmed out...

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[Peter J. <pj...@wa...>]

Hi Carlos, All,

> the only problem is how to deal with querys against system tables (
> maybe i will be checking that the field name and the table name starts with
> RDB$ ).

I've already fiven my disclaimer that I've lost (if I ever had) the 
overview. But...

Aren't the system table columns the only UNICODE_FSS columns with length in 
(in bytes) which isn't divisable by three? 

Thinking of it, this test isn't really better than testing for RDB$, only 
want to bring it up.

Regards,
Peter Jacobi

RE: [Firebird-net-provider] .NET provider Performance

[Peter M. <P.m...@de...>]

No, from what I have seen, C# is slightly slower than a well written C++
program doing the same thing. But if you start counting your own time to it
to make it robust, than my choice is clear. And if you can use multiple
threads, .net is definitively a better choice. I have not benchmarked the C
API of Firebird.

Peter

 

  _____  

Van: fir...@li...
[mailto:fir...@li...] Namens Da Jiao
Verzonden: donderdag 26 februari 2004 21:51
Aan: 'FB-NETProvider'
Onderwerp: Re: [Firebird-net-provider] .NET provider Performance

 

Thank you, Peter,

 

I am concerning the speed to access Firebird, I am working on the server
side and not worrying UI performance. Are you saying C# net provider is
faster than C++ API to run the same query against Firebird?

 

----- Original Message ----- 

From: Peter Martens <mailto:P.m...@de...>  

To: 'FB-NETProvider' <mailto:fir...@li...>  

Sent: Thursday, February 26, 2004 12:13 PM

Subject: RE: [Firebird-net-provider] .NET provider Performance

 

I do a lot of real-time work and C#.net is a lot faster for me than C++
because the multithreading is actually usable.

Raw processing power is not a big difference.

So if you are planning e.g. to use one thread for data-retrieval and another
for GUI, .net is the only route...

 

Peter


  _____  


Van: fir...@li...
<mailto:fir...@li...>
[mailto:fir...@li...] Namens Da Jiao
Verzonden: donderdag 26 februari 2004 20:59
Aan: FB-NETProvider
Onderwerp: [Firebird-net-provider] .NET provider Performance

 

Hello all,

 

I am a newbie to Firebird, I am very glad that it has a .NET data provider.
But I need to know more about its performance. Could anybody with practical
experience with Firebird and its .NET provider tell me more info about its
performance?

 

I know using C++ API is the quickest way to access Firebird, if I use
net-provider, what will be the performance penalty? If it is close enough, I
will go the C# way.

 

Any help is appreciated.

 

Da Jiao

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[<car...@te...>]

Hello:

> Now, at SELECT time, a clever middle layer (like the NET provider ;-) ), 
> can try to make the situation more sane. Knowing that a 3 byte buffer for 
> UNICODE_FSS should better only hold one character, it can algorithmically 
> extract just one UTF-8 character from the buffer, ignoring the junk bytes 
> after that.

Yes :) the only problem is how to deal with querys against system tables 
( maybe i will be checking that the field name and the table name starts 
with RDB$ ).




--
Best Regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[Peter J. <pj...@wa...>]

Hi Alessandro, All,

"Alessandro Petrelli" <pet...@in...> wrote:
> I have an unicode_fss db (I need to develop a Japanese application) and =
an
> asp.net DataGrid. All fields are shown correctly except those for which =
I
> call declarative databinding, for example:
[...]
> The field OUT_CHANNEL is return from a stored procedure and is a char(1)=
. I
> should expect values like 'P' or 'E', but instead they are returned as '=
P '
> or 'E  '.

The sad fact is, that this field will also happily hold 'PPP' and 'EEE' or=
 
'P=D6' but not '=D6=D6', if you see what is going on here. (Perhaps the NE=
T 
provider actually manages to forbid these INSERTs, but with the C API or 
ISQL it's possible.)

Now, at SELECT time, a clever middle layer (like the NET provider ;-) ), 
can try to make the situation more sane. Knowing that a 3 byte buffer for 
UNICODE_FSS should better only hold one character, it can algorithmically 
extract just one UTF-8 character from the buffer, ignoring the junk bytes 
after that.

Regards,
Peter Jacobi

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[Peter J. <pj...@wa...>]

Hi Carlos, All,

Carlos Guzm=E1n =C1lvarez <car...@te...> wrote:

> I think that this is because firebird is sending 3 bytes one with the 
> character and another two with spaces :P ( maybe i'm wrong ) i can give =
a
> try to it if necessary ( maybe Peter Jacobi can confirm this too ;) )

Inside FB, a char(1) character set UNICODE_FSS takes 3 bytes and the app 
has to figure out, which are valid. I totally lost (if I ever had) the 
overview, at which interfaces (let alone other added layers) this shows up=
 
and where it is already hidden. It's a major PITA. 

I have less time for FB than initially thought, so I fear I must refrain 
from hacking in the engine proper and hope anybody else cleans up the 
Unicode issues there. I'm still in the process of adding character set and=
 
collation support via fbintl, but even this has slowed down.

Regards,
Peter Jacobi

Re: [Firebird-net-provider] .NET provider Performance

[Da J. <da...@ho...>]

Thank you, Peter,

I am concerning the speed to access Firebird, I am working on the server =
side and not worrying UI performance. Are you saying C# net provider is =
faster than C++ API to run the same query against Firebird?

----- Original Message -----=20
  From: Peter Martens=20
  To: 'FB-NETProvider'=20
  Sent: Thursday, February 26, 2004 12:13 PM
  Subject: RE: [Firebird-net-provider] .NET provider Performance


  I do a lot of real-time work and C#.net is a lot faster for me than =
C++ because the multithreading is actually usable.

  Raw processing power is not a big difference.

  So if you are planning e.g. to use one thread for data-retrieval and =
another for GUI, .net is the only route...



  Peter


-------------------------------------------------------------------------=
-----

  Van: fir...@li... =
[mailto:fir...@li...] Namens Da =
Jiao
  Verzonden: donderdag 26 februari 2004 20:59
  Aan: FB-NETProvider
  Onderwerp: [Firebird-net-provider] .NET provider Performance



  Hello all,



  I am a newbie to Firebird, I am very glad that it has a .NET data =
provider. But I need to know more about its performance. Could anybody =
with practical experience with Firebird and its .NET provider tell me =
more info about its performance?



  I know using C++ API is the quickest way to access Firebird, if I use =
net-provider, what will be the performance penalty? If it is close =
enough, I will go the C# way.



  Any help is appreciated.



  Da Jiao

RE: [Firebird-net-provider] .NET provider Performance

[Peter M. <P.m...@de...>]

I do a lot of real-time work and C#.net is a lot faster for me than C++
because the multithreading is actually usable.

Raw processing power is not a big difference.

So if you are planning e.g. to use one thread for data-retrieval and another
for GUI, .net is the only route...

 

Peter

  _____  

Van: fir...@li...
[mailto:fir...@li...] Namens Da Jiao
Verzonden: donderdag 26 februari 2004 20:59
Aan: FB-NETProvider
Onderwerp: [Firebird-net-provider] .NET provider Performance

 

Hello all,

 

I am a newbie to Firebird, I am very glad that it has a .NET data provider.
But I need to know more about its performance. Could anybody with practical
experience with Firebird and its .NET provider tell me more info about its
performance?

 

I know using C++ API is the quickest way to access Firebird, if I use
net-provider, what will be the performance penalty? If it is close enough, I
will go the C# way.

 

Any help is appreciated.

 

Da Jiao

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[<car...@te...>]

Hello:

> Or maybe the RDB$SYSTEM_FLAG

I was thinking on use information already existent in the XSQLDA structure.






--
Best regards

arlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] .NET provider Performance

[Da J. <da...@ho...>]

Hello all,

I am a newbie to Firebird, I am very glad that it has a .NET data =
provider. But I need to know more about its performance. Could anybody =
with practical experience with Firebird and its .NET provider tell me =
more info about its performance?

I know using C++ API is the quickest way to access Firebird, if I use =
net-provider, what will be the performance penalty? If it is close =
enough, I will go the C# way.

Any help is appreciated.

Da Jiao

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[Alessandro P. <pet...@in...>]

"Carlos Guzmán Álvarez" <car...@te...> ha scritto nel messaggio
news:403...@te......
> Hello:
>
> I'm here one more time ;)
>
> > Maybe a possible solution for this to declare the field as varchar(1)
> > and modify the provider for return values of varchar fields trimmed if
> > necessary.
>
> The real solution is to check that the number of characters in the value
> is correct, the problem is that this is not valid for system tables, i
> can check the field name of the query starts with RDB$ but i don't like
> this solution :P, as always opinions are welcome !!

Or maybe the RDB$SYSTEM_FLAG

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[Alessandro P. <pet...@in...>]

""Alessandro Petrelli"" <pet...@in...> ha scritto nel messaggio
news:c1lgkf$24e$1...@ne......

> This will work with a varchar(2) field but not with a varchar(1) field,
> already tested and shown not working :-( ...but....maybe there is
something
> wrong in my code... I need to take some tests, I feel like that field has
> been inserted with another charset...

No, it has been inserted correctly... the problem is elsewhere.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[<car...@te...>]

Hello:

> This will work with a varchar(2) field but not with a varchar(1) field,
> already tested and shown not working :-( ...but....maybe there is something
> wrong in my code... I need to take some tests, I feel like that field has
> been inserted with another charset...

I think that your code will be right, you will have defined UNICODE_FSS 
in the connection string and defined the field as UNICODE_FSS.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[Alessandro P. <pet...@in...>]

"Carlos Guzmán Álvarez" <car...@te...> ha scritto nel messaggio
news:403...@te......
> Hello:
>
> > I think that this is because firebird is sending 3 bytes one with the

Exact.

> Maybe a possible solution for this to declare the field as varchar(1)
> and modify the provider for return values of varchar fields trimmed if
> necessary.

This will work with a varchar(2) field but not with a varchar(1) field,
already tested and shown not working :-( ...but....maybe there is something
wrong in my code... I need to take some tests, I feel like that field has
been inserted with another charset...


--
Alessandro Petrelli.

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[<car...@te...>]

Hello:

I'm here one more time ;)

> Maybe a possible solution for this to declare the field as varchar(1) 
> and modify the provider for return values of varchar fields trimmed if 
> necessary.

The real solution is to check that the number of characters in the value 
is correct, the problem is that this is not valid for system tables, i 
can check the field name of the query starts with RDB$ but i don't like 
this solution :P, as always opinions are welcome !!




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[<car...@te...>]

Hello:

> I think that this is because firebird is sending 3 bytes one with the 
> character and another two with spaces :P ( maybe i'm wrong ) i can give 
> a try to it if necessary ( maybe Peter Jacobi can confirm this too ;) )

Maybe a possible solution for this to declare the field as varchar(1) 
and modify the provider for return values of varchar fields trimmed if 
necessary.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Unicode and Databinder.Eval

[<car...@te...>]

Hello:

> The field OUT_CHANNEL is return from a stored procedure and is a char(1).
> I should expect values like 'P' or 'E', but instead they are returned as 'P
> ' or 'E  '.
> 
> Any idea?

I think that this is because firebird is sending 3 bytes one with the 
character and another two with spaces :P ( maybe i'm wrong ) i can give 
a try to it if necessary ( maybe Peter Jacobi can confirm this too ;) )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Unicode and Databinder.Eval

[Alessandro P. <pet...@in...>]

Hi,

I have an unicode_fss db (I need to develop a Japanese application) and an
asp.net DataGrid.
All fields are shown correctly except those for which I call declarative
databinding, for example:

<%# DataBinder.Eval(Container.DataItem, "OUT_CHANNEL", "<img
src=\"img/{0}.gif\">") %>

The field OUT_CHANNEL is return from a stored procedure and is a char(1).
I should expect values like 'P' or 'E', but instead they are returned as 'P
' or 'E  '.

Any idea?

Meanwhile I'll trying to investigate this item further.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Automatically creating typed datasets

[<car...@te...>]

Hello:

> Any idea how to automatically add this code to the project??

No, but maybe there are any way try to ask it in the MS C# Newsgroup :)




--
Best regards
    	
Carlos Guzmán Álvatrez
Vigo-Spain

Re: [Firebird-net-provider] Executing Backup and restore.

[<sca...@ma...>]

MI> I'm having some strange problem while using the Service
MI> classes of the Firebird provider. I'm using FbBackup and
MI> FbRestore. Here is the code :
What Firebird .Net Data provider you using?
-- 
Roman.
sca...@ma...

[Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5.1 released

[<car...@te...>]

Hello:

Firebird .NET Data Provider 1.5.1 available for download.


Changes in this release:

1.5.1 ( 2004-02-26 )
----- - ---- -- -- -

- Bug fixes on named parameters, FbCommandBuilder,
FbDataAdapter and FbDataReader.NextResult imlementations.
( see the ChangeLog for more information )


         ---------------------------------------------------


You can read the Changelog at:

http://sourceforge.net/project/shownotes.php?release_id=219756


You can download binarys for .NET 1.0 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.1-NET1.0.exe?download


You can download binarys for .NET 1.1 at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.1-NET1.1.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.1-Src.zip?download


You can download documentation at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5.1-Doc.zip?download




CVS Tag: NP_1_5_1



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Strategies for handling transactions - just thinking

[JS.staff <jsp...@ec...>]

Just thinking...

Since it obviously essential to always communicate with FB in a
transaction context (and being a good lad who always writes
exception-aware code!), I found myself writing the following code a lot!
:

Conn.Open();
Try
{
	FbTransaction trans =3D
Conn.BeginTransaction(IsolationLevel.RepeatableRead);
	try
	{
		// do your stuff here
		trans.Commit();
	}
	catch
	{
		trans.Rollback();
		throw;
	}
}
Finally
{
	Conn.Close();
}

It seemed sensible to wrap this up, and call using a delegate from a
routine such as:

FbDoRoutine(fbConnection1,new
FbCodeRoutine(PopulateMyGrid),IsolationLevel.RepeatableRead);

PopulateMyGrid() is passed an open transaction object (plus some other
info) from which it can communicate with the database. If PopulateMyGrid
throws an exception, a rollback occurs, otherwise it will commit.

Every time I call FB routines from an event handler, I do it by way of a
call to FbCodeRoutine(). Should I need to call one handler from another,
I call the delegate instead, so everything nicely happens in one
transaction (unless I need otherwise, of course).

Of course it does mean I have twice the number of methods in my classes!
Waiting for anonymous delegates in .NET 2.

If anyone wants the code, give me an email. It's only 20-30 lines, but
copes with savepoints etc.

John

Re: [Firebird-net-provider] DataSet Merge and Update

[<car...@te...>]

Hello:

> Any suggestions?

Can you send a test case ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] DataSet Merge and Update

[<mga...@ar...>]

--------------------------------------
 Windows XP Professional
 NET Framework 1.1
 Firebird 1.5 
 Firebird NET Provider 1.5 
 --------------------------------------

Hello,

I am having difficulties to Update a fbDataAdapter. 

I am using two DataSets (one being filled by fbDataAdapter), merging them and then trying to Update the fbDataAdapter.

I use a fbCommandBuilder to generate the Update Command, but when I do:

fbDataAdapter2.Update(ds);  // I only get a TableMapping Exception

fbDataAdapter2.Update(ds "TableName");  //Nothing happens

Any suggestions?

PS: I am aware that I need matching ColumnTypes and a Primary Key

RE: [Firebird-net-provider] Automatically creating typed datasets

[JS.staff <jsp...@ec...>]

That works great! I'm using little script files containing something =
like:

PeopleTable ; select * from "People"
SomeQuery ; select name,address from "People" p inner join "Addresses" a =
on p.id =3D a.person

The program then uses your code to generate XSD and CS files.

Any idea how to automatically add this code to the project??

Thanks,

John

-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: 24 February 2004 23:23
To: JS.staff
Cc: fir...@li...
Subject: Re: [Firebird-net-provider] Automatically creating typed =
datasets


Hello:

> I see what you mean - no reference material anywhere for=20
> TypesDatasetGenerator!

A little sample that generates a XSD and a CS file:

FbConnection connection =3D new FbConnection(connectionString);

DataSet employees =3D new DataSet("Employees");
FbCommand command =3D new FbCommand("select * from employee", =
connection); FbDataAdapter adapter =3D new FbDataAdapter(command); =
adapter.MissingSchemaAction =3D MissingSchemaAction.AddWithKey;

adapter.Fill(employees, "Employees");

// Generate the employee TypedDataSet
string fileName =3D @"d:\employee.cs";

StreamWriter tw =3D new StreamWriter(new FileStream(fileName,
			FileMode.Create,
			FileAccess.Write));

CodeNamespace		cn =3D new CodeNamespace("employees");
CSharpCodeProvider	cs =3D new CSharpCodeProvider();
ICodeGenerator		cg =3D cs.CreateGenerator();

			TypedDataSetGenerator.Generate(employees, cn, cg);

cg.GenerateCodeFromNamespace(cn, tw, null);

tw.Flush();
tw.Close();

			employees.WriteXmlSchema(@"d:\employee.xsd");

connection.Close();

--
Best regards
  =09
Carlos Guzm=E1n =C1=81lvatrez
Vigo-Spain