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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-630) Support for Firebird 3.0

[Mark J. (JIRA) <tr...@fi...>]

Support for Firebird 3.0
------------------------

                 Key: DNET-630
                 URL: http://tracker.firebirdsql.org/browse/DNET-630
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
    Affects Versions: vNext
         Environment: Windows 10
            Reporter: Mark Junker
            Assignee: Jiri Cincura


It seems that the Firebird ADO.NET driver doesn't support Firebird 3.0 beta 2 yet. At least two things come to mind that probably have to be changed:

* Support for BOOLEAN data type
* Support for changed data structures
  * I found at least one situation where the data structure was changed: When I try to open an already opened embedded database


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

        

Re: [Firebird-net-provider] How to execute NUnit with Mono ?

[Jiří Č. <ji...@ci...>]

On Mon, Sep 14, 2015, at 12:41, Hajime Nakagami wrote:
> I can run my test.

BTW you can also run the NUnit GUI and select the test(s) you want to
execute. I find it easier when doing interactive debugging.

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

Re: [Firebird-net-provider] How to execute NUnit with Mono ?

[Hajime N. <nak...@gm...>]

Thanks Jiri and Mark.

Modify not to derived from TestsBase.

And with  --run=FirebirdSql.Data.UnitTests.SrpTests option,

I can run my test.

Regards.

2015-09-14 19:18 GMT+09:00 Mark Rotteveel <ma...@la...>:

> On 14-9-2015 12:02, Hajime Nakagami wrote:
> > Hi, Jiri and all.
> >
> >
> > I am writing NUnit test (at first time) now.
> >
> >
> >
> https://github.com/nakagami/FirebirdSql.Data.FirebirdClient/compare/srp...nakagami:srp_tests
> >
> >
> > It seems compile success.
> >
> > But something wrong to run that test.
> >
> >
> > My environment is Ubuntu12.04 and mono 4.2
> >
> >
> > $ mono --version
> >
> > Mono JIT compiler version 4.2.0 (Stable 4.2.0.179/a224653
> > <http://4.2.0.179/a224653> Sat Aug 29 00:01:20 JST 2015)
> >
> > Copyright (C) 2002-2014 Novell, Inc, Xamarin Inc and Contributors.
> > www.mono-project.com <http://www.mono-project.com>
> >
> >      TLS:           __thread
> >
> >      SIGSEGV:       altstack
> >
> >      Notifications: epoll
> >
> >      Architecture:  amd64
> >
> >      Disabled:      none
> >
> >      Misc:          softdebug
> >
> >      LLVM:          supported, not enabled.
> >
> >      GC:            sgen
> >
> >
> > $ mono /usr/local/lib/mono/4.5/nunit-console.exe
> >
> NETProvider/src/FirebirdSql.Data.UnitTests/bin/Debug/FirebirdSql.Data.UnitTests.dll
> > --run=SrpClient
> >
> >
> > NUnit version 2.4.8
> >
> > Copyright (C) 2002-2007 Charlie Poole.
> >
> > Copyright (C) 2002-2004 James W. Newkirk, Michael C. Two, Alexei A.
> > Vorontsov.
> >
> > Copyright (C) 2000-2002 Philip Craig.
> >
> > All Rights Reserved.
> >
> >
> > Runtime Environment -
> >
> >     OS Version: Unix 3.13.0.63
> >
> >       CLR Version: 4.0.30319.17020 ( 4.2.0 (Stable 4.2.0.179/a224653
> > <http://4.2.0.179/a224653> Sat Aug 29 00:01:20 JST 2015) )
> >
> >
> >       Selected test: SrpClient
> >
> >
> >       Tests run: 0, Failures: 0, Not run: 0, Time: 0.002 seconds
>
> The class SrpClient doesn't contain tests (and it is also not in the
> assembly FirebirdSql.Data.UnitTests).
>
> Maybe you meant --run=SrpTests or
> --run=FirebirdSql.Data.UnitTests.SrpTests ?
>
> --
> Mark Rotteveel
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] How to execute NUnit with Mono ?

[Mark R. <ma...@la...>]

On 14-9-2015 12:02, Hajime Nakagami wrote:
> Hi, Jiri and all.
>
>
> I am writing NUnit test (at first time) now.
>
>
> https://github.com/nakagami/FirebirdSql.Data.FirebirdClient/compare/srp...nakagami:srp_tests
>
>
> It seems compile success.
>
> But something wrong to run that test.
>
>
> My environment is Ubuntu12.04 and mono 4.2
>
>
> $ mono --version
>
> Mono JIT compiler version 4.2.0 (Stable 4.2.0.179/a224653
> <http://4.2.0.179/a224653> Sat Aug 29 00:01:20 JST 2015)
>
> Copyright (C) 2002-2014 Novell, Inc, Xamarin Inc and Contributors.
> www.mono-project.com <http://www.mono-project.com>
>
>      TLS:           __thread
>
>      SIGSEGV:       altstack
>
>      Notifications: epoll
>
>      Architecture:  amd64
>
>      Disabled:      none
>
>      Misc:          softdebug
>
>      LLVM:          supported, not enabled.
>
>      GC:            sgen
>
>
> $ mono /usr/local/lib/mono/4.5/nunit-console.exe
> NETProvider/src/FirebirdSql.Data.UnitTests/bin/Debug/FirebirdSql.Data.UnitTests.dll
> --run=SrpClient
>
>
> NUnit version 2.4.8
>
> Copyright (C) 2002-2007 Charlie Poole.
>
> Copyright (C) 2002-2004 James W. Newkirk, Michael C. Two, Alexei A.
> Vorontsov.
>
> Copyright (C) 2000-2002 Philip Craig.
>
> All Rights Reserved.
>
>
> Runtime Environment -
>
>     OS Version: Unix 3.13.0.63
>
>       CLR Version: 4.0.30319.17020 ( 4.2.0 (Stable 4.2.0.179/a224653
> <http://4.2.0.179/a224653> Sat Aug 29 00:01:20 JST 2015) )
>
>
>       Selected test: SrpClient
>
>
>       Tests run: 0, Failures: 0, Not run: 0, Time: 0.002 seconds

The class SrpClient doesn't contain tests (and it is also not in the 
assembly FirebirdSql.Data.UnitTests).

Maybe you meant --run=SrpTests or 
--run=FirebirdSql.Data.UnitTests.SrpTests ?

-- 
Mark Rotteveel

Re: [Firebird-net-provider] How to execute NUnit with Mono ?

[Jiří Č. <ji...@ci...>]

On Mon, Sep 14, 2015, at 12:02, Hajime Nakagami wrote:
> $ mono /usr/local/lib/mono/4.5/nunit-console.exe
> NETProvider/src/FirebirdSql.Data.UnitTests/bin/Debug/FirebirdSql.Data.UnitTests.dll
> --run=SrpClient

Your test is called KeyMatchTest, not SrpClient. Also you don't need to
derive from TestsBase as you don't need database. Nor you need to add
any attributes.

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

[Firebird-net-provider] How to execute NUnit with Mono ?

[Hajime N. <nak...@gm...>]

Hi, Jiri and all.


I am writing NUnit test (at first time) now.


https://github.com/nakagami/FirebirdSql.Data.FirebirdClient/compare/srp...nakagami:srp_tests


It seems compile success.

But something wrong to run that test.


My environment is Ubuntu12.04 and mono 4.2


$ mono --version

Mono JIT compiler version 4.2.0 (Stable 4.2.0.179/a224653 Sat Aug 29
00:01:20 JST 2015)

Copyright (C) 2002-2014 Novell, Inc, Xamarin Inc and Contributors.
www.mono-project.com

    TLS:           __thread

    SIGSEGV:       altstack

    Notifications: epoll

    Architecture:  amd64

    Disabled:      none

    Misc:          softdebug

    LLVM:          supported, not enabled.

    GC:            sgen


$ mono /usr/local/lib/mono/4.5/nunit-console.exe
NETProvider/src/FirebirdSql.Data.UnitTests/bin/Debug/FirebirdSql.Data.UnitTests.dll
--run=SrpClient


NUnit version 2.4.8

Copyright (C) 2002-2007 Charlie Poole.

Copyright (C) 2002-2004 James W. Newkirk, Michael C. Two, Alexei A.
Vorontsov.

Copyright (C) 2000-2002 Philip Craig.

All Rights Reserved.


Runtime Environment -

   OS Version: Unix 3.13.0.63

     CLR Version: 4.0.30319.17020 ( 4.2.0 (Stable 4.2.0.179/a224653 Sat Aug
29 00:01:20 JST 2015) )


     Selected test: SrpClient


     Tests run: 0, Failures: 0, Not run: 0, Time: 0.002 seconds


How can I run that test ?

[Firebird-net-provider] ADO.NET provider 4.8.0.0

[Jiří Č. <ji...@ci...>]

More info
http://blog.cincura.net/233530-ado-net-provider-4-8-0-0-for-firebird-is-ready/
.

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-629) Faster marshaling

[Jiri C. (JIRA) <tr...@fi...>]

Faster marshaling
-----------------

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


https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/36

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

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-628) Support for isc_action_svc_validate

[Jiri C. (JIRA) <tr...@fi...>]

Support for isc_action_svc_validate
-----------------------------------

                 Key: DNET-628
                 URL: http://tracker.firebirdsql.org/browse/DNET-628
             Project: .NET Data provider
          Issue Type: New Feature
          Components: ADO.NET Provider
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura
            Priority: Minor


Support for FB3's isc_action_svc_validate.

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

        

Re: [Firebird-net-provider] One or multiple EDMX with EF

[Jiří Č. <ji...@ci...>]

That's not a big model. That *can* go into one model. Although you might
study something like bounded contexts to get a perspective.

-- 

Mgr. Jiří Činčura

Independent IT Specialist

[Firebird-net-provider] One or multiple EDMX with EF

[Parzival <par...@gm...>]

Hello all,

 

what is your experience/recommandation on have one or multiple EDMX files?

 

There are about 30 tables and a number of SPs that will be put into the
EDMX.

 

The question is should it be put in one or multiple EDMX? Nearly all tables
are linked to each other with FKs.

 

Please let me know what you think.

 

Thanks

 

Niko

Re: [Firebird-net-provider] WPF/FB Client interaction issue

[Kevin D. <kd...@ms...>]

On Wed, Sep 2, 2015 at 11:57 PM, Jiří Činčura <ji...@ci...> wrote:

> > Try to stay clear of DataTables. They are a huge hassle to use. Rather
> use
> > strongly-type objects out of your data access layer.
>
> Seconded. The days of datasets are long over.
>
It's not really an option for me right now. We have a lot of legacy code
using DataTable. I've don't have much choice but to make this work.

kd

Re: [Firebird-net-provider] WPF/FB Client interaction issue

[Daniel R. <da...@ac...>]

Hi,

At September 2, 2015, 5:34 PM, Kevin Donn wrote:

> I've stumbled on either the depth of my own ignorance or a fairly
> serious problem when using the Firebird .NET Client in a WPF app. It
> seems there's something wrong with the columns that get built during
> FbDataAdapter.Fill(DataTable). The columns do not seem to support data
> binding properly. Specifically, UI elements don't get updated when
> values in the column change. The example code I've provided
> demonstrates that columns created prior to Fill and columns created
> after Fill both work as expected, but columns created during Fill do
> not. The example also shows that if you fill the DataTable from a SQL
> Server source with everything else kept the same, columns created
> during Fill work as expected.

> To run the project you'll need to provide some connection string info
> and modify the query to return a few rows of string data with a field
> named LastName. You may also need to drop in a reference to the
> Firebird Client assembly which I removed so as not to send any
> binaries.

> When the interface comes up, alter any value in the third column and
> tab away. The expectation is that the value in the fourth column will
> reflect the change, but for me it doesn't. I'm running against a 2.1.4
> server. If you alter the value in either the first or second column
> and tab away, the other column is updated.

Someone   asked  a  similar  question on StackOverflow, and the answer
might be of some help to you:
http://stackoverflow.com/questions/15484296/wpf-bind-control-to-dataview

We use ADO.Net Entity Framework for the binding in WPF.  It works
very well, and very well suited for WPF data binding.

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-627) Named Instance cannot connect

[Rand R. (JIRA) <tr...@fi...>]

Named Instance cannot connect
-----------------------------

                 Key: DNET-627
                 URL: http://tracker.firebirdsql.org/browse/DNET-627
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.7.0.0
         Environment: Win7 - 4.7.0.0 - Firebird 2.5
            Reporter: Rand Random
            Assignee: Jiri Cincura


I have installed a named instance with the following command

(Notice that before executing this command I already had firebird server installed, so I now have a default instance and a named, access to the default still works fine but it fails to connect to named instance)
"C:\Program Files\Firebird\Firebird_2_5\\bin\instsvc" install -name XYZ <-- installs firebird with the named instance
"sc"  start "FirebirdServerCONNEX" <-- starts the service


and now I try to connect to this instance with .NET Provider but it fails with the following exception:
Unable to complete network request to host "localhost/CONNEX"

Am I doing something wrong or is there a problem?

My FbConnectionStringBuilder looks like this:

            return new FbConnectionStringBuilder
            {
                Charset = "UTF8",
                Database = "C:\Test\foo.fdb",
                DataSource = "localhost/XYZ",
                UserID = "SYSDBA",
                Password = "masterkey",
            }.ToString();

Hope you can help me out.

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

        

Re: [Firebird-net-provider] WPF/FB Client interaction issue

[Jiří Č. <ji...@ci...>]

> Try to stay clear of DataTables. They are a huge hassle to use. Rather use
> strongly-type objects out of your data access layer.

Seconded. The days of datasets are long over.
-- 
Mgr. Jiří Činčura
Independent IT Specialist

Re: [Firebird-net-provider] WPF/FB Client interaction issue

[Louis v. A. <lo...@nu...>]

Not very familiar with WPF binding and did not read your source in depth But
I am very familiar with binding in WinForms. The key to binding in WinForms
is that  each property of your object should raise the PropertyChanged event
when the value changes. This tells bound controls to update. So a typical
property will look like this:

public string P1
{
  get { return p1;}
  set
  {
    if (value == p1)
      return;
   
    p1 = value;
    OnPropertyChanged("P1");
  }
}

The binding to the control will know that it is bound to the P1 property and
update if it receives the PropertyChanged("P1") event.

What is probably happening is that the DataTable columns are not raising the
event correctly when they are updated. Not sure if DataColumn even raises
the event. Likely not.
Try to stay clear of DataTables. They are a huge hassle to use. Rather use
strongly-type objects out of your data access layer.

Louis


-----Original Message-----
From: Kevin Donn [mailto:kd...@ms...] 
Sent: 02 September 2015 10:35 PM
To: fir...@li...
Subject: [Firebird-net-provider] WPF/FB Client interaction issue

I've stumbled on either the depth of my own ignorance or a fairly serious
problem when using the Firebird .NET Client in a WPF app. It seems there's
something wrong with the columns that get built during
FbDataAdapter.Fill(DataTable). The columns do not seem to support data
binding properly. Specifically, UI elements don't get updated when values in
the column change. The example code I've provided demonstrates that columns
created prior to Fill and columns created after Fill both work as expected,
but columns created during Fill do not. The example also shows that if you
fill the DataTable from a SQL Server source with everything else kept the
same, columns created during Fill work as expected.

To run the project you'll need to provide some connection string info and
modify the query to return a few rows of string data with a field named
LastName. You may also need to drop in a reference to the Firebird Client
assembly which I removed so as not to send any binaries.

When the interface comes up, alter any value in the third column and tab
away. The expectation is that the value in the fourth column will reflect
the change, but for me it doesn't. I'm running against a 2.1.4 server. If
you alter the value in either the first or second column and tab away, the
other column is updated.

The example project source can be downloaded here:
https://msedd.com/LinkClick.aspx?fileticket=EcRAVG14WA8%3d&portalid=0

I've pasted in the relevant parts below. The MainWindow XAML:

<Window x:Class="FirebirdWPFBug.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
      <ItemsControl ItemsSource="{Binding COEStudents}">
         <ItemsControl.ItemTemplate>
            <DataTemplate>
               <Grid>

<Grid.ColumnDefinitions><ColumnDefinition/><ColumnDefinition/><ColumnDefinit
ion/><ColumnDefinition/></Grid.ColumnDefinitions>
                  <TextBox Text="{Binding [Foo]}" Grid.Column="0"/>
                  <TextBox Text="{Binding [Foo]}" Grid.Column="1"/>
                  <TextBox Text="{Binding [LastName]}" Grid.Column="2"/>
                  <TextBox Text="{Binding [LastName]}" Grid.Column="3"/>
               </Grid>
            </DataTemplate>
         </ItemsControl.ItemTemplate>
      </ItemsControl>
    </Grid>
</Window>

The MainWindow code behind:

namespace FirebirdWPFBug {
   public partial class MainWindow: Window {
      public MainWindow() {
         InitializeComponent();
         DataContext=new COEVM();
      }
   }

   public class COEVM {
      DataTable coeStudTable;

      public DataView COEStudents { get { return coeStudTable.DefaultView; }
}

      public COEVM() {
         coeStudTable=new DataTable();

         // The test is simply to run the project, change a value in the
third column, tab away, and
         // note that the fourth column (which is bound to the same
DataColumn) does not update. Making
         // a change to the first or second column will cause the other to
update.

         // Uncomment these lines to run with SQL Server. You'll need to
point to an existing database and
         // provide a query that produces a few rows of data with a column
named LastName.
         //System.Data.SqlClient.SqlDataAdapter adapter=
         //   new System.Data.SqlClient.SqlDataAdapter(
         //      "select top 3 LastName from HRRM",
         //      @"Data Source=localhost\SQLEXPRESS;Initial
Catalog=Viewpoint2;Integrated Security=True");

         // In the FbConnection below, you'll need to provide a value for
"initial catalog", "user id", and
         // "password". You'll also need to provide a query that produces a
few rows of data with a column
         // named LastName.
         // Comment out these lines to use the SQL Server test above.
         FirebirdSql.Data.FirebirdClient.FbConnection conn=new
FirebirdSql.Data.FirebirdClient.FbConnection(
            @"dialect=3;charset=NONE;connection lifetime=0;connection
timeout=15;pooling=True;"+
            "packet size=8192;initial
catalog=localhost:c:\\Users\\kdonn\\DBs\\NE\\MIS2000.fdb;"+
            "server type=Default;user id=userid;password=password");
         FirebirdSql.Data.FirebirdClient.FbDataAdapter adapter=
            new FirebirdSql.Data.FirebirdClient.FbDataAdapter("select
first 3 LastName from Student", conn);

         // Uncomment this line to demonstrate that columns created
*before* Fill work as expected.
         //coeStudTable.Columns.Add("LastName", typeof(string));

         adapter.Fill(coeStudTable);

         // These lines demonstrate that columns created *after* Fill also
work as expected.
         coeStudTable.Columns.Add("Foo", typeof(string));
         foreach (DataRow r in coeStudTable.Rows)
            r["Foo"]=r["LastName"];

         // These lines demonstrate that changes are making it from the UI
back to the DataColumn, but
         // notification is not making it back out to the UI.
         coeStudTable.ColumnChanging+=coeStud_ColumnChanging;
         coeStudTable.RowChanging+=coeStud_RowChanging;
      }

      void coeStud_RowChanging(object sender, DataRowChangeEventArgs e) {
         System.Diagnostics.Debug.WriteLine("RowChanging");
      }

      void coeStud_ColumnChanging(object sender, DataColumnChangeEventArgs
e) {
         System.Diagnostics.Debug.WriteLine("ColumnChanging");
      }
   }
}

----------------------------------------------------------------------------
--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] WPF/FB Client interaction issue

[Kevin D. <kd...@ms...>]

I've stumbled on either the depth of my own ignorance or a fairly
serious problem when using the Firebird .NET Client in a WPF app. It
seems there's something wrong with the columns that get built during
FbDataAdapter.Fill(DataTable). The columns do not seem to support data
binding properly. Specifically, UI elements don't get updated when
values in the column change. The example code I've provided
demonstrates that columns created prior to Fill and columns created
after Fill both work as expected, but columns created during Fill do
not. The example also shows that if you fill the DataTable from a SQL
Server source with everything else kept the same, columns created
during Fill work as expected.

To run the project you'll need to provide some connection string info
and modify the query to return a few rows of string data with a field
named LastName. You may also need to drop in a reference to the
Firebird Client assembly which I removed so as not to send any
binaries.

When the interface comes up, alter any value in the third column and
tab away. The expectation is that the value in the fourth column will
reflect the change, but for me it doesn't. I'm running against a 2.1.4
server. If you alter the value in either the first or second column
and tab away, the other column is updated.

The example project source can be downloaded here:
https://msedd.com/LinkClick.aspx?fileticket=EcRAVG14WA8%3d&portalid=0

I've pasted in the relevant parts below. The MainWindow XAML:

<Window x:Class="FirebirdWPFBug.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
      <ItemsControl ItemsSource="{Binding COEStudents}">
         <ItemsControl.ItemTemplate>
            <DataTemplate>
               <Grid>

<Grid.ColumnDefinitions><ColumnDefinition/><ColumnDefinition/><ColumnDefinition/><ColumnDefinition/></Grid.ColumnDefinitions>
                  <TextBox Text="{Binding [Foo]}" Grid.Column="0"/>
                  <TextBox Text="{Binding [Foo]}" Grid.Column="1"/>
                  <TextBox Text="{Binding [LastName]}" Grid.Column="2"/>
                  <TextBox Text="{Binding [LastName]}" Grid.Column="3"/>
               </Grid>
            </DataTemplate>
         </ItemsControl.ItemTemplate>
      </ItemsControl>
    </Grid>
</Window>

The MainWindow code behind:

namespace FirebirdWPFBug {
   public partial class MainWindow: Window {
      public MainWindow() {
         InitializeComponent();
         DataContext=new COEVM();
      }
   }

   public class COEVM {
      DataTable coeStudTable;

      public DataView COEStudents { get { return coeStudTable.DefaultView; } }

      public COEVM() {
         coeStudTable=new DataTable();

         // The test is simply to run the project, change a value in
the third column, tab away, and
         // note that the fourth column (which is bound to the same
DataColumn) does not update. Making
         // a change to the first or second column will cause the
other to update.

         // Uncomment these lines to run with SQL Server. You'll need
to point to an existing database and
         // provide a query that produces a few rows of data with a
column named LastName.
         //System.Data.SqlClient.SqlDataAdapter adapter=
         //   new System.Data.SqlClient.SqlDataAdapter(
         //      "select top 3 LastName from HRRM",
         //      @"Data Source=localhost\SQLEXPRESS;Initial
Catalog=Viewpoint2;Integrated Security=True");

         // In the FbConnection below, you'll need to provide a value
for "initial catalog", "user id", and
         // "password". You'll also need to provide a query that
produces a few rows of data with a column
         // named LastName.
         // Comment out these lines to use the SQL Server test above.
         FirebirdSql.Data.FirebirdClient.FbConnection conn=new
FirebirdSql.Data.FirebirdClient.FbConnection(
            @"dialect=3;charset=NONE;connection lifetime=0;connection
timeout=15;pooling=True;"+
            "packet size=8192;initial
catalog=localhost:c:\\Users\\kdonn\\DBs\\NE\\MIS2000.fdb;"+
            "server type=Default;user id=userid;password=password");
         FirebirdSql.Data.FirebirdClient.FbDataAdapter adapter=
            new FirebirdSql.Data.FirebirdClient.FbDataAdapter("select
first 3 LastName from Student", conn);

         // Uncomment this line to demonstrate that columns created
*before* Fill work as expected.
         //coeStudTable.Columns.Add("LastName", typeof(string));

         adapter.Fill(coeStudTable);

         // These lines demonstrate that columns created *after* Fill
also work as expected.
         coeStudTable.Columns.Add("Foo", typeof(string));
         foreach (DataRow r in coeStudTable.Rows)
            r["Foo"]=r["LastName"];

         // These lines demonstrate that changes are making it from
the UI back to the DataColumn, but
         // notification is not making it back out to the UI.
         coeStudTable.ColumnChanging+=coeStud_ColumnChanging;
         coeStudTable.RowChanging+=coeStud_RowChanging;
      }

      void coeStud_RowChanging(object sender, DataRowChangeEventArgs e) {
         System.Diagnostics.Debug.WriteLine("RowChanging");
      }

      void coeStud_ColumnChanging(object sender, DataColumnChangeEventArgs e) {
         System.Diagnostics.Debug.WriteLine("ColumnChanging");
      }
   }
}

Re: [Firebird-net-provider] Migrations

[Jiří Č. <ji...@ci...>]

That’s what I’m talking about!

By default I would not make it shorter. The default value is expected and somebody might create namespace long enough to break it. When somebody needs it shorter, the history context is customizable. Half of the users don’t even want to think about it.

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

From: Геннадий Забула [mailto:zab...@gm...]
Sent: Sunday, August 30, 2015 11:16 AM
To: For users and developers of the Firebird .NET providers <fir...@li...>
Subject: Re: [Firebird-net-provider] Migrations

2. According to this: https://msdn.microsoft.com/en-us/data/dn456841.aspx there might be problem with ContextKey field because it is PK. But there is a workaround that allows to decrease size of the field. Don't know why this field need to be so long.

Do I need to fill tracker issues for described problems to track progress?
________________________________
From: Jiří Činčura<mailto:ji...@ci...>
Sent: ‎8/‎30/‎2015 9:08 AM
To: For users and developers of the Firebird .NET providers<mailto:fir...@li...>
Subject: Re: [Firebird-net-provider] Migrations
1. I think table names need to be preserved. Developer is reponsible for checking for that constraint. The name is defined. But I meant generated names, like PK name (if not specified). It's same for column names etc. It would be pretty confusing to later open that database and see just weird characters.
2. AFAIK you still need 16k database to be able to make PK (or maybe just 8k is enough, not 4k for sure).
4. OK, that might be bug.

--
Mgr. Jiří Činčura
Independent IT Specialist
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

[Геннадий З. <zab...@gm...>]

2. According to this: https://msdn.microsoft.com/en-us/data/dn456841.aspx there might be problem with ContextKey field because it is PK. But there is a workaround that allows to decrease size of the field. Don't know why this field need to be so long.

Do I need to fill tracker issues for described problems to track progress?

-----Original Message-----
From: "Jiří Činčura" <ji...@ci...>
Sent: ‎8/‎30/‎2015 9:08 AM
To: "For users and developers of the Firebird .NET providers" <fir...@li...>
Subject: Re: [Firebird-net-provider] Migrations

1. I think table names need to be preserved. Developer is reponsible for checking for that constraint. The name is defined. But I meant generated names, like PK name (if not specified). It's same for column names etc. It would be pretty confusing to later open that database and see just weird characters.
2. AFAIK you still need 16k database to be able to make PK (or maybe just 8k is enough, not 4k for sure).  
4. OK, that might be bug. 

-- 
Mgr. Jiří Činčura
Independent IT Specialist
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

[Jiří Č. <ji...@ci...>]

1. I think table names need to be preserved. Developer is reponsible for checking for that constraint. The name is defined. But I meant generated names, like PK name (if not specified). It's same for column names etc. It would be pretty confusing to later open that database and see just weird characters.
2. AFAIK you still need 16k database to be able to make PK (or maybe just 8k is enough, not 4k for sure).  
4. OK, that might be bug. 

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

Re: [Firebird-net-provider] DNET-532

[Геннадий З. <zab...@gm...>]

Fresh PR for this issue:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/35

On 27 August 2015 at 07:58, Jiří Činčura <ji...@ci...> wrote:
>> One more question about string.Equals. Comparison type used in IndexOf
>> calls is StringComparison.CurrentCultureIgnoreCase. My question why this
>> used instead of OrdinalIgnoreCase?
>> My current optimization, including StringComparison change decreased
>> timings to 22 (names) vs 6 (indexes) seconds.
>
> Because of national characters. Somebody might use these in parameter name. Although it's pretty weird, I had similar issue in DDEX.
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

[Геннадий З. <zab...@gm...>]

1. I've used hashes from names to avoid dictionaries for mapping name-guid.
2. I think it was about Model field. More precise error I'll tell tomorrow when PC will be available. I don't want to constraint page size, because changing page size for existing databases is done only via backup-restore AFAIK. In case of several GB dbs it's not an option.
3. Yes. Default behavior maybe several pre defined and possibility to provide custom.
4. One more issue I remembered. Dbs created with Initial migration and via CreateDatabaseIfNotExists have different underlying scheme in part of names. I think this should be also fixed.

-----Original Message-----
From: "Jiří Činčura" <ji...@ci...>
Sent: ‎8/‎29/‎2015 10:08 PM
To: "For users and developers of the Firebird .NET providers" <fir...@li...>
Subject: Re: [Firebird-net-provider] Migrations

> 1. Long names of tables causes foreign key script creation fail with error "Name exceeded implementation limitation". This caused by 31 characters limitation to almost anything not only FK. We crutched this with hashing names   with base64 convert. Ugly but works.

Maybe we can, in case it's longer than 31 characters, simply use GUID. Not nice either, though.

> 2. Second it is drop from support databases with pages less than 16384 because of another impl. limitation for max string field length. This breaks creating MigrationHistory table. We didn't fixed this, because started using separate database. But in near future our previous database would also need to have migrations. I think this can be crutched to use blob field only for Model field of this table.

You mean the PK on MigrationHistory? We can specify 16k page size as a requirement. There's not much to invent on the PK.

> 3. Issue with sequence generators. Maybe you remember discussion about this on github. Looks like I've found good place to configurate particular field. It is in OnModelCreating Properties().Configure(x=>x.AddAnotation()) for property. There user can specify what sequence behavior does he need or provide custom.

True. And with custom convention it's not even needed to specify it explicitly for every column.

> Today I tried to add tests for all this to repo but found out that we need to add separate test infrastructure for EF tests.

There's few tests I wrote. Using CF as that's easy to set up. But maybe the migrations would need deeper setup.

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


------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

[Jiří Č. <ji...@ci...>]

> 1. Long names of tables causes foreign key script creation fail with error "Name exceeded implementation limitation". This caused by 31 characters limitation to almost anything not only FK. We crutched this with hashing names   with base64 convert. Ugly but works.

Maybe we can, in case it's longer than 31 characters, simply use GUID. Not nice either, though.

> 2. Second it is drop from support databases with pages less than 16384 because of another impl. limitation for max string field length. This breaks creating MigrationHistory table. We didn't fixed this, because started using separate database. But in near future our previous database would also need to have migrations. I think this can be crutched to use blob field only for Model field of this table.

You mean the PK on MigrationHistory? We can specify 16k page size as a requirement. There's not much to invent on the PK.

> 3. Issue with sequence generators. Maybe you remember discussion about this on github. Looks like I've found good place to configurate particular field. It is in OnModelCreating Properties().Configure(x=>x.AddAnotation()) for property. There user can specify what sequence behavior does he need or provide custom.

True. And with custom convention it's not even needed to specify it explicitly for every column.

> Today I tried to add tests for all this to repo but found out that we need to add separate test infrastructure for EF tests.

There's few tests I wrote. Using CF as that's easy to set up. But maybe the migrations would need deeper setup.

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

Re: [Firebird-net-provider] fbstreambackup: "free disk space exhausted"

[Parzival <par...@gm...>]

Hello Jiri,

thanks - that explains the message. I will update the FB Servers on the customers site to 2.5.4 over the next weeks/months. Then the feature is ready to go.

Niko

-----Ursprüngliche Nachricht-----
Von: Jiří Činčura [mailto:ji...@ci...] 
Gesendet: Samstag, 29. August 2015 18:17
An: For users and developers of the Firebird .NET providers <fir...@li...>
Betreff: Re: [Firebird-net-provider] fbstreambackup: "free disk space exhausted"

This error you'll get when the server version you're using does not support this feature. It was introduced in 2.5.3 I think and 2.5.2 would not cut it.

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

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Migrations

[Геннадий З. <zab...@gm...>]

Ok. For now we had such issues:
1. Long names of tables causes foreign key script creation fail with error "Name exceeded implementation limitation". This caused by 31 characters limitation to almost anything not only FK. We crutched this with hashing names   with base64 convert. Ugly but works.
2. Second it is drop from support databases with pages less than 16384 because of another impl. limitation for max string field length. This breaks creating MigrationHistory table. We didn't fixed this, because started using separate database. But in near future our previous database would also need to have migrations. I think this can be crutched to use blob field only for Model field of this table.
3. Issue with sequence generators. Maybe you remember discussion about this on github. Looks like I've found good place to configurate particular field. It is in OnModelCreating Properties().Configure(x=>x.AddAnotation()) for property. There user can specify what sequence behavior does he need or provide custom.

Today I tried to add tests for all this to repo but found out that we need to add separate test infrastructure for EF tests.

-----Original Message-----
From: "Jiří Činčura" <ji...@ci...>
Sent: ‎8/‎29/‎2015 7:29 PM
To: "For users and developers of the Firebird .NET providers" <fir...@li...>
Subject: Re: [Firebird-net-provider] Migrations

Also if you have some feedback you can discuss it here ahead of time. No problem with that.

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

------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider