[Firebird-net-provider] Central location for FirebirdSql.Data.Firebird.dll

[Andrew G. <ag...@jc...>]

All,


I need help and advise on how to manage the deployment of
FirebirdSql.Data.Firebird.dll

My web applications are starting to build and currently I have a separate
bin folder under each web app containing the
FirebirdSql.Data.Firebird.dll

But this is not going to be easy to manage.

I know that there is a better way to do this - I would like one central
location that I can refer to, can I put the dll in the GAC ? If so how?

TIA,

Andrew Goodall


-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
fir...@li...
Sent: Thursday, June 19, 2003 10:09 PM
To: fir...@li...
Subject: Firebird-net-provider digest, Vol 1 #125 - 2 msgs


Send Firebird-net-provider mailing list submissions to
	fir...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
or, via email, send a message with subject or body 'help' to
	fir...@li...

You can reach the person managing the list at
	fir...@li...

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Firebird-net-provider digest..."


Today's Topics:

   1. Events API implementation Status and a Question (Carlos Guzman
Alvarez)
   2. where to get .net provider and exmples (David B)

--__--__--

Message: 1
Date: Thu, 19 Jun 2003 22:50:53 +0200
From: Carlos Guzman Alvarez <car...@te...>
To: "Firebird .Net Provider" <fir...@li...>
Subject: [Firebird-net-provider] Events API implementation Status and a
Question

Hello:

Little by little and thanks to the Help of Tedd the Events API=20
implementation is in the right way, here is a little example of use:


public static void Main(string[] args)
{
	string connectionString =3D
		"User=3DSYSDBA;"			+
		"Password=3Dmasterkey;"		+
		@"Database=3DTESTDB.GDB;" 	+

		"DataSource=3Dlocalhost;"		+
		"Port=3D3050;"			+
		"Dialect=3D3;"			+
		"Charset=3DNONE;"			+
		"Role=3D;"			+
		"Connection lifetime=3D15;"	+
		"Pooling=3Dfalse;"		+
		"Packet Size=3D8192";

	FbConnection connection =3D new FbConnection(connectionString);
	connection.Open();
	FbTransaction transaction =3D connection.BeginTransaction();

	FbEvents fbEvents =3D new FbEvents(connection);

	FbEventAlertEventHandler e =3D new=20
FbEventAlertEventHandler(EventAlertHandler);

	fbEvents.EventAlert +=3D e;
	fbEvents.RegisterEvents("new row", "updated row");

	// First Event Request
	fbEvents.QueEvents();

	FbCommand command =3D new FbCommand("UPDATE test_table_01 SET
char_field=20
=3D 'events test' WHERE INT_FIELD =3D 3", connection , transaction);
=09
	command.ExecuteNonQuery();

	transaction.Commit();
=09
	fbEvents.QueEvents();

	transaction =3D connection.BeginTransaction();

	// Second Event Request
	fbEvents.QueEvents();

	command =3D new FbCommand("DELETE FROM test_table_01 WHERE int_field =3D

3", connection , transaction);
	command.ExecuteNonQuery();
=09
	command.CommandText =3D "UPDATE test_table_01 SET char_field =3D 'events

test'";
	command.ExecuteNonQuery();

	command.CommandText =3D "UPDATE test_table_01 SET char_field =3D 'events

test 2'";
	command.ExecuteNonQuery();

	command.CommandText =3D "INSERT INTO test_table_01 (int_field) VALUES
(3)";
	command.ExecuteNonQuery();=09=09=09=09=09

	transaction.Commit();
=09
	fbEvents.QueEvents();
=09

	connection.Close();

	Console.ReadLine();
}

public static void EventAlertHandler(object sender, FbEventAlertEventArgs e)
{
	for (int i =3D 0; i < e.Counts.Length; i++)
	{
		Console.WriteLine(e.Counts[i]);
	}
}




Tedd has asked to me if the programmer should be responsible for calling=20
QueEvents each time an event is received? or should the provider do it?


I think that it's better to left this responsability to the programmer=20
but i want to know opinions about this.





--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain



--__--__--

Message: 2
To: fir...@li...
From: "David B" <NO_...@ya...>
Date: Fri, 20 Jun 2003 14:40:10 +1200
Organization: Firebird and InterBase Community Site
Subject: [Firebird-net-provider] where to get .net provider and exmples

Hi,

Could somebody please tell me where I can get the .Net provider for firebird
and possibly a good xample of connecting to a database, issuing select
statements, using stored procedures from VB.NET.

I am been searching through the archieves for this group and think that I
can piece together various bits of info to make a connection once I have the
provider, although an example would be good.

My back group has mostly been in classic ASP development to MS SQL
databases, so hopefully I won't find this toooo hard.

any help is very much appreciated.


cheers

martin.





--__--__--

_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


End of Firebird-net-provider Digest