Menu
▾
▴
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-08-13 14:11:22
|
Support 48 bit (technically 64 bit) transaction ids
---------------------------------------------------
Key: DNET-896
URL: http://tracker.firebirdsql.org/browse/DNET-896
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: 6.7.0.0
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-08-12 11:37:24
|
Using TraceSource (TraceHelper) is slow
---------------------------------------
Key: DNET-895
URL: http://tracker.firebirdsql.org/browse/DNET-895
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
The usage of TraceSource via TraceHelper is slow, which is especially visible in LogCommand as it's called from Prepare.
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-08-08 09:25:27
|
Trusted Auth support for FbService
----------------------------------
Key: DNET-894
URL: http://tracker.firebirdsql.org/browse/DNET-894
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 6.7.0.0
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
|
|
From: LC A. T. (JIRA) <tr...@fi...> - 2019-08-08 09:13:47
|
Trusted Authentication fails with Code First
--------------------------------------------
Key: DNET-893
URL: http://tracker.firebirdsql.org/browse/DNET-893
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 6.7.0.0
Environment: Windows 10, Firebird Super Server 2.5, Visual Studio 2019, Entity Framework 6.1.3, Code First
Reporter: LC Arch Team
Assignee: Jiri Cincura
*Observed Behavior:
Querying the database via LINQ to entities fails with an InvalidOperationException: No user name was specified.
*Expected Behavior*
No exception
*Cause*
FbProviderServices.GetDbProviderManifestToken creates a new connection through FbServerProperties if the given DbConnection is not already open. FbServerProperties, or more specifically its base classe, FbService does not support Trusted Authentication. FbService.Open specifically checks for the existence of a user name and password and throws an exception.
FbService.cs:
{code}
protected void Open()
{
if (State != FbServiceState.Closed)
throw new InvalidOperationException("Service already Open.");
if (string.IsNullOrEmpty(_csManager.UserID))
throw new InvalidOperationException("No user name was specified.");
if (string.IsNullOrEmpty(_csManager.Password))
throw new InvalidOperationException("No user password was specified.");
{code}
By contrast, FbConnectionInternal first checks for the existence of a user name and password, and branches into trusted authentication.
FbConnectionInternal.cs:
{code}
public void Connect()
{
if (Charset.GetCharset(this.options.Charset) == null)
throw new FbException("Invalid character set specified");
try
{
this.db = ClientFactory.CreateDatabase(this.options);
this.db.Charset = Charset.GetCharset(this.options.Charset);
this.db.Dialect = (short) this.options.Dialect;
this.db.PacketSize = this.options.PacketSize;
DatabaseParameterBuffer dpb = this.BuildDpb(this.db, this.options);
if (this.options.FallIntoTrustedAuth)
this.db.AttachWithTrustedAuth(dpb, this.options.DataSource, this.options.Port, this.options.Database);
else
this.db.Attach(dpb, this.options.DataSource, this.options.Port, this.options.Database);
}
{code}
*Workaround*
Opening the connection manually before passing it into DbContext is a workaround.
*Stack Trace*
> FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.Open() Line 108 C#
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.QueryService(byte[] items) Line 346 C#
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.ProcessQuery(byte[] items, System.Action<bool, object> queryResponseAction) Line 235 C#
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.Query(byte[] items) Line 199 C#
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbServerProperties.GetInfo(int item) Line 87 C#
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbServerProperties.GetString(int item) Line 77 C#
EntityFramework.Firebird.dll!FirebirdSql.Data.EntityFramework6.FbProviderServices.GetDbProviderManifestToken(System.Data.Common.DbConnection connection) Line 154 C#
EntityFramework.dll!System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(System.Data.Common.DbConnection connection) Unknown
EntityFramework.dll!System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(System.Data.Entity.Core.Common.DbProviderServices providerServices, System.Data.Common.DbConnection connection) Unknown
mscorlib.dll!System.Collections.Concurrent.ConcurrentDictionary<System.Tuple<System.Type, string, string>, string>.GetOrAdd(System.Tuple<System.Type, string, string> key, System.Func<System.Tuple<System.Type, string, string>, string> valueFactory) Unknown
EntityFramework.dll!System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(System.Data.Common.DbConnection connection, out System.Data.Entity.Core.Common.DbProviderManifest providerManifest) Unknown
EntityFramework.dll!System.Data.Entity.DbModelBuilder.Build(System.Data.Common.DbConnection providerConnection) Unknown
EntityFramework.dll!System.Data.Entity.Internal.LazyInternalContext.CreateModel(System.Data.Entity.Internal.LazyInternalContext internalContext) Unknown
EntityFramework.dll!System.Data.Entity.Internal.RetryLazy<System.Data.Entity.Internal.LazyInternalContext, System.Data.Entity.Infrastructure.DbCompiledModel>.GetValue(System.Data.Entity.Internal.LazyInternalContext input) Unknown
EntityFramework.dll!System.Data.Entity.Internal.LazyInternalContext.InitializeContext() Unknown
EntityFramework.dll!System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(System.Type entityType) Unknown
EntityFramework.dll!System.Data.Entity.Internal.Linq.InternalSet<Settings.DataAccess.Entities.SettingEntity>.Initialize() Unknown
EntityFramework.dll!System.Data.Entity.Internal.Linq.InternalSet<Settings.DataAccess.Entities.SettingEntity>.InternalContext.get() Unknown
EntityFramework.dll!System.Data.Entity.Infrastructure.DbQuery<Settings.DataAccess.Entities.SettingEntity>.System.Linq.IQueryable.Provider.get() Unknown
System.Core.dll!System.Linq.Queryable.Where<Settings.DataAccess.Entities.SettingEntity>(System.Linq.IQueryable<Settings.DataAccess.Entities.SettingEntity> source, System.Linq.Expressions.Expression<System.Func<Settings.DataAccess.Entities.SettingEntity, bool>> predicate) Unknown
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-08-05 09:02:25
|
Connection string "database" parsing ambiguity
----------------------------------------------
Key: DNET-892
URL: http://tracker.firebirdsql.org/browse/DNET-892
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 6.7.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
@"database=C:\TEST.FDB":
DataSource=>localhost and Database=>C:\TEST.FDB
@"database=test:C:\TEST.FDB":
DataSource=>test and Database=>C:\TEST.FDB
Hence the first example could also be equivalent to this:
@"datasource=C;database=\TEST.FDB"
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-07-30 11:32:26
|
Drop methods BeginXxx/EndXxx on FbCommand #breaking
---------------------------------------------------
Key: DNET-891
URL: http://tracker.firebirdsql.org/browse/DNET-891
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 6.7.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
These methods were never actually properly done and with async/await they make little sense (and proper async code paths should be implemented).
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-07-26 10:23:22
|
Support for EventCounters in .NET Core
--------------------------------------
Key: DNET-890
URL: http://tracker.firebirdsql.org/browse/DNET-890
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: 6.7.0.0
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-07-16 07:31:27
|
Support for wire encryption and Sspi
------------------------------------
Key: DNET-889
URL: http://tracker.firebirdsql.org/browse/DNET-889
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: 6.6.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
QueryContextAttributes(&ctxtHndl, SECPKG_ATTR_SESSION_KEY, &key)
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-07-15 10:05:23
|
PackageDescription should be Description
----------------------------------------
Key: DNET-888
URL: http://tracker.firebirdsql.org/browse/DNET-888
Project: .NET Data provider
Issue Type: Bug
Components: NuGet packages
Affects Versions: 6.6.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Trivial
--
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
|
|
From: Darko I. (JIRA) <tr...@fi...> - 2019-07-11 21:48:27
|
Database file is not released after closing embedded server connection
----------------------------------------------------------------------
Key: DNET-887
URL: http://tracker.firebirdsql.org/browse/DNET-887
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.6.0.0, 6.5.0.0, 6.4.0.0, 6.3.0.0, 6.2.0.0, 6.1.0.0, 6.0.0.0
Reporter: Darko Ivanovic
Assignee: Jiri Cincura
Priority: Minor
After closing embedded server connection database file is not released, and subsequent delete or rename of database file fails.
This was working properly up to version 6.0.0.0.
--
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
|
|
From: Henning H. (JIRA) <tr...@fi...> - 2019-07-09 07:16:27
|
EF Core - Scaffold don't create the database classes
----------------------------------------------------
Key: DNET-886
URL: http://tracker.firebirdsql.org/browse/DNET-886
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.6.0.0
Environment: Windows 8.1, Visual Studio 2019 (16.1.5), Firebird 3.0-Database
Reporter: Henning Hassmann
Assignee: Jiri Cincura
Hi, I try to create the databases classes with Scaffold but I only get the xxx_DataContext.cs.
My Scaffold-String looks like this:
Scaffold-DbContext "User=xxx;Password=xxx;Database=localhost/3050:Test;Dialect=3;Charset=NONE;Role=;ServerType=0" FirebirdSql.EntityFrameworkCore.Firebird -DataAnnotations -ContextDir Data -OutputDir DB_Modell
Is anything else missing?
--
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
|
|
From: Henning H. (JIRA) <tr...@fi...> - 2019-07-09 06:03:30
|
EF Core - Scaffold don't create the database classes
----------------------------------------------------
Key: DNET-885
URL: http://tracker.firebirdsql.org/browse/DNET-885
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.6.0.0
Environment: Windows 8.1, Visual Studio 2019 (16.1.5), Firebird 3.0-Database
Reporter: Henning Hassmann
Assignee: Jiri Cincura
Hi, I try to create the databases classes with Scaffold but I only get the xxx_DataContext.cs.
My Scaffold-String looks like this:
Scaffold-DbContext "User=xxx;Password=xxx;Database=localhost/3050:Test;Dialect=3;Charset=NONE;Role=;ServerType=0" FirebirdSql.EntityFrameworkCore.Firebird -DataAnnotations -ContextDir Data -OutputDir DB_Modell
Is anything else missing?
--
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
|
|
From: Henning H. (JIRA) <tr...@fi...> - 2019-07-05 05:34:18
|
EF Core - Firebird Migration auto-increment problem
---------------------------------------------------
Key: DNET-884
URL: http://tracker.firebirdsql.org/browse/DNET-884
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.6.0.0
Environment: Windows 8.1, Visual Studio 2019 (16.1.5), Firebird 3.0-Database
Reporter: Henning Hassmann
Assignee: Jiri Cincura
Hi. I'm testing the migration with EF Core with MSSQL-Server and Firebird 3.0.
I create a new table with a few fields. The key-field has the property .ValueGeneratedOnAdd(), but the key-field in the Firebird database doesn't get an auto-increment during the migration. It works with the MS-SQL-Server correctly.
I use the framework FirebirdSql.EntityFrameworkCore.Firebird version 6.6.0.
modelBuilder.Entity("GenerateCodeFromDB.DB_Modell.TblTest", b =>
{
b.Property<long>("Id")
.ValueGeneratedOnAdd()
.HasColumnName("ID")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime?>("Date");
b.Property<string>("Name")
.HasMaxLength(50);
b.Property<int?>("Number");
b.HasKey("Id");
b.ToTable("tblTest");
});
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-06-30 14:00:11
|
Use app.config.install.xdt for EF6
----------------------------------
Key: DNET-883
URL: http://tracker.firebirdsql.org/browse/DNET-883
Project: .NET Data provider
Issue Type: Improvement
Components: NuGet packages
Reporter: Jiri Cincura
Assignee: Jiri Cincura
More info here https://github.com/aspnet/EntityFramework6/pull/953#issuecomment-506987989.
--
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
|
|
From: Norbert S. G. <ns...@te...> - 2019-06-02 12:06:58
|
Hello, I am looking for info on state session storage in firebird. Do you have links or examples to implement this? Thank you in advance Norbert -- Norbert Saint Georges http://tetrasys.fi |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-05-30 09:27:26
|
Close cursor before transaction commit
--------------------------------------
Key: DNET-882
URL: http://tracker.firebirdsql.org/browse/DNET-882
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 6.6.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
Description in CORE-6067.
--
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
|
|
From: Marik D. (JIRA) <tr...@fi...> - 2019-05-20 08:58:32
|
Implement connect via XNET protocol
-----------------------------------
Key: DNET-881
URL: http://tracker.firebirdsql.org/browse/DNET-881
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Reporter: Marik Decide
Assignee: Jiri Cincura
Would like to firebird .net developers implement connect via XNET protocol.I try to use connect via inet4 but I have problems on clients machines. The database uses as local, customers has antivirus software on them computers. After talking with the developers of the firebird kernel, it was suggested to use xnet protocol for solution this problem. But xnet don't implement in firebird .net provider. Normal working with encrypted database (cryptkey callback) is very important. Also in some forums I observed the regrets of some users that there is can't use xnet in the Firebird .net.
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-05-02 10:20:51
|
Change default character set in connection string from NONE to UTF8 #breaking
-----------------------------------------------------------------------------
Key: DNET-880
URL: http://tracker.firebirdsql.org/browse/DNET-880
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Trivial
--
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
|
|
From: Yuriy (JIRA) <tr...@fi...> - 2019-04-23 09:15:19
|
connection shutdown
-------------------
Key: DNET-879
URL: http://tracker.firebirdsql.org/browse/DNET-879
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.5.0.0
Environment: Windows10
Reporter: Yuriy
Assignee: Jiri Cincura
Server Error in '/' Application.
connection shutdown
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: FirebirdSql.Data.Common.IscException: connection shutdown
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[IscException: connection shutdown]
FirebirdSql.Data.Client.Native.FesServiceManager.ProcessStatusVector(IntPtr[] statusVector) +105
FirebirdSql.Data.Client.Native.FesServiceManager.Attach(ServiceParameterBuffer spb, String dataSource, Int32 port, String service, Byte[] cryptKey) +181
FirebirdSql.Data.Services.FbService.Open() +675
[FbException (0x14000218): connection shutdown]
FirebirdSql.Data.Services.FbService.Open() +1024
FirebirdSql.Data.Services.FbService.QueryService(Byte[] items) +56
FirebirdSql.Data.Services.FbService.ProcessQuery(Byte[] items, Action`2 queryResponseAction) +49
FirebirdSql.Data.Services.FbService.Query(Byte[] items) +142
FirebirdSql.Data.Services.FbServerProperties.GetInfo(Int32 item) +46
FirebirdSql.Data.Services.FbServerProperties.GetString(Int32 item) +9
EntityFramework.Firebird.FbProviderServices.GetDbProviderManifestToken(DbConnection connection) +125
[InvalidOperationException: Could not retrieve storage version.]
EntityFramework.Firebird.FbProviderServices.GetDbProviderManifestToken(DbConnection connection) +240
System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) +115
[ProviderIncompatibleException: The provider did not return a ProviderManifestToken string.]
System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) +372
System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection) +23
[ProviderIncompatibleException: An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. See http://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure.]
System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices providerServices, DbConnection connection) +100
System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory) +87
System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest) +89
System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection) +63
System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext) +222
System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input) +224
System.Data.Entity.Internal.LazyInternalContext.InitializeContext() +884
System.Data.Entity.Internal.LazyInternalContext.get_ModelBeingInitialized() +21
System.Data.Entity.Infrastructure.EdmxWriter.WriteEdmx(DbContext context, XmlWriter writer) +134
System.Data.Entity.Utilities.DbContextExtensions.GetModel(Action`1 writeXml) +128
System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration, DbContext usersContext, DatabaseExistenceState existenceState, Boolean calledByCreateDatabase) +682
System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration) +28
VMS.Core.Infrastructure.Startup.ApplyMigrations() in D:\Projects\vistra-jenkins\Core\VMS\Core\Infrastructure\Start\Startup.cs:60
VMS.Core.Infrastructure.Startup.Configuration(IAppBuilder app) in D:\Projects\vistra-jenkins\Core\VMS\Core\Infrastructure\Start\Startup.cs:35
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +128
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +142
Owin.Loader.<>c__DisplayClass12.<MakeDelegate>b__b(IAppBuilder builder) +93
Owin.Loader.<>c__DisplayClass1.<LoadImplementation>b__0(IAppBuilder builder) +212
Microsoft.Owin.Host.SystemWeb.OwinAppContext.Initialize(Action`1 startup) +873
Microsoft.Owin.Host.SystemWeb.OwinBuilder.Build(Action`1 startup) +51
Microsoft.Owin.Host.SystemWeb.OwinHttpModule.InitializeBlueprint() +101
System.Threading.LazyInitializer.EnsureInitializedCore(T& target, Boolean& initialized, Object& syncLock, Func`1 valueFactory) +135
Microsoft.Owin.Host.SystemWeb.OwinHttpModule.Init(HttpApplication context) +160
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +580
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +165
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +267
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +341
[HttpException (0x80004005): Exception has been thrown by the target of an invocation.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +523
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +107
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +688
--
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
|
|
From: Ich (JIRA) <tr...@fi...> - 2019-04-17 14:48:56
|
Support of FB 4.0 TIMESTAMP WITH TIME ZONE
------------------------------------------
Key: DNET-878
URL: http://tracker.firebirdsql.org/browse/DNET-878
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Reporter: Ich
Assignee: Jiri Cincura
Firebird 4.0 will support TIMESTAMP WITH TIME ZONE.
http://www.ibexpert.net/IBE/index.php?n ... oneSupport
The corresponding type in .NET is DateTimeOffset. This should be supported for reading and writing.
--
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
|
|
From: Pavel (JIRA) <tr...@fi...> - 2019-04-14 05:42:59
|
Long aliases are generated in WHERE clause
------------------------------------------
Key: DNET-877
URL: http://tracker.firebirdsql.org/browse/DNET-877
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Affects Versions: 6.6.0.0
Reporter: Pavel
Assignee: Jiri Cincura
When access to condition column passes through several tables, for the joined tables generated a very long alias.
And I get FirebirdSql.Data.FirebirdClient.FbException: "Dynamic SQL Error Name longer than database column size"
Example
class Table1
{
int id
int value
int idTable2
[ForeignKey("idTable2")]
Table2 table2
}
class Table2
{
int id
int idTable3
[ForeignKey("idTable3")]
Table3 table3
}
class Table3
{
int id
bool condition
}
When i do:
var result = Table1.where(t => t.table2.table3.condition).select(t => value)
generates query:
SELECT
"t"." value"
FROM
Table1 AS "t"
LEFT JOIN Table2 AS "t.Table2" ON "t"."idTable2" = "t.Table2"."id"
LEFT JOIN Table3 AS "t.Table2.Table3" ON "t.Table2"."IdTable3" = "t.Table2.Table3"."id"
WHERE
"t.Table2.Table3"."condition"
--
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
|
|
From: Vladimir K. (JIRA) <tr...@fi...> - 2019-04-11 12:05:58
|
Using wrong type for blob
-------------------------
Key: DNET-876
URL: http://tracker.firebirdsql.org/browse/DNET-876
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.6.0.0
Environment: Asp.net core, microsoft.entityframeworkCore 2.2.4
Firebird 2.5
Reporter: Vladimir Karataev
Assignee: Jiri Cincura
I am using next data model:
[Table("table")]
public class Test
{
[Key][Required]
public long Id {get; set; }
[Column("raw_data")]
public byte[] raw_data {get; set; }
}
The column "raw_data" was descripted as: BLOB SUB_TYPE 1 SEGMENT SIZE 100 CHARACTER SET UTF8;
This is a BLOB.
I execute request of data from table through entity framework:
var data = db.Test.Find(id);
In window trace into visual studio i watch query:
SELECT "e"."ID", "e"."RAW_DATA" FROM "TABLE" AS "e" WHERE "e"."ID" = CAST(@__get_Item_0 AS BIGINT)
I have got exception in this place:
"Unable to cast object of type 'System.String' to type 'System.Byte[]'."
I suppose, provider should be using blob type for this column, but it using type of string for this column. May be it wrong behavior?
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-04-11 06:56:56
|
Publish symbols to snupkg
-------------------------
Key: DNET-875
URL: http://tracker.firebirdsql.org/browse/DNET-875
Project: .NET Data provider
Issue Type: Improvement
Components: NuGet packages
Affects Versions: 6.6.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
|
|
From: Tobias Z. (JIRA) <tr...@fi...> - 2019-03-25 07:53:05
|
Defining a sequence through the fluent API creates wrong SQL syntax
-------------------------------------------------------------------
Key: DNET-874
URL: http://tracker.firebirdsql.org/browse/DNET-874
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Affects Versions: 6.5.0.0
Environment: Firebird 3.0.4, embedded
Reporter: Tobias Zipfel
Assignee: Jiri Cincura
When using ModelBuilder.HasSequence(string) the resulting SQL syntax executed when running context.Database.EnsureCreated() leads to a FbException:
Test:
using (var context = new TestContext(connectionString))
{
var test = context.Database.EnsureCreated();
}
In TestContext:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasSequence("HIBERNATE_SEQUENCE");
...
Debug output:
...
dbug: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE SEQUENCE "HIBERNATE_SEQUENCE" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE NO CYCLE;
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (26ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE SEQUENCE "HIBERNATE_SEQUENCE" START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE NO CYCLE;
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 66
NO ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 66
NO
...
--
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
|
|
From: Ulf P. (JIRA) <tr...@fi...> - 2019-03-14 13:08:04
|
Default value
-------------
Key: DNET-873
URL: http://tracker.firebirdsql.org/browse/DNET-873
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Environment: Visual Studio Community 2017
Reporter: Ulf Prill
Assignee: Jiri Cincura
public class Rating
{
public long ID { get; set; }
public uint Value { get; set; }
}
public class IssueProjDaten : DbContext
{
public DbSet<Rating> Ratings { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseFirebird(@"User=SYSDBA;Password=masterkey;Database=D:\Database\IssueProj.fdb");
base.OnConfiguring(optionsBuilder);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity<Rating>().Property("Value").HasDefaultValue(0);
}
}
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Test App for Issue");
using (var daten = new IssueProjDaten())
{
daten.Database.Migrate();
}
}
}
Create a exception:
FirebirdSql.Data.FirebirdClient Information: 0 : Command:
CREATE TABLE "Ratings" (
"ID" BIGINT NOT NULL,
"Value" BIGINT NOT NULL DEFAULT 0,
CONSTRAINT "PK_Ratings" PRIMARY KEY ("ID")
);
Parameters:
<no parameters>
Ausnahme ausgelöst: "FirebirdSql.Data.FirebirdClient.FbException" in Microsoft.EntityFrameworkCore.Relational.dll
Ein Ausnahmefehler des Typs "FirebirdSql.Data.FirebirdClient.FbException" ist in Microsoft.EntityFrameworkCore.Relational.dll aufgetreten.
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, column 29
DEFAULT
--
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.
