firebird-net-provider Mailing List for Firebird

After a lot of thinking and considering pros and cons, I decided to do
the change. It's going to be painful, especially for people already
using it, but the least surprise principle here is strong argument in my
head. Also because there are some big changes in Firebird 3 itself (like
this
https://www.tabsoverspaces.com/233552-gotcha-with-firebird-3-count-and-executescalar-common-casting-pattern/),
it's better to do it sooner than later.

Thus very likely next _major_ version will contain this change.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

> But,  what  could  cause  it  not  to recognize those fields properly?
> Because   when   I   look   in   the  database's  system  tables,  the
> RDB$FIELD_TYPE  and  RDB$FIELD_LENGTH  both  have  values in them, one
> would be VARCHAR(132) and the others would be CHAR(1).

Don't know. If you can confirm it's really those fields, put it to
tracker and I'll look at it.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Hi,

At April 22, 2017, 10:09 AM, Jiří Činčura wrote:

>> I was starting to suspect that, since the other tables that I was able
>> to generate the code for didn't have computed fields. Are there any
>> hints that I can use?
>> 
>> I can try to look at the code to see if I can fix the problem. And,
>> since I never did look inside the ADO.Net driver code. Can you guide
>> me to what would be the area of code that I would need to look at?
>> 
>> I'm willing to try to fix the problem, since this is not the only
>> table in that database that has computed fields.

> You can create a table without computed field, generate the CF for it.
> And then do the same for a table with computed field.

But,  what  could  cause  it  not  to recognize those fields properly?
Because   when   I   look   in   the  database's  system  tables,  the
RDB$FIELD_TYPE  and  RDB$FIELD_LENGTH  both  have  values in them, one
would be VARCHAR(132) and the others would be CHAR(1).

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

> I was starting to suspect that, since the other tables that I was able
> to generate the code for didn't have computed fields. Are there any
> hints that I can use?
> 
> I can try to look at the code to see if I can fix the problem. And,
> since I never did look inside the ADO.Net driver code. Can you guide
> me to what would be the area of code that I would need to look at?
> 
> I'm willing to try to fix the problem, since this is not the only
> table in that database that has computed fields.

You can create a table without computed field, generate the CF for it.
And then do the same for a table with computed field.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Hi,

At April 22, 2017, 4:47 AM, Jiří Činčura wrote:

> My *guess* is that it's the computed columns and the length is not
> discovered properly.

I was starting to suspect that, since the other tables that I was able
to generate the code for didn't have computed fields. Are there any
hints that I can use?

I can try to look at the code to see if I can fix the problem. And,
since I never did look inside the ADO.Net driver code. Can you guide
me to what would be the area of code that I would need to look at?

I'm willing to try to fix the problem, since this is not the only
table in that database that has computed fields.

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

My *guess* is that it's the computed columns and the length is not
discovered properly.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Hi,

I'm  using  Visual  Studio  2015,  with all updates,  Firebird ADO.Net
5.8.1 and Entity Framework 6.1.3.

I'm  trying to generate an EF6 object by using Code First from Database.
One  table is causing an error when it is trying to generate the code.
Up  to  now,  the  other  tables that I generated the EF6 code for, by
using the Code First from Database template, worked properly.

Here's the call stack generated within Visual Studio:

Microsoft Visual Studio

An error occurred generating the Code First model. The error occurred
generating the contents of TempModel1.cs.
System.ArgumentOutOfRangeException: MaxLength must be greater
than zero.
Parameter name: maxLength
at System.Data.Entity.Core.Metadata.Edm.TypeUsage.ValidateMaxLength(Int32 maxLength)
at System.Data.Entity.Core.Metadata.Edm.TypeUsage.CreateStringTypeUsage(PrimitiveType primitiveType, Boolean isUnicode, Boolean isFixedLength, Int32 maxLength)
at FirebirdSql.Data.EntityFramework6.FbProviderManifest.GetStoreType(TypeUsage emeype) in C:\Users\JirflDocuments\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbProviderManifest.cs:line 350
at Microsoft.Data.Entity.Design.CodeGeneration.ColumnDiscoverer.Discover(Ederoperty property, DbModel model)
at Microsoft.Data.Entity.Design.CodeGeneration.Edeelper.<> c_DisplayClass5_0.< GetConfigurations> b_0(IPropertyConfigurationDiscoverer f)
at System.Linq.Enumerable.WhereSelectArraylterator‘ZMoveNextO
at System.Linq.Enumerable.WhereEnumerablelterator‘l .MoveNextO
at System.Linq.Enumerable.< 0FI'ypelterator> d_92‘1 .MoveNextO
at System.Linq.Enumerable.WhereEnumerablelterator‘l .MoveNextO
at Microsoft.Data.Entity.Design.CodeGeneration.DefaultCSharpContextGenerator.TransformText0
at Microsoft.Data.Entity.Design.CodeGeneration.DefaultCSharpContextGenerator.Generate(DbModel model, String codeNamespace, String contextClassName, String connectionStringName)
at Microsoft.Data.Entity.Design.CodeGeneration.CodeFirstModelGenerator.< Generate) d_3.MoveNext0


And, here's the definition of the table that I'm having a problem with:

CREATE TABLE CLAIMSDETAIL (
  SERVICENO INTEGER NOT NULL,
  FILOPTOHCFACLAIMNO INTEGER,
  DATESTART TIMESTAMP,
  DATEEND TIMESTAMP,
  PLACEOFSERVICE VARCHAR(2),
  TYPEOFSERVICE VARCHAR(2),
  HCPCS_CPTCODE VARCHAR(5),
  MODIFIER1 VARCHAR(2),
  MODIFIER2 VARCHAR(5),
  DIAGNOSISCODE VARCHAR(1),
  CHARGES CURRENCY,
  DAYSORUNITS VARCHAR(2),
  EPSDTFAMILYPLAN VARCHAR(2),
  EMG VARCHAR(2),
  COB VARCHAR(2),
  LOCALUSE VARCHAR(8),
  MODIFIEDDATE TIMESTAMP,
  MODIFIEDBY USERNAMETYPE,
  INVOICEDETAILITEMNO INTEGER,
  MODIFIER3 CPT_CODE_MODIFIER,
  MODIFIER4 CPT_CODE_MODIFIER,
  DIAGNOSTIC_CODE VARCHAR(10),
  DIAGNOSIS_CODE_POINTER_1 INTEGER,
  DIAGNOSIS_CODE_POINTER_2 INTEGER,
  DIAGNOSIS_CODE_POINTER_3 INTEGER,
  DIAGNOSIS_CODE_POINTER_4 INTEGER,
  SERVICE_SEQUENCE_NO INTEGER DEFAULT 1,
  ESPDT CHAR(2),
  SUPPLEMENTAL_INFORMATION VARCHAR(80),
  UC_DIAGNOSIS_CODE_1 ICD9_CODE,
  UC_DIAGNOSIS_CODE_2 ICD9_CODE,
  UC_DIAGNOSIS_CODE_3 ICD9_CODE,
  UC_DIAGNOSIS_CODE_4 ICD9_CODE,
  DIAGNOSIS_CODES COMPUTED BY ( coalesce(iif(diagnosis_code_pointer_1>0, diagnosis_code_pointer_1, ''),'')||coalesce(iif(diagnosis_code_pointer_2>0, diagnosis_code_pointer_2, ''),'')||coalesce(iif(diagnosis_code_pointer_3>0, diagnosis_code_pointer_3, ''),'')||coalesce(iif(diagnosis_code_pointer_4>0, diagnosis_code_pointer_4, ''),'') ),
  DIAGNOSIS_02_12_CODE_POINTER_1 COMPUTED BY ( case diagnosis_code_pointer_1
    when 1 then 'A'
    when 2 then 'B'
    when 3 then 'C'
    when 4 then 'D'
    when 5 then 'E'
    when 6 then 'F'
    when 7 then 'G'
    when 8 then 'H'
    when 9 then 'I'
    when 10 then 'J'
    when 11 then 'K'
    when 12 then 'L'
  end ),
  DIAGNOSIS_02_12_CODE_POINTER_2 COMPUTED BY ( case diagnosis_code_pointer_2
    when 1 then 'A'
    when 2 then 'B'
    when 3 then 'C'
    when 4 then 'D'
    when 5 then 'E'
    when 6 then 'F'
    when 7 then 'G'
    when 8 then 'H'
    when 9 then 'I'
    when 10 then 'J'
    when 11 then 'K'
    when 12 then 'L'
  end ),
  DIAGNOSIS_02_12_CODE_POINTER_3 COMPUTED BY ( case diagnosis_code_pointer_3
    when 1 then 'A'
    when 2 then 'B'
    when 3 then 'C'
    when 4 then 'D'
    when 5 then 'E'
    when 6 then 'F'
    when 7 then 'G'
    when 8 then 'H'
    when 9 then 'I'
    when 10 then 'J'
    when 11 then 'K'
    when 12 then 'L'
  end ),
  DIAGNOSIS_02_12_CODE_POINTER_4 COMPUTED BY ( case diagnosis_code_pointer_4
    when 1 then 'A'
    when 2 then 'B'
    when 3 then 'C'
    when 4 then 'D'
    when 5 then 'E'
    when 6 then 'F'
    when 7 then 'G'
    when 8 then 'H'
    when 9 then 'I'
    when 10 then 'J'
    when 11 then 'K'
    when 12 then 'L'
  end ));
ALTER TABLE CLAIMSDETAIL ADD CONSTRAINT PK_CLAIMSDETAIL PRIMARY KEY (SERVICENO);
CREATE UNIQUE INDEX CLAIMSDETAIL0 ON CLAIMSDETAIL(FILOPTOHCFACLAIMNO,SERVICENO);
CREATE INDEX IDX_CLAIMSDETAIL ON CLAIMSDETAIL(FILOPTOHCFACLAIMNO);
CREATE INDEX IDX_CLAIMSDETAIL1 ON CLAIMSDETAIL(INVOICEDETAILITEMNO);
CREATE INDEX I_CLAIMSDETAIL_DATESTART ON CLAIMSDETAIL(DATESTART);

Any  help  would  be appreciated.

Also,  this  table is used as is within our Delphi code for at least 5
years, and we do not want to change that code.

-- 
Best regards,
 Daniel Rail
 Senior System Engineer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

System.IndexOutOfRangeException
-------------------------------

                 Key: DNET-755
                 URL: http://tracker.firebirdsql.org/browse/DNET-755
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.1.0
         Environment: Framework 4.0 / Firebird 3.0.2.32703 / Visual Studio 2015
Occurs eventually in windows 10 Pro/Enterprise / Windows 7 Enterprise
            Reporter: Marcos R. Weimer
            Assignee: Jiri Cincura



        public void DisparaEvento(string evento)
        {
            using (FbCommand q = conexao.CreateCommand())
            {
                q.CommandType = CommandType.Text;
                q.CommandText = "execute block as begin POST_EVENT '" + evento + "'; end";
                q.ExecuteNonQuery();
            }
        }

Multiple calls in a row...

DisparaEvento("EnviarNF");
DisparaEvento("ReciboNF");
DisparaEvento("CancelarNF");
DisparaEvento("DownloadNF");
DisparaEvento("ConsDestNF");
DisparaEvento("NFSe");

eventually:

An unhandled exception of type 'System.IndexOutOfRangeException' occurred in FirebirdSql.Data.FirebirdClient.dll

Stack:
   em FirebirdSql.Data.Common.StatementBase.ProcessStatementTypeInfoBuffer(Byte[] buffer)
   em FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText)
   em FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
   em FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
   em FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
   em UltraNFe.EventosFB.DisparaEvento(String evento) na C:\ultra\UltraNFe2\EventosFB.cs:linha 100
   em UltraNFe.EventosFB.DispararEventos() na C:\ultra\UltraNFe2\EventosFB.cs:linha 110
   em UltraNFe.FPrincipal.btnAutomatico_Click(Object sender, EventArgs e) na C:\ultra\UltraNFe2\Form1.cs:linha 506
   em UltraNFe.FPrincipal.Form1_Shown(Object sender, EventArgs e) na C:\ultra\UltraNFe2\Form1.cs:linha 195
   em System.Windows.Forms.Form.OnShown(EventArgs e)
   em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   em System.Windows.Forms.Control.WndProc(Message& m)
   em System.Windows.Forms.Form.WndProc(Message& m)
   em System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   em System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   em System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   em System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   em UltraNFe.Program.Main() na C:\ultra\UltraNFe2\Program.cs:linha 64
   em System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
   em System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
   em Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
   em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   em System.Threading.ThreadHelper.ThreadStart()

Not ocurred in Firebird 2.5.7.27050 with FirebirdSQL.Data.FirebirdClient 2.7.7.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

        

Allow overriding only part of DefaultFbMigrationSqlGeneratorBehavior 
---------------------------------------------------------------------

                 Key: DNET-754
                 URL: http://tracker.firebirdsql.org/browse/DNET-754
             Project: .NET Data provider
          Issue Type: Task
          Components: Entity Framework support
    Affects Versions: 5.8.1.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


Mostly trigger name.

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

        

Problem with Tablename and CodeFirst
------------------------------------

                 Key: DNET-753
                 URL: http://tracker.firebirdsql.org/browse/DNET-753
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.8.1.0
         Environment: Firebird 2.5 Server, EntityFramework6.1.3, .net 4.6.2
            Reporter: Andreas Patock
            Assignee: Jiri Cincura


If we use a classname longer than 15 letters we get a "Name longer than database column size" on Update-Database.
I think someone does a byte count over a unicode string, so 16 letters result in 32 bytes and this is more than the firebird restriction.
What I wonder is that the problem didn't appear on foreignkey-names.


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

        

I finally remembered the additional step ... described in StackOverflow:

//-----------------------------------------------------------------------------------------------------------------------------------------------
//To install Firebird: Visual Studio 2013 -> File -> New -> Project,
etc. ---------- then Tools -> Library Package Manager -> Manage NuGet
//Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
Install (button).
//
//Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2)
FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
//add using FirebirdSql.Data.FirebirdClient;
//-----------------------------------------------------------------------------------------------------------------------------------------------
//!!!!!!!!!!!!!!!!stackoverflow.com/questions/42864674/how-do-i-create-a-firebird-database-file-programmatically!!!!!!!!!!!!!!!!!!!!
//
//From www.firebirdsql.org/en/firebird-3-0/ ... downloaded
Firebird-3.0.2.32703-0_x64.zip
//
//Unzipped into temporary subdir (Unzip)
//
//Created fb3embedded subdir in project subdir ... next to bin, obj, etc.
//
//Move from Unzip subdir to fb3embedded subdir
//        intl folder and all contents
//        plugins\engine12.dll
//        fbclient.dll
//        firebird.msg
//        icu*
//        msvcp100.dll
//        msvcr100.dll
//
// add to the code         public const string stCLIENT_LIBRARY =
@"..\..\fb3embedded\fbclient.dll";
//-----------------------------------------------------------------------------------------------------------------------------------------------

On Thu, Apr 6, 2017 at 8:36 AM, Clyde Eisenbeis <ct...@gm...> wrote:
> After most things work, I decided to start with a new program /
> project ... over time, the memory fades.
>
> Here is the procedure I used:
>
> To install Firebird: Visual Studio 2013 -> File -> New -> Project,
> etc. ---------- then Tools -> Library Package Manager -> Manage NuGet
> Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
> Install (button).
>
> Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2)
> FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.
>
> Then added "using FirebirdSql.Data.FirebirdClient".
>
> This statement results in a compile error:
>
>             string stCreateConnectionString = new FbConnectionStringBuilder {
>                 Database = stPathFilename,
>                 UserID = stUserID,
>                 Password = stPassword,
>                 ServerType = FbServerType.Embedded,
>                 ClientLibrary = stCLIENT_LIBRARY
>             }.ToString();
>
> Does not like "stCLIENT_LIBRARY".  What step am I missing?  Thanks!

No SQL-Statements in the console
--------------------------------

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


Hi,
we have used version 4.10.0.0 and in this version we see sqlstatements in debug and release.
We want to switch to version 5.8.1.0, but now the output of the statements is completely gone.
I tried to add a tracelistener to the app.config like in:
https://www.tabsoverspaces.com/232603-improved-command-logging-in-ado-net-provider-for-firebird-part-2/?utm_source=blog.cincura.net&shared=email&msg=fail&shared=email&msg=fail

but this doesn't work.

Please help - we want to see the SQLStatements when we create a debugversion of the application.

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

        

After most things work, I decided to start with a new program /
project ... over time, the memory fades.

Here is the procedure I used:

To install Firebird: Visual Studio 2013 -> File -> New -> Project,
etc. ---------- then Tools -> Library Package Manager -> Manage NuGet
Packages -> search "firebird" -> Firebird ADO.NET Data provider ->
Install (button).

Resulted in 1) References -> FirebirdSql.Data.FirebirdClient, and 2)
FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's.

Then added "using FirebirdSql.Data.FirebirdClient".

This statement results in a compile error:

            string stCreateConnectionString = new FbConnectionStringBuilder {
                Database = stPathFilename,
                UserID = stUserID,
                Password = stPassword,
                ServerType = FbServerType.Embedded,
                ClientLibrary = stCLIENT_LIBRARY
            }.ToString();

Does not like "stCLIENT_LIBRARY".  What step am I missing?  Thanks!

Got it, tanks

-----Mensagem original-----
De: Jiří Činčura [mailto:ji...@ci...] 
Enviada em: quinta-feira, 6 de abril de 2017 08:40
Para: fir...@li...
Assunto: Re: [Firebird-net-provider] RES: ADO.NET provider 5.8.1.0

You need new csproj support, aka VS2017.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

On Thu, Apr 6, 2017, at 13:37, Nicolas Timmers wrote:
> Hello Jiri
> 
> When i try to open the solution from version 5.8.1.0 I get the 
> fallowing message
> 
> C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\Fir
> ebirdSql.Data.FirebirdClient_NET45.csproj
> : error  : The default XML namespace of the project must be the 
> MSBuild XML namespace. If the project is authored in the MSBuild 2003 
> format, please add 
> xmlns="http://schemas.microsoft.com/developer/msbuild/2003" to the 
> <Project> element. If the project has been authored in the old 1.0 or
> 1.2 format, please convert it to MSBuild 2003 format. 
> C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\Fir
> ebirdSql.Data.FirebirdClient_NET45.csproj
> 
> 
> And the solution cannot be open, how can I proceed ?
> 
> 
> -----Mensagem original-----
> De: Jiří Činčura [mailto:ji...@ci...] Enviada em: quarta-feira, 5 
> de abril de 2017 03:13
> Para: For users & developers of the Firebird .NET providers 
> <fir...@li...>
> Cc: fir...@ya...; For discussion among Firebird 
> Developers <fir...@li...>
> Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0
> 
> More info:
> https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-fir
> ebird-is-ready/
> .
> 
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> ----------------------------------------------------------------------
> -------- 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

You need new csproj support, aka VS2017.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

On Thu, Apr 6, 2017, at 13:37, Nicolas Timmers wrote:
> Hello Jiri
> 
> When i try to open the solution from version 5.8.1.0 I get the fallowing
> message
> 
> C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj
> : error  : The default XML namespace of the project must be the MSBuild
> XML namespace. If the project is authored in the MSBuild 2003 format,
> please add xmlns="http://schemas.microsoft.com/developer/msbuild/2003" to
> the <Project> element. If the project has been authored in the old 1.0 or
> 1.2 format, please convert it to MSBuild 2003 format. 
> C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj
> 
> 
> And the solution cannot be open, how can I proceed ?
> 
> 
> -----Mensagem original-----
> De: Jiří Činčura [mailto:ji...@ci...] 
> Enviada em: quarta-feira, 5 de abril de 2017 03:13
> Para: For users & developers of the Firebird .NET providers
> <fir...@li...>
> Cc: fir...@ya...; For discussion among Firebird
> Developers <fir...@li...>
> Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0
> 
> More info:
> https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/
> .
> 
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> ------------------------------------------------------------------------------
> 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

Hello Jiri

When i try to open the solution from version 5.8.1.0 I get the fallowing message

C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj : error  : The default XML namespace of the project must be the MSBuild XML namespace. If the project is authored in the MSBuild 2003 format, please add xmlns="http://schemas.microsoft.com/developer/msbuild/2003" to the <Project> element. If the project has been authored in the old 1.0 or 1.2 format, please convert it to MSBuild 2003 format.  C:\temp\TEMP\Provider\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdSql.Data.FirebirdClient_NET45.csproj


And the solution cannot be open, how can I proceed ?


-----Mensagem original-----
De: Jiří Činčura [mailto:ji...@ci...] 
Enviada em: quarta-feira, 5 de abril de 2017 03:13
Para: For users & developers of the Firebird .NET providers <fir...@li...>
Cc: fir...@ya...; For discussion among Firebird Developers <fir...@li...>
Assunto: [Firebird-net-provider] ADO.NET provider 5.8.1.0

More info:
https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/
.

--
Mgr. Jiří Činčura
Independent IT Specialist

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

More info:
https://www.tabsoverspaces.com/233609-ado-net-provider-5-8-1-0-for-firebird-is-ready/
.

-- 
Mgr. Jiří Činčura
Independent IT Specialist

In netstandard1.6's NuGet reference NETStandard.Library and then extra packages
-------------------------------------------------------------------------------

                 Key: DNET-751
                 URL: http://tracker.firebirdsql.org/browse/DNET-751
             Project: .NET Data provider
          Issue Type: Task
          Components: NuGet packages
    Affects Versions: 5.8.1.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

        

is not possible applay command: Update-Database to migrate database on package manager console
----------------------------------------------------------------------------------------------

                 Key: DNET-750
                 URL: http://tracker.firebirdsql.org/browse/DNET-750
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 5.8.0.0
         Environment: Visual Studio 2015
FirebirdSql.Data.FirebirdClient 5.8.0.0
EntityFramework.Firebird 5.8.0.0
aspnetboilerplate with Module Zero v1.5.2
            Reporter: Roberto Carlos da Silva
            Assignee: Jiri Cincura
            Priority: Critical



PM> Update-Database -Verbose
Using StartUp project 'TestaSite.EntityFramework'.
Using NuGet project 'TestaSite.EntityFramework'.
Specify the '-Verbose' flag to view the SQL statements being applied to the target database.
System.NotSupportedException: There is no store type corresponding to the EDM type 'Edm.Byte' of primitive type 'Byte'.
   at FirebirdSql.Data.EntityFramework6.FbProviderManifest.GetStoreType(TypeUsage edmType) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbProviderManifest.cs:line 417
   at System.Data.Entity.ModelConfiguration.Edm.Services.StructuralTypeMappingGenerator.MapTableColumn(EdmProperty property, String columnName, Boolean isInstancePropertyOnDerivedType)
   at System.Data.Entity.ModelConfiguration.Edm.Services.PropertyMappingGenerator.Generate(EntityType entityType, IEnumerable`1 properties, EntitySetMapping entitySetMapping, MappingFragment entityTypeMappingFragment, IList`1 propertyPath, Boolean createNewColumn)
   at System.Data.Entity.ModelConfiguration.Edm.Services.TableMappingGenerator.Generate(EntityType entityType, DbDatabaseMapping databaseMapping)
   at System.Data.Entity.ModelConfiguration.Edm.Services.DatabaseMappingGenerator.GenerateEntityTypes(DbDatabaseMapping databaseMapping)
   at System.Data.Entity.ModelConfiguration.Edm.Services.DatabaseMappingGenerator.Generate(EdmModel conceptualModel)
   at System.Data.Entity.DbModelBuilder.Build(DbProviderManifest providerManifest, DbProviderInfo providerInfo)
   at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
   at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
   at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
   at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
   at System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes()
   at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()
   at Abp.EntityFramework.AbpDbContext.RegisterToChanges()
   at Abp.Zero.EntityFramework.AbpZeroDbContext`3..ctor(String nameOrConnectionString)
   at TestaSite.EntityFramework.TestaSiteDbContext..ctor() in C:\arquivos\TestaSite\TestaSite.EntityFramework\EntityFramework\TestaSiteDbContext.cs:line 20
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Data.Entity.Infrastructure.DbContextInfo.CreateInstance()
   at System.Data.Entity.Infrastructure.DbContextInfo..ctor(Type contextType, DbProviderInfo modelProviderInfo, AppConfig config, DbConnectionInfo connectionInfo, Func`1 resolver)
   at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration, DbContext usersContext, DatabaseExistenceState existenceState, Boolean calledByCreateDatabase)
   at System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration)
   at System.Data.Entity.Migrations.Design.ToolingFacade.BaseRunner.GetMigrator()
   at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.Run()
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Update(String targetMigration, Boolean force)
   at System.Data.Entity.Migrations.UpdateDatabaseCommand.<>c__DisplayClass2.<.ctor>b__0()
   at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)

There is no store type corresponding to the EDM type 'Edm.Byte' of primitive type 'Byte'.


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