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

[Firebird-net-provider] Urgent help needed-Problem with Firebird DB

[Ghanshyam P. <gh_...@ya...>]

Hello,
 I am installing firebird database with my ASP.Net
application (using Windows installer). All the files
of the application 

and Firebird database are getting installed properly.
When i checked the database, it is also configured
properly.  
But, when i try to run the ASP.Net application, it
displays some blank pages (It is not able to retrieve
the data from 

database) and it doesn't give any error also. The .Net
provider is also installed properly. If the setup is
executed on the 

machine on which I have developed the ASP.Net
application, it works fine there. But nowhere else. I
have also included the 

dll of the application in setup. What else needs to be
checked? I think, the problem is somewhere related to
database. If the 

DB file (.gdb) is accessed from any other machine
using IBConsole, it displays the proper records.

What may be the problem?

Thanx in advance 4 any help.

Regards,
Ghanshyam

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: [Firebird-net-provider] C# Personal

[Carlos G. A. <car...@te...>]

Hello:

> I created a new web application and included the ASP.NET example for C#.  It
> compiles just fine but, I am receiving an error when I run it.  The error on
> the page indicates "File or assembly name FirebirdSql.Data.Firebird.dll, or
> one of its dependencies, was not found."
> Obviously, I'm missing some basic pathing somewhere.  Any tips would be
> appreciated.

Are you using a web.config file ?? you need it for specify the Firebird 
.NET provider assembly:

<compilation>
	<assemblies>
		<add assembly="FirebirdSql.Data.Firebird, Version=1.0.1154.37639, 
Culture=neutral, PublicKeyToken=a39b891b3af74145" />
	</assemblies>
</compilation>



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] C# Personal

[Tom K. <to...@tw...>]

Hello all,

I created a new web application and included the ASP.NET example for C#. =
 It
compiles just fine but, I am receiving an error when I run it.  The =
error on
the page indicates "File or assembly name FirebirdSql.Data.Firebird.dll, =
or
one of its dependencies, was not found."
Obviously, I'm missing some basic pathing somewhere.  Any tips would be
appreciated.

Tom

Re: [Firebird-net-provider] SELECT ... FOR UPDATE implementation for the .NET Data Provider

[Carlos G. A. <car...@te...>]

Hello:

> BTW: Can you direct me to a web-page that desribes the ADO.NET standard?

As i don't know other than the ADO.NET Documentation existent in the 
.NET Framework :) , i'm using as "standard" the SqlClient and OleDb 
Providers Documentation.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] SELECT ... FOR UPDATE implementation for the .NET Data Provider

[Carlos G. A. <car...@te...>]

Hello:

> If you do not implement this feature, you can not implement the new FOR
> UPDATE WITH LOCK that FB 1.5 offers...
> If you do not plan to implement the WITH LOCK feature, I do not think that
> it's important to support 'FOR UPDATE'.

Sorry i forgot to answer this in the prior email :).

Thanks for the anwswer, well i think the WITH LOCK can be in the future 
of interest for people that works only with Firebird, but how it can be 
used only with the FbDataReader i want to know opinions :).




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] SELECT ... FOR UPDATE implementation for the .NET Data Provider

[Willibald K. <wi...@dw...>]

Hi!

> I was playing trying to give support in the Firebird .NET data provider
> for SELECT ... FOR UPDATE commands, but i want to know opinions about
> it, because it's non standard ADO.NET feature ( this is not a great
> problem while can be of interest for people that works only with
> Firebird ), and breaks a little what ADO.NET standard says about working
> with a DataReader opened, see an example:

If you do not implement this feature, you can not implement the new FOR
UPDATE WITH LOCK that FB 1.5 offers...
If you do not plan to implement the WITH LOCK feature, I do not think that
it's important to support 'FOR UPDATE'.

BTW: Can you direct me to a web-page that desribes the ADO.NET standard?

Thanks,
 Willi

[Firebird-net-provider] SELECT ... FOR UPDATE implementation for the .NET Data Provider

[Carlos G. A. <car...@te...>]

Hello:

I was playing trying to give support in the Firebird .NET data provider 
for SELECT ... FOR UPDATE commands, but i want to know opinions about 
it, because it's non standard ADO.NET feature ( this is not a great 
problem while can be of interest for people that works only with 
Firebird ), and breaks a little what ADO.NET standard says about working 
with a DataReader opened, see an example:


FbConnection connection = new FbConnection(connectionString);
connection.Open();

string cursorName = "EMPLOYEE_CURSOR";

FbTransaction transaction = connection.BeginTransaction();

FbCommand sc = new FbCommand("SELECT * FROM EMPLOYEE WHERE EMP_NO 
BETWEEN 2 AND 10 FOR UPDATE", connection);
FbCommand uc = new FbCommand("UPDATE EMPLOYEE SET FIRST_NAME = 
'TEST_NAME' WHERE CURRENT OF " + cursorName, connection, transaction);

sc.CursorName = cursorName;
FbDataReader reader = sc.ExecuteReader();

while (reader.Read())
{
	uc.ExecuteNonQuery();
}

reader.Close();
sc.Dispose();
uc.Dispose();

transaction.Commit();
connection.Close();



Now i want to know your opinion, what do you think about this feature 
it's good or not ??  :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Firebird .NET provider 1.5 changes

[Carlos G. A. <car...@te...>]

Hello:


There will be some little canges in the new sources that will broke 
compatibility with 1.0 version:

- FbParameterCollection. The constructors are now internal and there are 
no public constructor, as in SqlClient provider.

- FbParameter. I have removed a non ADO.NET standard constrctor ( by 
parameterName, FbType, sourceColumn ) and added a new one ( by 
parameterName. FbType, size ), as in SqlClient provider

- FbType. Removed NChar, NVarChar and NText elements.


Finally i want to make one more change that i want to make that is 
rename FbType enum to FbDbType, but i have not made this ye because i 
want to know opinions about it, what do you think ??.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird .NET provider 1.5 changes

[Lee C. <lee...@ad...>]

> Finally i want to make one more change that i want to make that is 
> rename FbType enum to FbDbType, but i have not made this ye because i 
> want to know opinions about it, what do you think ??.


I think its more descriptive of what the type enum is.

[Firebird-net-provider] Firebird .NET provider 1.5 changes

[Carlos G. A. <car...@te...>]

Hello:


There will be some little canges in the new sources that will broke 
compatibility with 1.0 version:

- FbParameterCollection. The constructors are now internal and there are 
no public constructor, as in SqlClient provider.

- FbParameter. I have removed a non ADO.NET standard constrctor ( by 
parameterName, FbType, sourceColumn ) and added a new one ( by 
parameterName. FbType, size ), as in SqlClient provider

- FbType. Removed NChar, NVarChar and NText elements.


Finally i want to make one more change that i want to make that is 
rename FbType enum to FbDbType, but i have not made this ye because i 
want to know opinions about it, what do you think ??.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird DB Case Sensitivity

[Carlos G. A. <car...@te...>]

Hello:

> Can someone tell me how I can tell my database not to use case sensitive 
> searches and compares?  I have seen an article on doing this but it 
> involved creating a "cloned field" if you will, and adding the data to 
> the original field as is and then adding the data using an Upper or 
> Lower case method into the "cloned field".  Then when comparing when not 
> needing case sensitivity you would do an Upper or Lower on the data 
> being sent to the database against the "cloned field".  Is there a 
> different way of accomplishing this?


I think this is better question for the Firebird support list :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] NET Provider 1.5 & MS.AppBlocks.Data

[Carlos G. A. <car...@te...>]

Hello:

> When a working release of NET Provider 1.5 is released, I am going to 
> convert the Microsoft.ApplicationBlocks.Data v2 class to be used with 
> Firebird instead.  I'm sure it will make life easier on using the FB 
> classes.

This will be great, i will try to see the new 2.0 version of it ( i have 
no notice about this thanks ), i was trying to add support for Firebird 
at the nhibernate project but the project seems to be dead ( i have 
added the support but i'm not sure if i made it in the correct way and 
nobody give answers in his forums ), and i'm monitoring the advance of 
the ojb-net project for try to add support for Firebird to it in the 
future ( at this moment this projects uses the OleDb provider only )



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Firebird DB Case Sensitivity

[Lee C. <lee...@ad...>]

Can someone tell me how I can tell my database not to use case sensitive =
searches and compares?  I have seen an article on doing this but it =
involved creating a "cloned field" if you will, and adding the data to =
the original field as is and then adding the data using an Upper or =
Lower case method into the "cloned field".  Then when comparing when not =
needing case sensitivity you would do an Upper or Lower on the data =
being sent to the database against the "cloned field".  Is there a =
different way of accomplishing this?

Lee

[Firebird-net-provider] NET Provider 1.5 & MS.AppBlocks.Data

[Lee C. <lee...@ad...>]

When a working release of NET Provider 1.5 is released, I am going to =
convert the Microsoft.ApplicationBlocks.Data v2 class to be used with =
Firebird instead.  I'm sure it will make life easier on using the FB =
classes.

Lee

Re: [Firebird-net-provider] Desiging a db access class with NET Provider

[Carlos G. A. <car...@te...>]

Hello:

> Q: The FbConnection.Open() method is thread safe?  It has to be right?

I think yes butif you have problems do not doubt on tell to me :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Desiging a db access class with NET Provider

[Lee C. <lee...@ad...>]

> I think yes, but test it and comment here the results :), at this moment
> for multi-threaded applications you need a connection per thread if i
> remember well :).

I will comment when I test this out.  I am actually designing the server to
use asynchronous calls but it does still throw it into a thread managed by
the system.  Each thread would have its own connection by using the thread
pooling capabilities in the NET Provider.  Q: The FbConnection.Open() method
is thread safe?  It has to be right?

Lee

Re: [Firebird-net-provider] Desiging a db access class with NET Provider

[Carlos G. A. <car...@te...>]

Hello:

> Would I safely be able to call that static method from multiple threads?

I think yes, but test it and comment here the results :), at this moment 
for multi-threaded applications you need a connection per thread if i 
remember well :).





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] New documentation format for external files in 1.5 version

[Carlos G. A. <car...@te...>]

Hello:

> Why use this documentation instead?

Because in the case of the actual net provider docs it would give better 
orgazation and also i continue to can add the include tag in the source 
files for  bring csc to generate an individual XML for use with NDoc :) 
in any case the xml would be not the same as in the link of the mono 
website.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] New documentation format for external files in 1.5 version

[Carlos G. A. <car...@te...>]

Hello:

> That is cool.  I bet that would be easier to design help documents would it?

Yes at least in my opinion :)


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Desiging a db access class with NET Provider

[Lee C. <lee...@ad...>]

Hi,

I wanted to know if i should create a db access class as static or not =
when designing a multi-threaded application.  I am going to have =
multiple threads wanting to use this class to access firebird.  My =
question is if i created a static class and all these threads accessed =
the method for executing a query do I have to worry about thread =
synchronization as long as whatever I do withini this method doesn't =
access something that may be being used in another thread?  Imagine I =
had code similar to this:

public static sealed class DBAccess
{
    public DBAccess(string connectionString)
    {
    }

    public static int ExecuteNonQuery(string query)
    {
        FbConnection conn =3D new FbConnection(connectionString);
        conn.Open();
        FbCommand cmd =3D new FbCommand(query, conn);
        return cmd.ExecuteNonQuery();
    }

}

Would I safely be able to call that static method from multiple threads?

Re: [Firebird-net-provider] New documentation format for external files in 1.5 version

[Lee C. <lee...@ad...>]

I also didn't realize MS was very similar to the mono documentation.  Why
use this documentation instead?

Lee


> Hello:
>
>
> I'm thinking in use a new format for external documentation files it
> would be similar to the described here:
>
> http://www.go-mono.com/monodoc-xml.html

Re: [Firebird-net-provider] New documentation format for external files in 1.5 version

[Lee C. <lee...@ad...>]

Carlos,

That is cool.  I bet that would be easier to design help documents would it?

> Hello:
>
>
> I'm thinking in use a new format for external documentation files it
> would be similar to the described here:
>
> http://www.go-mono.com/monodoc-xml.html

[Firebird-net-provider] New documentation format for external files in 1.5 version

[Carlos G. A. <car...@te...>]

Hello:


I'm thinking in use a new format for external documentation files it 
would be similar to the described here:

http://www.go-mono.com/monodoc-xml.html

One thing that really i want to change are the documentation comments 
that at this moment are in general the same as in the MS help as i can 
think this is copyrighted y will try to express it with my own words, 
when i can :)


A little sample:

<?xml version="1.0" encoding="utf-8" ?>
<doc>
	<class name="FbConnection">
		<overview>
			<summary>Represents an open connection to a Firebird database. This 
class cannot be inherited.</summary>
			<remarks>
				<para>A <b>FbConnection</b> object represents a individual 
connection to Firebird server.</para>
				<para>If a <b>FbConnection</b> object goes out of scope, it is not 
closed,
				you must explicitly close the the connection by calling	<see 
cref="FbConnection.Close" /> or <see cref="FbConnection.Dispose" />.	
			</para>
			</remarks>
			<example>
				<code>			
public void InsertRow(string connectionString)
{
	//	If the connection string is null, use a default.
	if(connectionString == "")
	{
		connectionString = "Database=C:\\PROGRAM 
FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=localhost";
	}
	
	FbConnection connection = new FbConnection(connectionString);					
	connection.Open();					
	FbTransaction transaction	= connection.BeginTransaction();
	
	string insertQuery = "INSERT INTO PROJECT(proj_id, proj_name, product) 
Values('FBNP', '.NET Provider', 'N/A')";
	FbCommand command = new FbCommand(insertQuery, myConn, myTxn);	
	
	command.ExecuteNonQuery();
	
	transaction.Commit();
	
	connection.Close();
}
				</code>
			</example>
		</overview>
		
		<event name="StateChange">
			<summary>Occurs when the state of the connection changes.</summary>
			<remarks>
				<para>The <see cref="FbConnection.StateChange" /> event is raised 
when the connection state changes
				from Closed to Opened, or from Opened to Closed.
				</para>
			</remarks>
			<data>
				<list type="table">
					<listheader>
						<term>Property</term>
						<term>Description</term>
					</listheader>
					<item>
						<description>CurrentState</description>
						<description>The new state of the connection.</description>
					</item>
					<item>
						<description>OriginalState</description>
						<description>The original state of the connection.</description>
					</item>
				</list>
			</data>
		</event>
		
		<event name="InfoMessage">
			<summary>
			Occurs when the Firebird Server sends a warning message.
			</summary>
		</event>		
	</class>
</doc>






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Feature Request: Multiple Transactions

[Carlos G. A. <car...@te...>]

Hello:

> But why do we need transaction in the first place then?! 

If you mean why a transaction is needed for SELECT commands, because 
firebird needs it :) , but in next version of the net provider this will 
be no needed and the net provider will start a new implicit transction 
for SELECT commands when they have no transaction.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Feature Request: Multiple Transactions

[Willibald K. <wi...@dw...>]

> could trade a connection as transaction)

Sorry, that should have read " 'treat' a connection as.."