LtColRDSChauhan | 17 Aug 03:44 2014
Picon

Catching Exception

Hi,

1.  When I run my application, in Release configuration, through SharpDevelop IDE, the application catches "Handled Exception" -  "FirebirdSql.Data.Common.IscException: OVER_ALLOCATED_BED" thrown by Firebird stored procedure .

2.  Without debugger, the exception is not caught.  I do have catch blocks for : FbException, ApplicationException and Exception.

3.  Complication fails on adding catch block for FirebirdSql.Data.Common.IscException (appears to be internal).

4.  Please help.

Thanks and Regards,
Lt Col (Retd) Rajiv D.S. Chauhan
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Amro El-Fakharany (JIRA | 16 Aug 10:57 2014

[FB-Tracker] Created: (DNET-564) Parameters are ignored if a comment in a query contains a single or double quote

Parameters are ignored if a comment in a query contains a single or double quote
--------------------------------------------------------------------------------

                 Key: DNET-564
                 URL: http://tracker.firebirdsql.org/browse/DNET-564
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
            Reporter: Amro El-Fakharany
            Assignee: Jiri Cincura
            Priority: Minor

The following query fails with an unknown token exception:
select int_field
from test
-- a comment with ' 
where varchar_field =  <at> field

--

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
Marco Castro | 12 Aug 15:47 2014
Picon

SqlQuery is not working

Hello,

This procedure seems to be not working. I tried in MSSQL provider and it 
worked.

var r = entity.Database.SqlQuery<counter>( 
  "Select Gen_id(COUNTER, 1) cnt from rdb$database", new object[]{});

When I try to read "r" it returns this message:

Invalid attempt of read when the reader is closed.

Thanks,
Marco Castro

------------------------------------------------------------------------------
Marco Castro | 12 Aug 04:02 2014
Picon

Error when reading from connection

Hello,

I have an application that opens a Firebird connection and try to star a 
loop. In one computer the code runs fine and in another computer I get this 
message when this connection is in another server (Linux server). I tryed 
connections with and without pools with no difference. Firebird is 4.5, EDMX 
runs over ER6.1:

System.Data.Entity.Core.EntityCommandExecutionException: An error occurred 
while executing the command definition. See the inner exception for details. 
---> FirebirdSql.Data.FirebirdClient.FbException: Error reading data from 
the connection. 
---> FirebirdSql.Data.Common.IscException: Error reading data from the 
connection.
   em FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String 
commandText)
   em FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior b
ehavior, Boolean returnsSet)
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior be
havior)
   --- Fim do rastreamento de pilha de exceções internas ---
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior be
havior)
   em 
FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehav
ior behavior)
   em System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   em System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.
<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
   em 
System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispat
ch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, 
TInterceptionContext interceptionContext, Action`3 executing, Action`3 
executed)
   em 
System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(
DbCommand command, DbCommandInterceptionContext interceptionContext)
   em 
System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(Com
mandBehavior behavior)
   em System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   em 
System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Exec
uteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- Fim do rastreamento de pilha de exceções internas ---
   em 
System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Exec
uteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   em 
System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[
TResultType](ObjectContext context, ObjectParameterCollection 
parameterValues)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.
<GetResul
ts>b__6()
   em System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T]
(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean 
startLocalTransaction, Boolean releaseConnectionOnSuccess)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.
<GetResults>b__5()
   em 
System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult
](Func`1 operation)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 
forMergeOption)
   em System.Data.Entity.Core.Objects.ObjectQuery`1.
<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   em System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   em System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   em System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   em McSoft.Regras.BI.ConsultasOLAP.Consulta(Int32 _filial, DateTime _from, 
DateTime _to, Nullable`1 _produto, String _marca)

****************

Well, where can I start the issue solve?

Thanks,
Marco Casrto

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Lukáš Vykydal | 8 Aug 12:05 2014
Picon

Abbility to use "no garbage collect" connection parameter

Hi

i d'like to add support for option NoGarbageCollect to connection 
parameters.

I purpouse this implementation:
     - Connection String will be extended with parameter "no garbage 
collect" (synonym: "nogarbagecollect")
     - Connection String Builder will be extended eigher (.NET property 
- bool name NoGarbageCollect)
     - FbConnectionInternal will add isc_dpb_no_garbace_collect into 
Database Parameter Buffer during BuildDpb method

We use Firebird database for web application, and we run backups every 
night. So we d'like to keep garbage collect for backup and speed-up 
normal operation of web.

Please let me know what you think about it.

Lukáš Vykydal

------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
Edward Mendez | 8 Aug 00:14 2014
Picon

Re: Questions with performance metrics doing large inserts into DB

Hello All,

 

I have to develop an application that will move "old/stale" data from certain tables to another FB DB. We already have an existing application that did something similar to this, but his application is written using Delphi 5 and we are a .NET shop and wanted to develop newer applications using .NET technologies so we can reuse our developer resources. Little by Little we have been migrating off from Delphi5 to .NET.

 

In our shop we are running various instances of FB on 2.14 Classic on CentOS 5.6. Our Database is larger than 250GB.

 

In past .NET projects I have used Dapper dot Net and thought that this might fit the requirements.

 

We developed a working prototype of what we wanted I had our testers run the application to see what they thought. To my dismay, they informed me that the performance was terrible.

In some cases we need to archive millions of rows to the other Database. And it seemed using dapper was not giving us acceptable results. The users said that using the old Delphi applications was quicker when archiving data ( that Delphi application has functionality that also archives different data to other Databases).

 

I wanted to have a baseline test so we can compare apples to apples.

 

I trimmed down the prototype to eliminate Dapper dot net and use straight ADO.NET  for the Inserts using the latest Firebird.NET provider on .NET 4.5.1.

                In the application once the data was retrieved I read it one row at a time, because trying to read in over a million rows into memory would cause Out of Memory issues. A sample of the code I am using is shown below. As I looped over the results, I reported on every 1000 rows and calculated elapsed times every 5000 rows. Running this application from various computers in our infrastructure to various target DBs the best performance I got was 19 seconds for 5000 rows.

 

I then put on my Delphi Hat On and created a small app that did similar to what the .NET app is doing and the Delphi app’s performance blew away the .NET performance with a consistent 5000 rows <at> 4 seconds. This is Delphi5! >From the year 1999. I also have to add that I am using the FIBPlus data components from devrace.

 

Below is an edited version of my .NET code.

 

query = <at> "Select *** Here is my Select Query from the Source DB *** ";

 

// This is using dapper.net to retrieve the rows I need.

var en = db_source.Query<TABLE_A_DTO>(query, new { ARCHIVE_SET_ID = m_archiveSetId, ARCHIVE_DATA_TYPE = _tableName }, srcTransaction, buffered: false);

int totalUpdated = 0;

JobStartTime = DateTime.Now;

try

      {

            using (FbConnection db_target = ((FbConnection)GetConnection(targetDB)))

            {

                  FbTransaction transaction = db_target.BeginTransaction();

                  m_isInTransaction = true;

 

                  using (FbCommand command = new FbCommand(_updateSQL, db_target, transaction))

                  {

                 

                        command.Parameters.Add("TABLE_A_ID", FbDbType.Integer);

                       

                              // There are 86 fields in the result set so i do this 85 more times

                    

                        command.Prepare();

 

                        StepStartTime = DateTime.Now;

                        _logger.Write("ARCHIVING of " + _tableName + " Started", 2);

                        // I get the Enumerator of the results so I can iterate over them

                        _iEnumerator = en.GetEnumerator();

                        while (_iEnumerator.MoveNext())

                        {

                              rowsRead++;

                              var rec = ((TABLE_A_DTO)_iEnumerator.Current);

                              command.Parameters[0].Value = rec.TABLE_A_ID;

                                   

                                    // I do this 85 more times for each parameter

 

                              rowsAffected = command.ExecuteNonQuery();

                              totalUpdated = rowsAffected + totalUpdated;

 

                              if (rowsRead % 1000 == 0)

                                    Console.Write(totalUpdated.ToString() + "\r");

 

                              if (rowsRead % m_recordBufferCount == 0)

                              {

                                    _logger.Write(string.Format("Archived... Rows Archived = {0}, Elasped Time {1}", totalUpdated.ToString("N0"), Utils.GetElapsedTime(DateTime.Now - StepStartTime)), 3);

                                    StepStartTime = DateTime.Now;

                              }

                        }

 

Is the .NET Provider that slow? I am sure that the Database Configuration has something to do with the performance, but If that is true I expected that the Delphi Application show performance results on par with the .NET performance.

 

Am I doing something blatantly wrong code? I would hate to go back to my Boss and tell them that if performance is a factor we need to continue with Delphi.

 

If this open source .NET Provider is not the “fastest on the Block”, are there any other 3rd party Libraries that I can use with .NET that you would recommend? Even if it a commercial product?

 

 

Thanks,

 

Edward Mendez

 

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Lukáš Vykydal (JIRA | 7 Aug 07:20 2014

[FB-Tracker] Created: (DNET-563) Abbility to use "no garbage collect" connection parameter

Abbility to use "no garbage collect" connection parameter
---------------------------------------------------------

                 Key: DNET-563
                 URL: http://tracker.firebirdsql.org/browse/DNET-563
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 4.5.0.0
            Reporter: Lukáš Vykydal
            Assignee: Jiri Cincura
            Priority: Minor

Hi,

we d'like to add support for no garbage collect option to .net provider.

Parameter in connection string will be called "No Garbage Collect".

Can we implement it and send patch ?

Bye

Lukáš Vykydal

--

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Marco Castro - McSoft | 6 Aug 14:46 2014
Picon

Firebird and Generate Views in Visual Studio 2013

I already have runnning EF6 (Firebird provider 4.5) in VS 2013 and there is a single fix to solve. Generate Views of Power Tools Beta 4 shows this message when called to run T4 process:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.Entity.Core.MetadataException: Schema specified is not valid. Errors: Framework.edmx(7,6) : **error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.** at System.Data.Entity.Core.Metadata.Edm.StoreItemCollection.Loader.ThrowOnNonWarningErrors() at System.Data.Entity.Core.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths) at System.Data.Entity.Core.Metadata.Edm.StoreItemCollection.Loader..ctor(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths, Boolean throwOnError, IDbDependencyResolver resolver) at System.Data.Entity.Core.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, IDbDependencyResolver resolver, DbProviderManifest& providerManifest, DbProviderFactory& providerFactory, String& providerInvariantName, String& providerManifestToken, Memoizer`2& cachedCTypeFunction) at System.Data.Entity.Core.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, Object[] args) at Microsoft.DbContextPackage.Utilities.EdmxUtility.GetMappingCollectionEF6(Assembly ef6Assembly, String& containerName) at Microsoft.DbContextPackage.Handlers.OptimizeContextHandler.OptimizeEdmx(String inputPath)

My guess is: EntityFramework.Firebird must be placed where Generate Views runs, where it is installed. What is this path? Where is Generate Views running? EntityFramework.Firebird is addressed at entityFramework but I guess that Power Tools look at machine.config but EntityFramework.Firebird can't be there.

<entityFramework> <defaultConnectionFactory type="FirebirdSql.Data.EntityFramework6.FbConnectionFactory, EntityFramework.Firebird" /> <providers> <provider invariantName="FirebirdSql.Data.FirebirdClient" type="FirebirdSql.Data.EntityFramework6.FbProviderServices, EntityFramework.Firebird" /> </providers> </entityFramework>

Thanks,

Marco Castro

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Ernesto Cullen | 29 Jul 15:27 2014
Picon

Problem reading resources on linux

I've created a small program to test firebird access with an embedded server on linux (with mono), but I am getting errors related to resources.

This is the program:
namespace ConsoleFBTest
{
    class MainClass
    {
        public static void Main (string[] args)
        {
            Console.WriteLine ("Creating database...");
            FbConnection.CreateDatabase("ServerType=1;client library=libfbembed;Dialect=3;Database=test.fdb;User=sysdba;password=masterkey");
        }
    }
}

easy enough, I just want to create a database. I've copied all firebird lib/* files into target dir, along with firebird.msg, security2.fdb, firebird.conf, intl/*. I tested that the embedded server works copying also isql and executing from command line.
When I run previous program, both from MonoDevelop and from command line, I get the output below. I think it may have to do with resources formatting or embedding in the firebird client dll? maybe eol characters? old mono version? running out of ideas here, please help!

Ernesto Cullen


Mono version:
-------------------------------------
mono --version
Mono JIT compiler version 2.10.8 (tarball Mon Apr  7 03:54:27 IST 2014)
Copyright (C) 2002-2011 Novell, Inc, Xamarin, Inc and Contributors. www.mono-project.com
    TLS:           __thread
    SIGSEGV:       altstack
    Notifications: epoll
    Architecture:  amd64
    Disabled:      none
    Misc:          debugger softdebug
    LLVM:          supported, not enabled.
    GC:            Included Boehm (with typed GC and Parallel Mark)

NETProvider: NETProvider-4.2.0.0-MONO_LINUX
Firebird: FirebirdCS-2.5.3.26778-0.amd64


program output
-------------------------------------------------------------------
Creating database...

Unhandled Exception: System.ObjectDisposedException: The object was used after being disposed.
  at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader.LoadResourceValues (.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader+ResourceEnumerator.FillCache () [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader+ResourceEnumerator..ctor (System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader.GetEnumerator () [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetObjectInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetObject (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetStringInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetString (System.String name) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector (System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector (System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer)
  at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString, Int32 pageSize, Boolean forcedWrites, Boolean overwrite) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString) [0x00000] in <filename unknown>:0
  at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in <filename unknown>:0
[ERROR] FATAL UNHANDLED EXCEPTION: System.ObjectDisposedException: The object was used after being disposed.
  at System.IO.UnmanagedMemoryStream.Seek (Int64 offset, SeekOrigin loc) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader.LoadResourceValues (.ResourceCacheItem[] store) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader+ResourceEnumerator.FillCache () [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader+ResourceEnumerator..ctor (System.Resources.ResourceReader readerToEnumerate) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceReader.GetEnumerator () [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.ReadResources () [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetObjectInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetObject (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetStringInternal (System.String name, Boolean ignoreCase) [0x00000] in <filename unknown>:0
  at System.Resources.ResourceSet.GetString (System.String name) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Common.IscException.BuildSqlState () [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Common.IscException.BuildExceptionData () [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesConnection.ParseStatusVector (System.IntPtr[] statusVector, FirebirdSql.Data.Common.Charset charset) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector (System.IntPtr[] statusVector) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesDatabase.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:CreateDatabase (FirebirdSql.Data.Common.DatabaseParameterBuffer)
  at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString, Int32 pageSize, Boolean forcedWrites, Boolean overwrite) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase (System.String connectionString) [0x00000] in <filename unknown>:0
  at ConsoleFBTest.MainClass.Main (System.String[] args) [0x00000] in <filename unknown>:0

--
"Either write something worth reading or do something worth writing" B. Franklin
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Ernesto Cullen | 28 Jul 16:26 2014
Picon

Compiling for mono

Hi all,
  I am trying to port an application using Firebird from Windows (.net 4.0) to Linux under Mono, and I am having problems with the firebird provider.
  I try to compile it using MonoDevelop 5.0 and could not build the project 'FirebirdSql.Data.FirebirdClient'. I get several errors regarding EntityFramework, which I resolved defining 'NET_35' in project options (there are  #if (!(NET_35 && !ENTITY_FRAMEWORK)) directives in several files, but the project had 'NET_40' defined), but I'm still getting errors like 'System.Data.Metadata' namespace not found.

- why is the expression using NET_35? does it compile in .net 4 under mono?
- Is the 'Entity' folder usable/needed under linux?


I removed the 'Entity' folder from the project. Now the build stops saying that 

FirebirdSql.Data.FirebirdClient/FirebirdClient/FbCommand.cs(22,22): Error CS1061: Type `FirebirdSql.Data.FirebirdClient.FbCommand' does not contain a definition for `expectedColumnTypes' and no extension method `expectedColumnTypes' of type `FirebirdSql.Data.FirebirdClient.FbCommand' could be found. Are you missing an assembly reference? (CS1061) (FirebirdSql.Data.FirebirdClient)

Looking at the top of the file I find the definition:

#if (!(NET_35 && !ENTITY_FRAMEWORK))
private Type[] expectedColumnTypes;
#endif

ENTITY_FRAMEWORK is not defined, NET_35 is defined, so the expression evaluates to 

if !(true && true) -> false
so the expectedColumnTypes definition is not compiled.

- is this array needed when Entity_framework is not defined, i.e. in Linux? if so, the expression is wrong. Or,
- if this array is not needed outside Entity framework, its usage should be enclosed in similar #if expression (lines 318, 368)

How do you compile the mono dll included in the release?

thanks,

Ernesto Cullen


--
"Either write something worth reading or do something worth writing" B. Franklin
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
diskuze | 28 Jul 10:36 2014
Picon

ADO.NET provider 4.5.0.0 for Firebird is ready

I'm pleased to announce new version of .NET provider. You can read more at
http://blog.cincura.net/233471-ado-net-provider-4-5-0-0-for-firebird-is-ready/ .

--

-- 
Mgr. Jiri Cincura
Independent IT Specialist

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk

Gmane