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: Jiří Č. <ji...@ci...> - 2017-09-09 08:07:49
|
> Maybe a good idea to also post instructions how to subscribe. Right. https://support.google.com/groups/answer/1067205?hl=en . -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Mark R. <ma...@la...> - 2017-09-09 07:23:01
|
On 8-9-2017 20:45, Jiří Činčura wrote: > Hi *, > > Because of recent changes on SourceForge we have a new list: > fir...@go... > <mailto:fir...@go...>. Hopefully it will solve > the issues of some emails not being delivered and some people being > unable to post. Resubscribe there, this old list is soon going to be > retired. Maybe a good idea to also post instructions how to subscribe. Mark -- Mark Rotteveel |
|
From: Jiří Č. <ji...@ci...> - 2017-09-08 18:45:55
|
Hi *, Because of recent changes on SourceForge we have a new list: firebird-net- pro...@go.... Hopefully it will solve the issues of some emails not being delivered and some people being unable to post. Resubscribe there, this old list is soon going to be retired. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-09-05 11:48:43
|
Switch to Microsoft.Extensions.Logging in in the future
-------------------------------------------------------
Key: DNET-782
URL: http://tracker.firebirdsql.org/browse/DNET-782
Project: .NET Data provider
Issue Type: New Feature
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: André Z. (J. <tr...@fi...> - 2017-09-05 09:15:43
|
Updating FirebirdClient provider to Version 5.11.0 fails with 'FirebirdSql.Data.FirebirdClient' already has a dependency defined for 'Microsoft.Extensions.PlatformAbstractions' in Visual Studio 2012 for .net 4.0 project
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DNET-781
URL: http://tracker.firebirdsql.org/browse/DNET-781
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 5.11.0.0
Environment: Windows 8, Visual Studio 2012
Reporter: André Ziegler
Assignee: Jiri Cincura
Updating FirebirdClient provider 5.11.0 fails with 'FirebirdSql.Data.FirebirdClient' already has a dependency defined for 'Microsoft.Extensions.PlatformAbstractions' in Visual Studio 2012:
Here is the log entry in package console:
------- Updating...FirebirdSql.Data.FirebirdClient 5.11.0 -------
'FirebirdSql.Data.FirebirdClient' already has a dependency defined for 'Microsoft.Extensions.PlatformAbstractions'.
==============================
looks like the NuGet Package Manager 2.8.60318.667 from VS2012 is too old to handle this .net standard (2.0) thing. Consider adding minClientVersion entry to the nuspec files and specify the nuget version where it works.
--
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: Jiří Č. <ji...@ci...> - 2017-09-03 17:00:59
|
Hi *, more and more people are having problems posting to this list (or any SF list in general). We, the Firebird project, are considering moving all the lists to Google Groups. If you have a specific idea for this list, it's time to speak. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Jiří Č. <ji...@ci...> - 2017-09-03 16:59:28
|
Hi *, in case you'd like to talk on Gitter, I created a room: https://t.co/B81ZThgVIG . Not sure where that road goes. :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Геннадий З. <zab...@gm...> - 2017-08-31 10:22:46
|
Hi all. I have server, after a while, it starts continuously consume memory. All approaches I've used before didn't show that this was particular memory leak in server code. To detect memory leak I've used vmmap, that showed private memory (VirtualAlloc) is consumed (attach1.png https://1drv.ms/i/s!AsU_6wa3CeYThLFeMp4JNF5PKg24Ig). Screenshot doesn't fully shows, but there are a lot of 64 kb chunks that was allocated during work of server. VirtualAlloc allocations aren't handled by +ust (Create user mode stack trace database) global flag, so I wasn't able to retrieve stacks for these allocations. But, there is Application Verifier that does tracks allocations and stack traces. So I've used AppVerif+WinDbg and obtained following information: 0:053> !avrf -vs -a 0x7FF5CB770000 Searching call tracker @ 000001dc4fcd2fc0 with 16384 valid entries ... -------------------------------------------------------------- VirtualAlloc: 7FF5CB770000 10000 101000 4 00007ffbc5ebac57: KERNELBASE!VirtualAlloc+0x47 00007ffb9b124817: vfbasics!AVrfpVirtualAlloc+0x47 000000018002e11c: fbembed!Firebird::MemoryPool::external_alloc+0xCC 000000018002ef76: fbembed!Firebird::MemoryPool::internal_alloc+0x286 000000018002d68e: fbembed!Firebird::MemoryPool::allocate_nothrow+0x21E 000000018002e8de: fbembed!Firebird::MemoryPool::getExtent+0x2E 000000018002eebf: fbembed!Firebird::MemoryPool::internal_alloc+0x1CF 000000018002d68e: fbembed!Firebird::MemoryPool::allocate_nothrow+0x21E 000000018002d44e: fbembed!Firebird::MemoryPool::allocate+0xE 0000000180116d8c: fbembed!PAR_gen_field+0x2C 00000001800e3a53: fbembed!copy+0x3D3 00000001800e3791: fbembed!copy+0x111 00000001800e3791: fbembed!copy+0x111 00000001800e6808: fbembed!make_validation+0x278 00000001800e7464: fbembed!pass1_modify+0x2F4 00000001800e0004: fbembed!CMP_pass1+0x1084 00000001800e085e: fbembed!CMP_pass1+0x18DE 00000001800e085e: fbembed!CMP_pass1+0x18DE 00000001800e085e: fbembed!CMP_pass1+0x18DE 00000001800de76b: fbembed!CMP_make_request+0x8B 00000001800dc809: fbembed!CMP_compile2+0xD9 000000018006f03c: fbembed!JRD_compile+0x8C 000000018022f1c5: fbembed!prepare+0x9E5 000000018022b114: fbembed!DSQL_prepare+0x2C4 0000000180084324: fbembed!jrd8_prepare+0x2C4 0000000180051c2a: fbembed!isc_dsql_prepare_m+0x2EA 000000018005174d: fbembed!isc_dsql_prepare+0x15D 00007ffb5fa6cea4: +0x7FFB5FA6CEA4 0:053> !ip2md 0x7FFB5FA6CEA4 MethodDesc: 00007ffb5fccad38 Method Name: DomainBoundILStubClass.IL_STUB_PInvoke(IntPtr[], FirebirdSql.Data.Client.Native.Handle.TransactionHandle ByRef, FirebirdSql.Data.Client.Native.Handle.StatementHandle ByRef, Int16, Byte[], Int16, IntPtr) Class: 00007ffb5f001fd0 MethodTable: 00007ffb5f002048 mdToken: 0000000006000000 Module: 00007ffb5ef5ea38 IsJitted: yes CodeAddr: 00007ffb5fa6cc00 Transparency: Safe critical As you can see, root of stack that allocates memory is this row https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/ 2cedb4fb49c6bb1a7d9221914cea6060d643b6ff/Provider/src/FirebirdSql.Data. FirebirdClient/Client/Native/FesStatement.cs#L268. My first suggestion was that something in chain FbConnection->FbConnectionInternal->FesDatabase->FesStatement-> StatementHandle wasn't properly disposed/cleared. But as I can see by !dumpheap -stat -type StatementHandle, all handles already disposed or in finalizer queue, not mention that in dump there are only 50 StatementHandles, that is much less than potentially needed to occupate 700+ Mb. Any ideas what happens here? Why memory allocated in PAR_gen_field isn't deallocated after StatementHandle disposed? |
|
From: Jiří Č. <ji...@ci...> - 2017-08-30 06:06:20
|
More info: https://www.tabsoverspaces.com/233642-ado-net-provider-5-11-0-0-for-firebird-is-ready-with-net-standard-2-0-support/ . -- Mgr. Jiří Činčura Independent IT Specialist |
|
From: Mr. J. <mr_...@ya...> - 2017-08-29 11:04:28
|
HiI've tried your second suggestion setting PK description to #PK_GEN# and not workingthanks From: Jiří Činčura <ji...@ci...>To: "fir...@li..." <fir...@li...>Sent: Tuesday, August 29, 2017, 10:40:52 AM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 With DB First you can set it up in Properties the same way. Or you can use https://www.tabsoverspaces.com/230841-generated-primary-key-in-entity-framework-model-from-firebird/. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Aug 29, 2017, at 08:44, Mr. John via Firebird-net-provider wrote: > Hi.I'm using Db first and as I found that is about code firstIf I'm wrong > please someone give me some tips about using thatthanks. > > From: Jiří Činčura <ji...@ci...>To: > "fir...@li..." > <fir...@li...>Sent: Monday, August 28, > 2017, 2:48:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last > inserted ID is 0 > Why so complex. Just use > https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx > and that's it. You should consider you entities store agnostic, in fact. > > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.com/ > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2017-08-29 07:40:33
|
With DB First you can set it up in Properties the same way. Or you can use https://www.tabsoverspaces.com/230841-generated-primary-key-in-entity-framework-model-from-firebird[1]/. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Tue, Aug 29, 2017, at 08:44, Mr. John via Firebird-net-provider wrote:> Hi.I'm using Db first and as I found that is about code firstIf > I'm wrong> please someone give me some tips about using thatthanks. > > From: Jiří Činčura <ji...@ci...>To: > "fir...@li..." > <fir...@li...>Sent: Monday, August 28,> 2017, 2:48:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last > inserted ID is 0 > Why so complex. Just use > https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx> and that's it. You should consider you entities store agnostic, > in fact.> > -- > Mgr. Jiří Činčura > https://www.tabsoverspaces.com/ > > > ---------------------------------------------------------------------- > --------> Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ---------------------------------------------------------------------- > --------> Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider Links: 1. https://www.tabsoverspaces.com/230841-generated-primary-key-in-entity-framework-model-from-firebird/ |
|
From: Mr. J. <mr_...@ya...> - 2017-08-29 06:45:06
|
Hi.I'm using Db first and as I found that is about code firstIf I'm wrong please someone give me some tips about using thatthanks. From: Jiří Činčura <ji...@ci...>To: "fir...@li..." <fir...@li...>Sent: Monday, August 28, 2017, 2:48:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Why so complex. Just use https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx and that's it. You should consider you entities store agnostic, in fact. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Jiří Č. <ji...@ci...> - 2017-08-28 11:48:32
|
Why so complex. Just use https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx and that's it. You should consider you entities store agnostic, in fact. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
|
From: Mr. J. <mr_...@ya...> - 2017-08-28 11:42:59
|
Hiit seems to work only if I go to edmx,on ID filed and set StoreGeneratedPatern = Identitybut I use DbFirst and this could be replaced on model update from dbI've tried using partial class with no success
in my model generated code I have something like this:namespace POSweb.Models
{
public partial class GS_POS_CO
{
.....
public long ID { get; set; }
.....
}
}I've added a new file to my project, Annotations.cs and inside a new partial class with the same name for class and namespace:
namespace POSweb.Models
{
[MetadataType(typeof(GS_POS_CO.Annotations))]
public partial class GS_POS_CO
{
internal class Annotations
{
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public long ID { get; set; }
}
}
}
thanks for any help
From: Jiří Činčura <ji...@ci...>To: "fir...@li..." <fir...@li...>Sent: Sunday, August 27, 2017, 6:16:03 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0
Your myTableEnt should have Id marked as DatabaseGen…Options.Identity. Then it's fetched back automatically.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
On Fri, Aug 25, 2017, at 19:28, Mr. John via Firebird-net-provider wrote:
> HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017
> on a table I have a trigger to generate ID:
> CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END
>
> in my code I insert data like this:
> myTableEnt newRec= new myTableEnt() { NAME='MYNAME', .... };
>
> db.myTableEnt.Add(newRec); db.SaveChanges(); return ToJson(new { msg = newRec.ID.ToString() });
> newRec.ID is returned always 0,but in database value is generatedwhat I've done wrongthanks
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-08-28 10:08:35
|
Serializable attribute for .NET Standard 1.6
--------------------------------------------
Key: DNET-780
URL: http://tracker.firebirdsql.org/browse/DNET-780
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 5.10.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: Jiri C. (JIRA) <tr...@fi...> - 2017-08-28 07:24:45
|
Support for op_crypt_key_callback for encrypted databases
---------------------------------------------------------
Key: DNET-779
URL: http://tracker.firebirdsql.org/browse/DNET-779
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
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: Jiri C. (JIRA) <tr...@fi...> - 2017-08-28 07:07:46
|
.NET Standard 2.0 support
-------------------------
Key: DNET-778
URL: http://tracker.firebirdsql.org/browse/DNET-778
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider, NuGet packages
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...> - 2017-08-28 05:53:45
|
FBTrace is working in Firebird 3.0 but not working in 2.5.
-----------------------------------------------------------
Key: DNET-777
URL: http://tracker.firebirdsql.org/browse/DNET-777
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.10.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Now FBTrace is working in Firebird 3.0 but not working in 2.5.
Got the error message:
Error creating trace session for database "D:\EMPLOYEE25.FDB":
error while parsing trace configuration
line 12: element "log_function_start" is 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: Jiří Č. <ji...@ci...> - 2017-08-27 15:15:46
|
Your myTableEnt should have Id marked as DatabaseGen…Options.Identity. Then it's fetched back automatically. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Fri, Aug 25, 2017, at 19:28, Mr. John via Firebird-net-provider wrote:> HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017 > on a table I have a trigger to generate ID: > CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE > ACTIVE BEFORE INSERT POSITION 0 AS > BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) > THEN NEW.ID=NEXT VALUE FOR > GEN_MYTABLE_ID; END> > in my code I insert data like this: > myTableEnt newRec= new myTableEnt() { > NAME='MYNAME', .... };> > db.myTableEnt.Add(newRec); > db.SaveChanges(); return ToJson(new { > msg = newRec.ID.ToString() });> newRec.ID is returned always 0,but in database value is generatedwhat > I've done wrongthanks> ---------------------------------------------------------------------- > --------> Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Mr. J. <mr_...@ya...> - 2017-08-26 16:00:47
|
HiI'm using DbFirst,if I set [DatabaseGenerated(DatabaseGeneratedOption.Identity)] attribute on the ID column after a model refresh it will be lostthanks From: Daniel Rail <da...@ac...>To: "fir...@li..." <fir...@li...>Sent: Saturday, August 26, 2017, 4:37:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Hi, At August 26, 2017, 1:38 AM, Mr. John via Firebird-net-provider wrote: | | Hi. Thanks Paul for your answer For my first code I've followed this: https://stackoverflow.com/questions/4068084/how-to-find-an-identity-of-the-last-inserted-row-in-entity-framework and that seems not to apply to FB? | That's how I do it. Just make certain that you are using the [DatabaseGenerated(DatabaseGeneratedOption.Identity)] attribute on the ID column in the myTableEnt entity. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com)------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From: Daniel R. <da...@ac...> - 2017-08-26 13:37:24
|
<html><head><title>Re: [Firebird-net-provider] EF - last inserted ID is 0</title> </head> <body> <span style=" font-family:'Courier New'; font-size: 9pt;">Hi,<br> <br> At August 26, 2017, 1:38 AM, Mr. John via Firebird-net-provider wrote:<br> <br> <a name="ydp6aee214eyahoo_quoted_4196587569"></a> </span><table> <tr> <td width=2 bgcolor= #0000ff><br> </td> <td><span style=" font-family:'verdana'; font-size: 10pt;">Hi.<br> Thanks Paul for your answer<br> For my first code I've followed this: https://stackoverflow.com/questions/4068084/how-to-find-an-identity-of-the-last-inserted-row-in-entity-framework<br> and that seems not to apply to FB?</td> </tr> </table> <br> <span style=" font-family:'Courier New'; font-size: 9pt;">That's how I do it. Just make certain that you are using the <span style=" font-size: 10pt;">[DatabaseGenerated(DatabaseGeneratedOption.Identity)] attribute on the ID column in the myTableEnt entity.<br> <br> <br> <span style=" font-family:'calibri'; font-size: 9pt; color: #c0c0c0;"><i>-- <br> Best regards,<br> Daniel Rail<br> Senior Software Developer<br> ACCRA Solutions Inc. (</i></span></span></span><a style=" font-family:'calibri'; font-size: 9pt;" href="http://www.accra.ca">www.accra.ca</a><span style=" font-family:'calibri'; font-size: 9pt; color: #c0c0c0;"><i>)<br> ACCRA Med Software Inc. (</i></span><a style=" font-family:'calibri'; font-size: 9pt;" href="http://www.filopto.com">www.filopto.com</a><span style=" font-family:'calibri'; font-size: 9pt; color: #c0c0c0;"><i>)</body></html> |
|
From: Mr. J. <mr_...@ya...> - 2017-08-26 04:38:51
|
Hi.Thanks Paul for your answerFor my first code I've followed this: https://stackoverflow.com/questions/4068084/how-to-find-an-identity-of-the-last-inserted-row-in-entity-frameworkand that seems not to apply to FB?I so I can insert ID without trigger,directly from my code,something like this: myTableEnt newRec= new myTableEnt() { ID= GetNextSequenceValue(ref db, "SELECT NEXT VALUE FOR GEN_MYTABLE_ID FROM RDB$DATABASE") NAME='MYNAME', .... }; ...public long GetNextSequenceValue(ref myEnt ctx, string sql) { var rawQuery = ctx.Database.SqlQuery<long>(sql); var task = rawQuery.SingleAsync(); long nextVal = task.Result; return nextVal; } thanks From: paul.mercea <pau...@al...>To: For users and developers of the Firebird .NET providers <fir...@li...>Cc: Mr. John <mr_...@ya...>Sent: Friday, August 25, 2017, 11:35:11 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 The trigger from you database has nothing to do with your c# code.You can use a stored procedure to insert data and returning latest id (also you can read current sequence value but you can have wrong value if other inserts happening). Sent from my Samsung Galaxy smartphone. -------- Original message --------From: "Mr. John via Firebird-net-provider" <fir...@li...> Date: 8/25/17 20:28 (GMT+02:00) To: "For Users and Developers of the Firebird .NET Providers" <fir...@li...> Cc: "Mr. John" <mr_...@ya...> Subject: [Firebird-net-provider] EF - last inserted ID is 0 HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017 on a table I have a trigger to generate ID: CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END in my code I insert data like this: myTableEnt newRec= new myTableEnt() { NAME='MYNAME', .... }; db.myTableEnt.Add(newRec); db.SaveChanges(); return ToJson(new { msg = newRec.ID.ToString() }); newRec.ID is returned always 0,but in database value is generatedwhat I've done wrongthanks |
|
From: paul.mercea <pau...@al...> - 2017-08-25 20:52:18
|
The trigger from you database has nothing to do with your c# code.You can use a stored procedure to insert data and returning latest id (also you can read current sequence value but you can have wrong value if other inserts happening).
Sent from my Samsung Galaxy smartphone.
-------- Original message --------From: "Mr. John via Firebird-net-provider" <fir...@li...> Date: 8/25/17 20:28 (GMT+02:00) To: "For Users and Developers of the Firebird .NET Providers" <fir...@li...> Cc: "Mr. John" <mr_...@ya...> Subject: [Firebird-net-provider] EF - last inserted ID is 0
HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017
on a table I have a trigger to generate ID:
CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END
in my code I insert data like this:
myTableEnt newRec= new myTableEnt() { NAME='MYNAME', .... };
db.myTableEnt.Add(newRec); db.SaveChanges(); return ToJson(new { msg = newRec.ID.ToString() });
newRec.ID is returned always 0,but in database value is generatedwhat I've done wrongthanks
|
|
From: Mr. J. <mr_...@ya...> - 2017-08-25 17:32:41
|
HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017
on a table I have a trigger to generate ID:
CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END
in my code I insert data like this:
myTableEnt newRec= new myTableEnt() { NAME='MYNAME', .... };
db.myTableEnt.Add(newRec); db.SaveChanges(); return ToJson(new { msg = newRec.ID.ToString() });
newRec.ID is returned always 0,but in database value is generatedwhat I've done wrongthanks
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2017-08-25 05:47:47
|
Switch to single csproj with multitargeting
-------------------------------------------
Key: DNET-776
URL: http://tracker.firebirdsql.org/browse/DNET-776
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
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
|
211 messages has been excluded from this view by a project administrator.
