firebird-net-provider Mailing List for Firebird (Page 3)

A powerful, cross platform, SQL database system

Brought to you by: alexpeshkoff, asfernandes, awharrison, cincura_net, and 5 others

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

You can subscribe to this list here.

2002	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct (10)	Nov (55)	Dec (36)
2003	Jan (38)	Feb (108)	Mar (79)	Apr (95)	May (64)	Jun (130)	Jul (146)	Aug (121)	Sep (96)	Oct (149)	Nov (161)	Dec (113)
2004	Jan (113)	Feb (163)	Mar (248)	Apr (132)	May (157)	Jun (160)	Jul (236)	Aug (284)	Sep (293)	Oct (277)	Nov (257)	Dec (356)
2005	Jan (203)	Feb (190)	Mar (220)	Apr (165)	May (124)	Jun (160)	Jul (190)	Aug (142)	Sep (152)	Oct (189)	Nov (187)	Dec (159)
2006	Jan (170)	Feb (151)	Mar (212)	Apr (262)	May (226)	Jun (196)	Jul (223)	Aug (165)	Sep (163)	Oct (348)	Nov (225)	Dec (141)
2007	Jan (261)	Feb (161)	Mar (222)	Apr (193)	May (121)	Jun (157)	Jul (151)	Aug (159)	Sep (61)	Oct (123)	Nov (172)	Dec (96)
2008	Jan (104)	Feb (138)	Mar (131)	Apr (131)	May (74)	Jun (107)	Jul (89)	Aug (89)	Sep (172)	Oct (158)	Nov (119)	Dec (86)
2009	Jan (52)	Feb (84)	Mar (78)	Apr (83)	May (54)	Jun (79)	Jul (60)	Aug (62)	Sep (50)	Oct (147)	Nov (50)	Dec (70)
2010	Jan (135)	Feb (113)	Mar (74)	Apr (93)	May (35)	Jun (71)	Jul (33)	Aug (110)	Sep (47)	Oct (18)	Nov (61)	Dec (34)
2011	Jan (46)	Feb (47)	Mar (25)	Apr (24)	May (21)	Jun (22)	Jul (20)	Aug (51)	Sep (31)	Oct (42)	Nov (22)	Dec (22)
2012	Jan (31)	Feb (19)	Mar (25)	Apr (55)	May (16)	Jun (28)	Jul (33)	Aug (25)	Sep (32)	Oct (25)	Nov (52)	Dec (35)
2013	Jan (43)	Feb (18)	Mar (36)	Apr (45)	May (22)	Jun (13)	Jul (31)	Aug (24)	Sep (19)	Oct (59)	Nov (47)	Dec (25)
2014	Jan (27)	Feb (15)	Mar (38)	Apr (10)	May (15)	Jun (36)	Jul (24)	Aug (28)	Sep (16)	Oct (6)	Nov (44)	Dec (40)
2015	Jan (52)	Feb (22)	Mar (13)	Apr (17)	May (22)	Jun (36)	Jul (18)	Aug (41)	Sep (71)	Oct (60)	Nov (49)	Dec (43)
2016	Jan (60)	Feb (13)	Mar (21)	Apr (28)	May (23)	Jun (39)	Jul (17)	Aug (37)	Sep (33)	Oct (15)	Nov (22)	Dec (20)
2017	Jan (27)	Feb (40)	Mar (48)	Apr (19)	May (29)	Jun (2)	Jul (19)	Aug (36)	Sep (18)	Oct (10)	Nov (11)	Dec (5)
2018	Jan (5)	Feb (4)	Mar (5)	Apr (3)	May (4)	Jun (17)	Jul (7)	Aug (7)	Sep (12)	Oct (8)	Nov (2)	Dec
2019	Jan (8)	Feb (5)	Mar (3)	Apr (5)	May (3)	Jun (2)	Jul (8)	Aug (7)	Sep (3)	Oct (12)	Nov (7)	Dec (1)
2020	Jan (8)	Feb (3)	Mar (7)	Apr (1)	May (2)	Jun (1)	Jul (3)	Aug (25)	Sep (5)	Oct (3)	Nov (7)	Dec (16)
2021	Jan (11)	Feb (10)	Mar (16)	Apr (8)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

Flat | Threaded

<< < 1 2 3 4 5 .. 646 > >> (Page 3 of 646)

[Firebird-net-provider] [FB-Tracker] Created: (DNET-991) External functions/procedures/triggers in FbSchema

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-16 10:13:06

External functions/procedures/triggers in FbSchema
--------------------------------------------------

                 Key: DNET-991
                 URL: http://tracker.firebirdsql.org/browse/DNET-991
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 7.10.1.0, 7.10.0.0, 7.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor




-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-992) Functions (SQL functions) in FbSchema

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-16 10:13:03

Functions (SQL functions) in FbSchema
-------------------------------------

                 Key: DNET-992
                 URL: http://tracker.firebirdsql.org/browse/DNET-992
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 7.10.1.0, 7.10.0.0, 7.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor




-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-990) [Firebird 4] Numeric/Decimal support with 19-38 precision

From: mace w. (JIRA) <tr...@fi...> - 2020-12-14 11:13:08

[Firebird 4] Numeric/Decimal support with 19-38 precision
---------------------------------------------------------

                 Key: DNET-990
                 URL: http://tracker.firebirdsql.org/browse/DNET-990
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.10.1.0, 7.10.0.0
         Environment: Firebird 4.0 beta 2
            Reporter: mace windu
            Assignee: Jiri Cincura


Looks like support  for increased precision for numeric/decimal types in Firebird 4 is currently missing as quering data of such type results in exception.

ArgumentOutOfRangeException: 'type=32752 ' (or 32753 when reading from table column)
   at FirebirdSql.Data.Client.Managed.XdrReaderWriter.ReadDecimal(Int32 type, Int32 scale)


using (var cn = new FbConnection("..."))
{
  cn.Open();
  using (var cmd = cn.CreateCommand())
  {
    cmd.CommandText = "SELECT CAST(1 AS NUMERIC(19)) FROM RDB$DATABASE";
    using (var rd = cmd.ExecuteReader())
    {
      while (rd.Read())
      { }
    }
  }
}

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-989) Relax handling of timezones and their IDs

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-14 10:38:10

Relax handling of timezones and their IDs
-----------------------------------------

                 Key: DNET-989
                 URL: http://tracker.firebirdsql.org/browse/DNET-989
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 7.10.1.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


It should be possible to handle unknown timezone > ID and vice versa. I.e. user uses custom TZs definitions or Firebird was updated not not yet FirebirdClient in the app. Probably as a 2nd option, not as a first class citizen.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-988) Improve tests execution time

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-14 09:13:09

Improve tests execution time
----------------------------

                 Key: DNET-988
                 URL: http://tracker.firebirdsql.org/browse/DNET-988
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider, Entity Framework, Entity Framework Core
    Affects Versions: 7.10.1.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


At the moment the full tests suite runs a lot of tests in a lot of configurations. The aim of this task is to simplify this a possibly improve the overall time to run all or subset of tests.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-987) Unknown time zone ID.

From: fish (JIRA) <tr...@fi...> - 2020-12-05 01:56:43

Unknown time zone ID.
---------------------

                 Key: DNET-987
                 URL: http://tracker.firebirdsql.org/browse/DNET-987
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.10.1.0
         Environment: Windows 10, Firebird 4.0.0.2136 embedded
            Reporter: fish
            Assignee: Jiri Cincura


Execute the statement: SELECT * FROM "RDB$TRANSACTIONS"
Got the error message: Unknown time zone ID.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-986) Validate leading zeros handling in Srp SHA

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-04 18:48:34

Validate leading zeros handling in Srp SHA
------------------------------------------

                 Key: DNET-986
                 URL: http://tracker.firebirdsql.org/browse/DNET-986
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 7.10.1.0, 7.10.0.0, 7.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


As reported in JDBC-635.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-985) Exception when setting FbDbType from enum value for FbParameter

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-04 17:46:40

Exception when setting FbDbType from enum value for FbParameter
---------------------------------------------------------------

                 Key: DNET-985
                 URL: http://tracker.firebirdsql.org/browse/DNET-985
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.10.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


Stack:
Unhandled exception. System.ArgumentException: Unknown type: Xxx.
   at FirebirdSql.Data.Common.TypeHelper.GetFbDataTypeFromType(Type type)
   at FirebirdSql.Data.FirebirdClient.FbParameter.SetFbDbType(Object value)
   at FirebirdSql.Data.FirebirdClient.FbParameter.set_Value(Object value)

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-984) Add nullable reference type (NRT) annotations

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-04 09:44:41

Add nullable reference type (NRT) annotations
---------------------------------------------

                 Key: DNET-984
                 URL: http://tracker.firebirdsql.org/browse/DNET-984
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider, Entity Framework, Entity Framework Core
    Affects Versions: 7.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


Add nullable reference type (NRT) annotations

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-983) Support for packages in FbSchema, etc.

From: Jiri C. (JIRA) <tr...@fi...> - 2020-12-01 12:11:48

Support for packages in FbSchema, etc.
--------------------------------------

                 Key: DNET-983
                 URL: http://tracker.firebirdsql.org/browse/DNET-983
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


Support for packages in FbSchema, etc.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-982) After upgrad to .NET 5 the FirebirdSql.EntityFrameworkCore.Firebird not work

From: Roberto C. da S. (JIRA) <tr...@fi...> - 2020-11-27 19:19:45

After upgrad to .NET 5 the FirebirdSql.EntityFrameworkCore.Firebird not work
----------------------------------------------------------------------------

                 Key: DNET-982
                 URL: http://tracker.firebirdsql.org/browse/DNET-982
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
         Environment: Visual Studio 2019, net5.0, Asp.net 5, FirebirdSql.EntityFrameworkCore.Firebird 7.5.0, Firebird 3.0.7, aspnetboilerplate 6.0
            Reporter: Roberto Carlos da Silva
            Assignee: Jiri Cincura


System.MissingMethodException
  HResult=0x80131513
  Message=Method not found: 'Void Microsoft.EntityFrameworkCore.Storage.DecimalTypeMapping..ctor(System.String, System.Nullable`1<System.Data.DbType>)'.
  Source=FirebirdSql.EntityFrameworkCore.Firebird
  StackTrace:
   at FirebirdSql.EntityFrameworkCore.Firebird.Storage.Internal.FbTypeMappingSource..ctor(TypeMappingSourceDependencies dependencies, RelationalTypeMappingSourceDependencies relationalDependencies)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitRootCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetService[T](IServiceProvider provider)
   at Microsoft.EntityFrameworkCore.Infrastructure.EntityFrameworkRelationalServicesBuilder.<>c.<TryAddCoreServices>b__3_0(IServiceProvider p)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitRootCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetService[T](IServiceProvider provider)
   at Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel()
   at Microsoft.EntityFrameworkCore.Internal.DbContextServices.get_Model()
   at Microsoft.EntityFrameworkCore.Infrastructure.EntityFrameworkServicesBuilder.<>c.<TryAddCoreServices>b__7_3(IServiceProvider p)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
   at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider()
   at Microsoft.EntityFrameworkCore.DbContext.Microsoft.EntityFrameworkCore.Infrastructure.IInfrastructure<System.IServiceProvider>.get_Instance()
   at Microsoft.EntityFrameworkCore.Infrastructure.Internal.InfrastructureExtensions.GetService[TService](IInfrastructure`1 accessor)
   at Microsoft.EntityFrameworkCore.Infrastructure.AccessorExtensions.GetService[TService](IInfrastructure`1 accessor)
   at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.get_Dependencies()
   at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.CreateExecutionStrategy()
   at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.BeginTransaction(DatabaseFacade databaseFacade, IsolationLevel isolationLevel)
   at Abp.EntityFrameworkCore.Uow.DbContextEfCoreTransactionStrategy.CreateDbContext[TDbContext](String connectionString, IDbContextResolver dbContextResolver)
   at Abp.EntityFrameworkCore.Uow.EfCoreUnitOfWork.GetOrCreateDbContext[TDbContext](Nullable`1 multiTenancySide, String name)
   at Abp.EntityFrameworkCore.Uow.UnitOfWorkExtensions.GetDbContext[TDbContext](IActiveUnitOfWork unitOfWork, Nullable`1 multiTenancySide, String name)
   at NidaTech.DadosPublicos.EntityFrameworkCore.Seed.SeedHelper.WithDbContext[TDbContext](IIocResolver iocResolver, Action`1 contextAction) in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\Seed\SeedHelper.cs:line 42
   at NidaTech.DadosPublicos.EntityFrameworkCore.Seed.SeedHelper.SeedHostDb(IIocResolver iocResolver) in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\Seed\SeedHelper.cs:line 17
   at NidaTech.DadosPublicos.EntityFrameworkCore.DadosPublicosEntityFrameworkModule.PostInitialize() in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\DadosPublicosEntityFrameworkModule.cs:line 48
   at Abp.Modules.AbpModuleManager.<>c.<StartModules>b__15_2(AbpModuleInfo module)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Abp.Modules.AbpModuleManager.StartModules()
   at Abp.AbpBootstrapper.Initialize()


-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-981) After upgrad to .NET 5 the FirebirdSql.EntityFrameworkCore.Firebird not work any more

From: Roberto C. da S. (JIRA) <tr...@fi...> - 2020-11-27 18:24:45

After upgrad to .NET 5 the FirebirdSql.EntityFrameworkCore.Firebird not work any more
-------------------------------------------------------------------------------------

                 Key: DNET-981
                 URL: http://tracker.firebirdsql.org/browse/DNET-981
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework Core
    Affects Versions: 7.5.0.0
         Environment: Visual Studio 2010, net5.0, Asp.net 5, FirebirdSql.EntityFrameworkCore.Firebird 7.5.0, Firebird 3.0.7, aspnetboilerplate 6.0
            Reporter: Roberto Carlos da Silva
            Assignee: Jiri Cincura


System.IO.FileNotFoundException
  HResult=0x80070002
  Message=Could not load file or assembly 'Microsoft.Bcl.HashCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.
  Source=FirebirdSql.EntityFrameworkCore.Firebird
  StackTrace:
   at FirebirdSql.EntityFrameworkCore.Firebird.Infrastructure.Internal.FbOptionsExtension.ExtensionInfo.GetServiceProviderHashCode()
   at Microsoft.EntityFrameworkCore.Internal.ServiceProviderCache.<>c.<GetOrAdd>b__4_1(Int64 t, IDbContextOptionsExtension e)
   at System.Linq.Enumerable.Aggregate[TSource,TAccumulate](IEnumerable`1 source, TAccumulate seed, Func`3 func)
   at Microsoft.EntityFrameworkCore.Internal.ServiceProviderCache.GetOrAdd(IDbContextOptions options, Boolean providerRequired)
   at Microsoft.EntityFrameworkCore.DbContext..ctor(DbContextOptions options)
   at Abp.EntityFrameworkCore.AbpDbContext..ctor(DbContextOptions options)
   at Abp.Zero.EntityFrameworkCore.AbpZeroCommonDbContext`3..ctor(DbContextOptions`1 options)
   at Abp.Zero.EntityFrameworkCore.AbpZeroDbContext`4..ctor(DbContextOptions`1 options)
   at NidaTech.DadosPublicos.EntityFrameworkCore.DadosPublicosDbContext..ctor(DbContextOptions`1 options) in C:\Users\rober\source\repos\dados-publicos-pj\src\NidaTech.DadosPublicos.EntityFrameworkCore\EntityFrameworkCore\DadosPublicosDbContext.cs:line 38
   at Castle.Core.Internal.ReflectionUtil.Instantiate[TBase](Type subtypeofTBase, Object[] ctorArgs)
   at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstanceCore(ConstructorCandidate constructor, Object[] arguments, Type implType)


-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-980) Cast of string values to VARCHAR(8191) results in "Implementation limit exceeded"

From: Andrey B. (JIRA) <tr...@fi...> - 2020-11-23 10:09:10

 Cast of string values to VARCHAR(8191) results in "Implementation limit exceeded"
----------------------------------------------------------------------------------

                 Key: DNET-980
                 URL: http://tracker.firebirdsql.org/browse/DNET-980
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework Core
    Affects Versions: 7.5.0.0
            Reporter: Andrey Belov
            Assignee: Jiri Cincura


Generated database query:
SELECT "d"."DOCUMENTDATAID", "d"."ADD_DATE", "d"."AGENCY_CODE", "d"."DOCTYPEID", "d"."END_DATE", "d"."ISACTIVE", "d"."ISMAIN", "d"."ISSUED_BY", "d"."ISSUED_DATE", "d"."MILITARY_RANK_ID", "d"."NUMBER", "d"."PATIENTID", "d"."SERIES", "d"."USERID"
FROM "DOCUMENTDATA" AS "d"
WHERE ("d"."SERIES" = CAST(@__obj_Series_0 AS VARCHAR(8191))) AND ("d"."NUMBER" = CAST(@__obj_Number_1 AS VARCHAR(8191)))

Full log:
queryContext => new QueryingEnumerable<DocumentData>(
    (RelationalQueryContext)queryContext, 
    RelationalCommandCache, 
    null, 
    null, 
    Func<QueryContext, DbDataReader, ResultContext, int[], ResultCoordinator, DocumentData>, 
    FbDataBase.Contexts.FbContext, 
    DiagnosticsLogger<Query>)

Creating DbCommand for 'ExecuteReader'.
Created DbCommand for 'ExecuteReader' (1ms).
Opening connection to database 'udc' on server 'localhost'.
Opened connection to database 'udc' on server 'localhost'.

Executing DbCommand [Parameters=[@__obj_Series_0='?' (Size = 4), @__obj_Number_1='?' (Size = 6)], CommandType='Text', CommandTimeout='30']
SELECT "d"."DOCUMENTDATAID", "d"."ADD_DATE", "d"."AGENCY_CODE", "d"."DOCTYPEID", "d"."END_DATE", "d"."ISACTIVE", "d"."ISMAIN", "d"."ISSUED_BY", "d"."ISSUED_DATE", "d"."MILITARY_RANK_ID", "d"."NUMBER", "d"."PATIENTID", "d"."SERIES", "d"."USERID"
FROM "DOCUMENTDATA" AS "d"
WHERE ("d"."SERIES" = CAST(@__obj_Series_0 AS VARCHAR(8191))) AND ("d"."NUMBER" = CAST(@__obj_Number_1 AS VARCHAR(8191)))
Failed executing DbCommand (29ms) [Parameters=[@__obj_Series_0='?' (Size = 4), @__obj_Number_1='?' (Size = 6)], CommandType='Text', CommandTimeout='30']

SELECT "d"."DOCUMENTDATAID", "d"."ADD_DATE", "d"."AGENCY_CODE", "d"."DOCTYPEID", "d"."END_DATE", "d"."ISACTIVE", "d"."ISMAIN", "d"."ISSUED_BY", "d"."ISSUED_DATE", "d"."MILITARY_RANK_ID", "d"."NUMBER", "d"."PATIENTID", "d"."SERIES", "d"."USERID"
FROM "DOCUMENTDATA" AS "d"
WHERE ("d"."SERIES" = CAST(@__obj_Series_0 AS VARCHAR(8191))) AND ("d"."NUMBER" = CAST(@__obj_Number_1 AS VARCHAR(8191)))

Closing connection to database 'udc' on server 'localhost'.
Closed connection to database 'udc' on server 'localhost'.

An exception occurred while iterating over the results of a query for context type 'FbDataBase.Contexts.FbContext'.
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
 ---> Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result)
   at Microsoft.EntityFrameworkCore.Storage.Internal.NoopExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()

'FbContext' disposed.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-979) Any and AnyAsync Dynamic SQL Error

From: Benjamyn W. (JIRA) <tr...@fi...> - 2020-11-21 06:21:20

Any and AnyAsync Dynamic SQL Error
----------------------------------

                 Key: DNET-979
                 URL: http://tracker.firebirdsql.org/browse/DNET-979
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework
    Affects Versions: 7.5.0.0
         Environment: Core 3.1, EFCore 3.1.10, Firebird 2.5
            Reporter: Benjamyn Williams
            Assignee: Jiri Cincura


When using Any and AnyAsync against a DbSet it results in:

Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 8
EXISTS

Generated query:

SELECT EXISTS (
    SELECT 1
    FROM "TEST_TABLE" AS "t") FROM RDB$DATABASE

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-978) Using async methods results in VHO:Trojan.Win32.Sdum.gen

From: Marvin K. (JIRA) <tr...@fi...> - 2020-11-12 12:43:38

Using async methods results in VHO:Trojan.Win32.Sdum.gen
--------------------------------------------------------

                 Key: DNET-978
                 URL: http://tracker.firebirdsql.org/browse/DNET-978
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
         Environment: Windows 10 Profesiional 2004, Visual Studio 2019 16.8
C# 9 with nullable enabled
            Reporter: Marvin Klein
            Assignee: Jiri Cincura
            Priority: Minor


Hi there,

I am using Firebird ADO.NET in my C# application. Since I switched my code from synchronous to asynchronous code I am getting a trojan alert from Kaspersky Total Security, every time I open a connection.

The code I am using is:
// This works fine
using (FbConnection connection = new FbConnection(ConnectionString))
{
	connection.Open();
	using (FbCommand cmd = connection.CreateCommand())
	{
		cmd.CommandText = "SELECT * FROM PERSONAL";
		cmd.ExecuteNonQuery();
	}

}

// This results in trojan alert from Kaspersky
using (FbConnection connection = new FbConnection(ConnectionString))
{
	await connection.OpenAsync();
	using (FbCommand cmd = connection.CreateCommand())
	{
		cmd.CommandText = "SELECT * FROM PERSONAL";
		await cmd.ExecuteNonQueryAsync();
	}

}

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-977) Add support for FbDataAdapter FillAsync

From: Marvin K. (JIRA) <tr...@fi...> - 2020-11-06 16:25:40

Add support for FbDataAdapter FillAsync
---------------------------------------

                 Key: DNET-977
                 URL: http://tracker.firebirdsql.org/browse/DNET-977
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
            Reporter: Marvin Klein
            Assignee: Jiri Cincura


Please add the method FillAsync to the FbDataAdapter, just like it is available in MysqlDataAdapater, to make it easier to fill a data source asynchronous.

This should help all web developers who need to work  with Firebird databases.



-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-976) Parameterized LIKE results in fail

From: Marvin K. (JIRA) <tr...@fi...> - 2020-11-06 16:19:53

Parameterized LIKE results in fail
----------------------------------

                 Key: DNET-976
                 URL: http://tracker.firebirdsql.org/browse/DNET-976
             Project: .NET Data provider
          Issue Type: Bug
          Components: NuGet packages
    Affects Versions: 7.5.0.0
         Environment: Windows 10 2004, Visual Studio 2019 Community Edition 16.7.7

Server runs on Windows Server 2019
Firbird Server 2.5.9
            Reporter: Marvin Klein
            Assignee: Jiri Cincura


Consider the following scenario.

Table: CUSTOMERS
Fields: 
CUSTOMER_FIRSTNAME VARCHAR(10)
CUSTOMER_LASTNAME VARCHAR(15)

Now I have the follwing C# code 

// Create connection
// Create Command
command.Parameters.AddWithValue("@SEARCH", $"%{search.ToUpper()}%");
command.CommandText = "SELECT * FROM CUSTOMERS WHERE CUSTOMER_FIRSTNAME LIKE @SEARCH OR CUSTOMER_LASTNAME  LIKE @SEARCH";
command.ExecuteQuery(); // do something with the command. This works fine as long as my parameter search does not exceed 10 characters. 

When you try this command with more than 10 characters, you get an exception. However, doing the following does not result in an exception:
command.CommandText = $"SELECT * FROM CUSTOMERS WHERE CUSTOMER_FIRSTNAME LIKE '%{search.ToUpper()}%' OR CUSTOMER_LASTNAME  LIKE '%{search.ToUpper()}%' ";
command.ExecuteQuery(); // do something with the command, no exception

But using this way I am vulnerable to SQL-Injections. 





-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-975) EF Core 5.0 support

From: Jiri C. (JIRA) <tr...@fi...> - 2020-10-12 18:12:28

EF Core 5.0 support
-------------------

                 Key: DNET-975
                 URL: http://tracker.firebirdsql.org/browse/DNET-975
             Project: .NET Data provider
          Issue Type: New Feature
          Components: Entity Framework Core
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura




-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-974) Parameter prefix being swapped between ":" and "@" carrying over to other concurrently generated queries.

From: Benjamyn W. (JIRA) <tr...@fi...> - 2020-10-08 00:21:36

Parameter prefix being swapped between ":" and "@" carrying over to other concurrently generated queries.
---------------------------------------------------------------------------------------------------------

                 Key: DNET-974
                 URL: http://tracker.firebirdsql.org/browse/DNET-974
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
         Environment: Windows Core 3.1/5.0/Framework 4.8
            Reporter: Benjamyn Williams
            Assignee: Jiri Cincura
            Priority: Critical


Error is described in this "Resolved" issue http://tracker.firebirdsql.org/browse/DNET-945
Critical as this is affecting medical information.

This is an error with concurrent query generation due to the changing of sqlGenerationHelper.ParameterNameMarker in  the singleton DbUpdateSqlGenerator within methods AppendUpdateOperation and AppendDeleteOperation when queries are being constructed concurrently.
This has caused mismatches between parameters and the query text where the query would be referring to "@p0" while the parameters object has ":p0".

This needs to be solved so that changing the ParameterNameMarker for named parameters will not affect other concurrent query generation.

Confirmed this by redirecting those particular parts (extracting the internal methods that EF uses) to a new version of sqlGenerationHelper (As it required no dependencies) with ":" instead of using the current one.
The test project on the previous issue was able to replicate this.


-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-973) Add support for Srp256 authentication plugin

From: Luciano M. (JIRA) <tr...@fi...> - 2020-10-06 00:47:46

Add support for Srp256 authentication plugin
--------------------------------------------

                 Key: DNET-973
                 URL: http://tracker.firebirdsql.org/browse/DNET-973
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
            Reporter: Luciano Mendes
            Assignee: Jiri Cincura


The Firebird 3.0.4 introduced a security patch to support Srp256 authentication plugin (see: https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-security-new-authentication.html#rnfb30-security-srp-patch304)
The native firebird client library (fbclient.dll) and JDBC (JDBC-536) already support Srp256 authentication but the ADO.NET provider is not yet support it.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-972) AppendSQLStatements - drop/create index exception in use

From: Marcos R. W. (JIRA) <tr...@fi...> - 2020-09-29 17:37:40

AppendSQLStatements - drop/create index exception in use
--------------------------------------------------------

                 Key: DNET-972
                 URL: http://tracker.firebirdsql.org/browse/DNET-972
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
         Environment: - Visual Studio 2019 Community,
- Net FrameWork 4.5.2
- FirebirdSql.Data.FirebirdClient 6.4.0 / 7.5.0
            Reporter: Marcos R. Weimer
            Assignee: Jiri Cincura


Delete a second index (unique desc) in the PK and create it again (desc). It is not the PK index, it is a secondary index in field.
Execute at IBExpert works perfectly.

Code:

ASQL = " SET TERM ^ ;
EXECUTE BLOCK AS
BEGIN
    IF(EXISTS(SELECT 1
              FROM RDB$INDICES
              WHERE UPPER(RDB$INDEX_NAME) = 'PK_PARCEIROS_DESC')) THEN
    BEGIN
      EXECUTE STATEMENT 'DROP INDEX PK_PARCEIROS_DESC;';
      EXECUTE STATEMENT 'CREATE DESCENDING INDEX PK_PARCEIROS_DESC ON PARCEIROS (PARCEIRO);';	  
    END
END^
 SET TERM ; ^"

 FbScript sc = new FbScript(ASql);
 sc.Parse();

  FbBatchExecution fbe = new FbBatchExecution(FConexao); 
  fbe.AppendSqlStatements(sc);
   fbe.Execute();

Exeption:

"An exception was thrown when executing command:  -- Author: Thiago Cousseau\r\n-- 2589\r\n-- 24/07/2020\r\n-- Description: Já existe o indice da PK\r\nEXECUTE BLOCK AS\r\nBEGIN\r\n    IF(EXISTS(SELECT 1\r\n              FROM RDB$INDICES\r\n              WHERE UPPER(RDB$INDEX_NAME) = 'PK_PARCEIROS_DESC')) THEN\r\n    BEGIN\r\n      EXECUTE STATEMENT ('DROP INDEX PK_PARCEIROS_DESC;') WITH AUTONOMOUS TRANSACTION;\r\n      EXECUTE STATEMENT ('CREATE DESCENDING INDEX PK_PARCEIROS_DESC ON PARCEIROS (PARCEIRO);') WITH AUTONOMOUS TRANSACTION;\t  \r\n    END\r\nEND.\r\nBatch execution aborted.\r\nThe returned message was: unsuccessful metadata update\r\nobject INDEX \"PK_PARCEIROS_DESC\" is in use\r\nAt block line: 11, col: 7."


StackTrace:

   em FirebirdSql.Data.Isql.FbBatchExecution.Execute(Boolean autoCommit)
   em UltraBanco.Banco.ExecuteScript(String ASql) em C:\Ultra\CSharp\UltraBanco\UltraBanco.cs:linha 576
   em UltraAtualizador.Funcoes.AtualizarSistema(DataRow LinhaAtual, Int32 UltimaVersaoBanco, List`1 executaveisBaixar, DataTable excecoes, String nomeArquivoZip, List`1 EMailEquipe, Boolean VerificarConexoesAtivas, Boolean& aAtualizarFirebird) em C:\Ultra\CSharp\UltraAtualizador\Funcoes.cs:linha 586

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-971) Support for bulk inserts in Firebird 4

From: Jaromir F. (JIRA) <tr...@fi...> - 2020-09-25 21:29:31

Support for bulk inserts in Firebird 4
--------------------------------------

                 Key: DNET-971
                 URL: http://tracker.firebirdsql.org/browse/DNET-971
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: vNext
            Reporter: Jaromir Flidr
            Assignee: Jiri Cincura


As far as I can see the "bulk inserts" are supported in Firebird 4, see CORE-820. Is there a plan/timescale when this would be also supported in C#?

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-970) Lock in connection pool held for too long

From: Jiri C. (JIRA) <tr...@fi...> - 2020-09-21 12:44:54

Lock in connection pool held for too long
-----------------------------------------

                 Key: DNET-970
                 URL: http://tracker.firebirdsql.org/browse/DNET-970
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 7.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


The lock in `GetConnection` is held even as the `FbConnectionInternal.Connect` is performed. It can be released sooner and the remaining "plumbing" work can be done outside the lock. This observation comes from https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/105.

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-969) GFix force sweep

From: Alexander M. (JIRA) <tr...@fi...> - 2020-09-18 10:34:11

GFix force sweep
----------------

                 Key: DNET-969
                 URL: http://tracker.firebirdsql.org/browse/DNET-969
             Project: .NET Data provider
          Issue Type: New Feature
            Reporter: Alexander Muylaert
            Assignee: Jiri Cincura


Do a sweep is ot possible through the services

-- 
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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-968) Support for command timeout in connection string

From: Jiri C. (JIRA) <tr...@fi...> - 2020-09-13 13:50:55

Support for command timeout in connection string
------------------------------------------------

                 Key: DNET-968
                 URL: http://tracker.firebirdsql.org/browse/DNET-968
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider, Entity Framework Core
    Affects Versions: 7.5.0.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


https://github.com/dotnet/efcore/issues/22301#issuecomment-691303890

-- 
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

211 messages has been excluded from this view by a project administrator.

Flat | Threaded

<< < 1 2 3 4 5 .. 646 > >> (Page 3 of 646)