Re: [Firebird-net-provider] Entity Framework 6

[Daniel Rail]

Hi,

At February 10, 2017, 8:12 AM, Jiří Činčura wrote:

>> it(when compiled). And, since the application that is calling this
>> .dll is not a .Net application(it's a native Win32 Delphi
>> application), I am trying to find out how to setup the entity

> Again. You're not saying how are you loading it. You can load DLL and
> execute some code from it even with config file. Depends how you're
> loading the CLR (and if, also).

Just to add to the context.

I'm using RemObjects Hydra as the plugin architecture, for our
application, and it's Hydra that loads the .Net assembly DLL. The DLL
is ComVisible. But other than looking in Hydra's code, I can't say how
the DLL is loaded.

Again thanks for the information.

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Daniel Rail]

Hi,

At February 10, 2017, 8:13 AM, Jiří Činčura wrote:

> Also, if you'd read my blog, you'd have been done already:
> https://blog.cincura.net/233368-configuring-3rd-party-entity-framework-provider-firebird-from-code/
> ;)

Thanks, that's what I was looking for. I do remember coming across it,
but when I did, that wasn't the information that I was looking for at
the time. At first, I was just trying to figure out why I didn't have
the ADO.Net Entity Data Model template in Visual Studio, just to find
out, after searching for almost a day, that I needed to install either
the Web Developer Tools or SQL Server Data Tools, when installing
VS2015.

Anyway, thanks for the information and your hard work on the ADO.Net
provider.

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Jiří Činčura]

Also, if you'd read my blog, you'd have been done already:
https://blog.cincura.net/233368-configuring-3rd-party-entity-framework-provider-firebird-from-code/
;)

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Jiří Činčura]

> An exception of type 'System.InvalidOperationException' occurred in
> EntityFramework.dll but was not handled in user code
> 
> Additional information: No Entity Framework provider found for the
> ADO.NET provider with invariant name
> 'FirebirdSql.Data.FirebirdClient'. Make sure the provider is
> registered in the 'entityFramework' section of the application config
> file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more
> information.

In your DbConfiguration class register the FbProviderServices. Here's a
field for that:
https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/master/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbProviderServices.cs#L64
(you can also use the ProviderInvariantName).

> it(when compiled). And, since the application that is calling this
> .dll is not a .Net application(it's a native Win32 Delphi
> application), I am trying to find out how to setup the entity

Again. You're not saying how are you loading it. You can load DLL and
execute some code from it even with config file. Depends how you're
loading the CLR (and if, also).

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Daniel Rail]

Title: Re: [Firebird-net-provider] Entity Framework 6


Hi,

At February 9, 2017, 6:52 PM, Paul Dryden wrote:





I have have had problems using Windows Entity Data Framework. In some cases, I can't open an edmx file in Visual Studio (that I had compiled from scanning a database perhaps a year earlier, always receiving "Provider Not Found." Very frustrating.



Actually, with Code First in EF6, I'm not dealing with an edmx file at all.

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Daniel Rail]

Hi,

At February 10, 2017, 3:28 AM, Jiří Činčura wrote:

> Well, you're not saying anything specific about the exception (at least
> which provider - EF or ADO.NET?) nor how's the assembly loaded (because
> you can as well use the config file, depending on how it's loaded).

> Let's guess that it's a ADO.NET provider, then you're probably missing
> the DbProviderFactory piece
> (https://github.com/cincuranet/EF6_Firebird/blob/master/CodeFirst/App.config#L12).
> With that, I would go the easiest way and pass directly FbConnection to
> DbContext's ctor. 

Sorry, for not being clearer.

Here's  the  exact  error  message,  that  I receive when running from
Visual Studio:

[Error Message Quote]
An exception of type 'System.InvalidOperationException' occurred in
EntityFramework.dll but was not handled in user code

Additional information: No Entity Framework provider found for the
ADO.NET provider with invariant name
'FirebirdSql.Data.FirebirdClient'. Make sure the provider is
registered in the 'entityFramework' section of the application config
file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more
information.
[/Error Message Quote]

Here's the code that I use:

  using (var db = new FiloptoDataLibrary.FiloptoQuickBooksModel(new 
FbConnection(vFBConnectionString.ToString()), true))
  {
   ...
  }

The FiloptoQuickBooksModel is inherited from DbContext, and was
created by the Entity Framework Tools Code First from Database wizard.
The vFBConnectionString is a FbConnectionStringBuilder.

And, in the project's App.Config, all the entries are there. But, the
project compiles to a .dll and doesn't have a .config file with
it(when compiled). And, since the application that is calling this
.dll is not a .Net application(it's a native Win32 Delphi
application), I am trying to find out how to setup the entity
framework provider for usage in the .dll. And, since it is possible to
register the entity framework provider in code, in EF6, I'm wondering
what would be the required code, when trying to follow the example
from Microsoft, provided in the link of my previous message.

I am using Visual Studio 2015, EF 6.1.3 and targetting .Net 4.6.2.

I did thought of using the EntityConnectionStringBuilder, but it is
looking for the metadata files(.csdl, .ssdl, .msl), which don't exist
in my case. Unless, there is a way to tell it to ignore the metadata
files, when using the EntityConnectionString, because at least here I
would be able to specify the provider.

If more information is needed, just let me know.

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Jiří Činčura]

Well, you're not saying anything specific about the exception (at least
which provider - EF or ADO.NET?) nor how's the assembly loaded (because
you can as well use the config file, depending on how it's loaded).

Let's guess that it's a ADO.NET provider, then you're probably missing
the DbProviderFactory piece
(https://github.com/cincuranet/EF6_Firebird/blob/master/CodeFirst/App.config#L12).
With that, I would go the easiest way and pass directly FbConnection to
DbContext's ctor. 

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

On Thu, Feb 9, 2017, at 21:32, Daniel Rail wrote:
> Hi,
> 
>   I'm trying to use the Firebird ADO.Net with Entity Framework 6.
> 
>   I'm able to create a code first model from an existing database.
>   But, when trying to establish a connection, it is telling me that a
>   provider is not registered. My scenario is that the connection is
>   done in a DLL, not an EXE, and the main application's EXE that is
>   calling this .Net assembly DLL is a Win32/Delphi application. I know
>   that normally the provider information would be in the application's
>   config file, but in this case the config file is not copied with the
>   assembly DLL.
> 
>   I was reading on how to register the provider in code (
>   https://msdn.microsoft.com/en-us/library/jj680699(v=vs.113).aspx ),
>   but I'm unsure what to put for the SetExecutionStrategy line in the
>   example.
> 
>   Any help would be appreciated.
> 
> -- 
> Best regards,
>  Daniel Rail
>  Senior System Engineer
>  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
> Firebird-net-provider@lists.sourceforge.net
> 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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 6

[Paul Dryden]

I have have had problems using Windows Entity Data Framework. In some 
cases, I can't open an edmx file in Visual Studio (that I had compiled 
from scanning a database perhaps a year earlier, always receiving 
"Provider Not Found." Very frustrating.


I am now considering switching to MySql, even though I would prefer to 
stay with Firebird.



On 2/9/2017 1:32 PM, Daniel Rail wrote:

Hi,

   I'm trying to use the Firebird ADO.Net with Entity Framework 6.

   I'm able to create a code first model from an existing database.
   But, when trying to establish a connection, it is telling me that a
   provider is not registered. My scenario is that the connection is
   done in a DLL, not an EXE, and the main application's EXE that is
   calling this .Net assembly DLL is a Win32/Delphi application. I know
   that normally the provider information would be in the application's
   config file, but in this case the config file is not copied with the
   assembly DLL.

   I was reading on how to register the provider in code (
   https://msdn.microsoft.com/en-us/library/jj680699(v=vs.113).aspx ),
   but I'm unsure what to put for the SetExecutionStrategy line in the
   example.

   Any help would be appreciated.



--
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework 6

[Daniel Rail]

Hi,

  I'm trying to use the Firebird ADO.Net with Entity Framework 6.

  I'm able to create a code first model from an existing database.
  But, when trying to establish a connection, it is telling me that a
  provider is not registered. My scenario is that the connection is
  done in a DLL, not an EXE, and the main application's EXE that is
  calling this .Net assembly DLL is a Win32/Delphi application. I know
  that normally the provider information would be in the application's
  config file, but in this case the config file is not copied with the
  assembly DLL.

  I was reading on how to register the provider in code (
  https://msdn.microsoft.com/en-us/library/jj680699(v=vs.113).aspx ),
  but I'm unsure what to put for the SetExecutionStrategy line in the
  example.

  Any help would be appreciated.

-- 
Best regards,
 Daniel Rail
 Senior System Engineer
 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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Jiří Činčura]

OK, looks like this is not a problem, so I created DNET-732 for it and
it will eventually happen.

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

On Tue, Jan 10, 2017, at 18:27, Jiří Činčura wrote:
> > Too much effort?
> 
> Correct. 
> 
> Currently MS's story is only EF6 and EFCore so I don't want to waste too
> much of my free time on anything extra. Considering the move to EF6 from
> EF5 is not that difficult I don't see much reasons to keep it (and there
> has been plenty of time to do it). And of course there are always
> previous versions available.
> 
> -- 
> Mgr. Jiří Činčura
> Independent IT Specialist
> 
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> 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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Jiří Činčura]

> Too much effort?

Correct. 

Currently MS's story is only EF6 and EFCore so I don't want to waste too
much of my free time on anything extra. Considering the move to EF6 from
EF5 is not that difficult I don't see much reasons to keep it (and there
has been plenty of time to do it). And of course there are always
previous versions available.

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Геннадий Забула]

Too much effort?


On 10 January 2017 at 19:21, Jiří Činčura  wrote:
>> Have you considered supporting two separate libraries? In two separate
>> branches/nuget and so on?
>
> Not really.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Jiří Činčura]

> Have you considered supporting two separate libraries? In two separate
> branches/nuget and so on?

Not really. 

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

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5

[Геннадий Забула]

Have you considered supporting two separate libraries? In two separate
branches/nuget and so on?

On 9 January 2017 at 16:55, Jiří Činčura  wrote:
> Hi *,
>
> anybody still using EF5 (or even EF4)? Or is everybody on EF6...
> Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing
> the old EF support and keeping only EF6 (EntityFramework.Firebird).
>
> --
> 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
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework 5

[Jiří Činčura]

Hi *,

anybody still using EF5 (or even EF4)? Or is everybody on EF6...
Thinking about slimming the FirebirdSql.Data.FirebirdClient and removing
the old EF support and keeping only EF6 (EntityFramework.Firebird).

-- 
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework: Best practices to workin a multiuser environment

[Геннадий Забула]

Keeping long-lived context instance it is something like having in-memory 
database. Yes you have all entities but it cost you memory. Still some apps ok 
with this, if user session works only with small subset of database entities. 

Sent from my Windows 10 phone

From: Jiří Činčura
Sent: Saturday, March 26, 2016 12:52 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework: Best practices to workin 
a multiuser environment

> Indeed. It's EF poor design, that they try to rework in EF core.
> Still there are plenty of workarounds for this. For example attaching
> entities only by ids.

Attaching by ID? It's still attaching...

> DbContext is supposed to be used in request-response scenario (web
> sites, for example), where context object is short-living object.

Quite opposite. Short-living context is recommended in request-response
scenarios. If you can keep the instance - like WPF, WinForms, etc. - the
benefit of having the context to track what you're doing is great help.

The context class itself was not designed to be used in any scenario in
particular. It should work and works in all range of options .NET
ecosystem offers. In fact, even just the disconnected scenario has at
least like 3 options to tackle it.

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

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471=/4140___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

[Jiří Činčura]

> Indeed. It's EF poor design, that they try to rework in EF core.
> Still there are plenty of workarounds for this. For example attaching
> entities only by ids.

Attaching by ID? It's still attaching...

> DbContext is supposed to be used in request-response scenario (web
> sites, for example), where context object is short-living object.

Quite opposite. Short-living context is recommended in request-response
scenarios. If you can keep the instance - like WPF, WinForms, etc. - the
benefit of having the context to track what you're doing is great help.

The context class itself was not designed to be used in any scenario in
particular. It should work and works in all range of options .NET
ecosystem offers. In fact, even just the disconnected scenario has at
least like 3 options to tackle it.

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

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

[Геннадий Забула]

> That doesn't make any sense. If I dispose context after query then I
can't update the entities without attaching them to new context. Waste
of resources.

Indeed. It's EF poor design, that they try to rework in EF core.
Still there are plenty of workarounds for this. For example attaching
entities only by ids.

DbContext is supposed to be used in request-response scenario (web
sites, for example), where context object is short-living object.


On 26 March 2016 at 11:20, Jiří Činčura  wrote:
>> > d) Do I need to dispose the the context on closing the window?
>> Not only on that. you should create and dispose context for every
>> action you do with a database: insert, delete, update, query etc.
>
> That doesn't make any sense. If I dispose context after query then I
> can't update the entities without attaching them to new context. Waste
> of resources.
>
>> > 3.   As long the user does not explicit reload the data I am working 
>> > in a connected mode
>> You don't have to be always connected for any reason.
>
> True. But for fat client type applications this is then way easier than
> disconnected scenarios.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

[Jiří Činčura]

> > d) Do I need to dispose the the context on closing the window?
> Not only on that. you should create and dispose context for every
> action you do with a database: insert, delete, update, query etc.

That doesn't make any sense. If I dispose context after query then I
can't update the entities without attaching them to new context. Waste
of resources.

> > 3.   As long the user does not explicit reload the data I am working in 
> > a connected mode
> You don't have to be always connected for any reason.

True. But for fat client type applications this is then way easier than
disconnected scenarios.

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

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

[Геннадий Забула]

EF context is implementation of unit-of-work pattern, it is not
repository pattern.

> d) Do I need to dispose the the context on closing the window?
Not only on that. you should create and dispose context for every
action you do with a database: insert, delete, update, query etc.

> 3.   As long the user does not explicit reload the data I am working in a 
> connected mode
You don't have to be always connected for any reason.

On 25 March 2016 at 09:18, Jiří Činčura  wrote:
>> a) Is the method described above considered as good practice?
>
> From what you've written, yes.
>
>> b) Basically it is a connected Context until the user refreshes the data.
>> In
>> this case the context is recreated.
>
> No problem with that.
>
>> c) In order to manage multiuser environment, do I need to work generally
>> with disconnected entities?
>
> No, you don't have to.
>
>> d) Do I need to dispose the the context on closing the window?
>
> Yes, you should.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> --
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

[Jiří Činčura]

> a) Is the method described above considered as good practice?

From what you've written, yes.

> b) Basically it is a connected Context until the user refreshes the data.
> In
> this case the context is recreated.

No problem with that.

> c) In order to manage multiuser environment, do I need to work generally
> with disconnected entities?

No, you don't have to.
 
> d) Do I need to dispose the the context on closing the window?

Yes, you should.

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

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework: Best practices to work in a multiuser environment

[Nikolaus Kern]

Hello all,

 

I am using EF 6.0 with Firebird 4.10 and have same questions about best
practices. It is an WPF/MVVM application that runs in a multiuser
environment.

 

1.   There is a static class to create the connection string

AppGlobals
 .EFMetadata
  =
"res://*/LPP.csdl|res://*/LPP.ssdl|res://*/LPP.msl";
AppGlobals
 .CreateConnectionString
 ();

 

2.   I am using long living efcontext as protected variable in the
ViewModel to read the data

protected lehnerEntities
  _ctx
 ;

 

3.   As long the user does not explicit reload the data I am working in
a connected mode

 

4.   Inserts, updates and deletes use the same context

LPP_LOGISTIK_EISENBIEGEN
  entity = new
LPP_LOGISTIK_EISENBIEGEN
 ();
this._ctx
 .LPP_LOGISTIK_EISENBIEGEN
 .Add
 (entity);
this._ctx
 .SaveChanges

();

 

5. When the user wants to refresh (F5) I instanciate the context again and
use it as before

this._ctx
  = new lehnerEntities
 (AppGlobals
 .efSB
 .ConnectionString
 );
this._auftraege
  = this._ctx
 .GetOffeneEisenAuftraege
 ();

 

Questions:

a) Is the method described above considered as good practice?

b) Basically it is a connected Context until the user refreshes the data. In
this case the context is recreated.

c) In order to manage multiuser environment, do I need to work generally
with disconnected entities?

d) Do I need to dispose the the context on closing the window?

 

Thanks

 

Niko

--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework not importing stored procedures

[didmiller]

Entity Framework (EF) is an object-relational mapper that enables .NET
developers to work with relational data using domain-specific objects. It
eliminates the need for most of the data-access code that developers usually
need to write. 
with the help of this, i think it can import stored procedure.


generate barcode in ssrs
http://www.keepdynamic.com/barcoding/barcode-reporting-service.shtml  



--
View this message in context: 
http://firebird.1100200.n4.nabble.com/Entity-Framework-not-importing-stored-procedures-tp4632625p4636721.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck#174;
Code Sight#153; - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Stored Procedures

[Jiri Cincura]

On Tue, Jun 10, 2014 at 2:31 AM, Piers Smith
piers.sm...@communicaresystems.com.au wrote:
 I looked at Function Imports in the model browser. If I Add Function Import 
 there is nothing in the 'Stored Procedure / Function Name' dropdown to 
 select. Is this what you mean?

Yep. Looks like your procedure is not imported into SSDL.

-- 
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com

--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing  Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Stored Procedures

[Piers Smith]

Would you have any idea why edmgen.exe would import a stored procedure okay but 
not the entity model designer?

-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Tuesday, 10 June 2014 2:17 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework Stored Procedures

On Tue, Jun 10, 2014 at 2:31 AM, Piers Smith 
piers.sm...@communicaresystems.com.au wrote:
 I looked at Function Imports in the model browser. If I Add Function Import 
 there is nothing in the 'Stored Procedure / Function Name' dropdown to 
 select. Is this what you mean?

Yep. Looks like your procedure is not imported into SSDL.

--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com

--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions Find 
What Matters Most in Your Big Data with HPCC Systems Open Source. Fast. 
Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing  Easy Data Exploration 
http://p.sf.net/sfu/hpccsystems ___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing  Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Stored Procedures

[Jiri Cincura]

On Tue, Jun 10, 2014 at 9:16 AM, Piers Smith
piers.sm...@communicaresystems.com.au wrote:
 Would you have any idea why edmgen.exe would import a stored procedure okay 
 but not the entity model designer?

If you're using same settings, then not.

-- 
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com

--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing  Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Stored Procedures

[Jiri Cincura]

Have you created Function Import after updating the model?


-- 
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com

--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing  Easy Data Exploration
http://www.hpccsystems.com
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Stored Procedures

[Piers Smith]

I looked at Function Imports in the model browser. If I Add Function Import 
there is nothing in the 'Stored Procedure / Function Name' dropdown to select. 
Is this what you mean?

Thanks,
Piers

-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Tuesday, 10 June 2014 12:37 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework Stored Procedures

Have you created Function Import after updating the model?


--
Jiri {x2} Cincura
http://blog.cincura.net/ | http://www.ID3renamer.com

--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions Find 
What Matters Most in Your Big Data with HPCC Systems Open Source. Fast. 
Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing  Easy Data Exploration 
http://www.hpccsystems.com ___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

--
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing  Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework Stored Procedures

[Piers Smith]

Hi,

I am having problems importing Firebird stored procedures into the entity 
framework via the VS model designer (Update Model from Database). The stored 
procedure is selectable but it does not get generated in the model xml anywhere 
(i.e. not in ssdl, csdl, msl). There are no errors given.

I have tried running edmgen on the same model and this adds the procedures into 
the ssdl file as functions just fine. I have analysed the queries fired by the 
model designer and they seem to return data fine (i.e. these are the queries in 
the Client\Entity\StoreSchemaDefinition.ssdl file in the 
FirebirdSql.Data.FirebirdClient source)

I don't understand what the model designer could be doing that is different 
from edmgen. I thought it would run edmgen in the background but obviously it's 
doing more than this.

I am using Firebird v2.5, Provider v4.1.5.0, .Net v4, VS 2013. I have tried 
importing stored procedures from a databases that are dialect 1 and 3.

Can anybody help with this?

Thanks,

Piers Smith
Senior Developer
Communicare eHealth Solutions Pty Ltd
Tel: 08 6212 6900  Fax: 08 6212 6980
piers.sm...@communicaresystems.com.aumailto:piers.sm...@communicaresystems.com.au
www.communicaresystems.com.auhttp://www.communicaresystems.com.au/

Communicare eHealth Solutions advises that this email account is not 
continuously monitored.  Please forward any Helpdesk enquiries to our monitored 
address 
helpd...@communicaresystems.com.aumailto:helpd...@communicaresystems.com.au 
and note that urgent matters must be advised by telephone.  This message, and 
any attachments, are intended only for the use of the individual or entity to 
which it is addressed and may contain information that is confidential. Any 
unauthorised use, disclosure, reproduction or distribution of this message and 
its attachments is prohibited.  This message is forwarded from an individual 
and does not necessarily represent the views of Communicare eHealth Solutions.  
If you have received this message in error kindly notify the sender and then 
delete the contents.

--
Learn Graph Databases - Download FREE O'Reilly Book
Graph Databases is the definitive new guide to graph databases and their 
applications. Written by three acclaimed leaders in the field, 
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework woes (cannot update model from database)

[Joseph Martinez]

When I try to do Update model from database, I get the following error:

An exception of type
'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException'
occurred while attempting to update from the database. The exception
message is: ''.

I searched this error, and I find a reply from Jiri from about a year ago
that says, DDEX not installed correctly.

I then performed the following steps:
1) Uninstalled the Firebird DDEX provider and the Firebird ADO.Net provider
2) Replaced machine.config in the following folders with the
machine.config.default file:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config
3) Reinstalled ADO.NET provider from NETProvider-4.1.0.0.msi
4) Reinstalled DDEX provider from DDEXProvider-3.0.1.0.msi

However, I still get the same error.  I can open the .EDMX file and view
the entities, but I cannot update the model from the database.

Here is my connection string:
metadata=res://*/TRS11Model.csdl|res://*/TRS11Model.ssdl|res://*/TRS11Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider
connection string='initial catalog=C:\Program Files
(x86)\TRS11\Data\DATA1100.FDB;user id=sysdba;password=masterkey;data
source=localhost'

The database path, userid, and password are all correct.

Does this still sound like an issue with DDEX not being installed correctly?
If so, what else should I do to install it correctly, if my above steps are
not sufficient.

-Joe
--
Learn Graph Databases - Download FREE O'Reilly Book
Graph Databases is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework woes (cannot update modelfrom database)

[Marco Castro - McSoft]

Title: EMail McSoft

	
		

		

		

		
		

		

		

		
		

		

		
		Hi, try with DDEX 3.0.0.
		Best regards,

		Marco Aurelio Castro
		
		Director
		McSoft
		
		

		
		
McSoft
|
A Empresa
|
Nosso sistema

		

		
		

		

		
- Original Message -
From: Joseph Martinez [mailto:j...@jmmsoftware.com]
To: firebird-net-provider@lists.sourceforge.net
Sent: Tue, 15 Apr 2014 11:05:06 -0700
Subject: [Firebird-net-provider] Entity Framework woes (cannot update modelfrom database)
When I try to do "Update model from database", I get the following error:An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''.
I searched this error, and I find a reply from Jiri from about a year ago that says, "DDEX not installed correctly."
I then performed the following steps:1) Uninstalled the Firebird DDEX provider and the Firebird ADO.Net provider
2) Replaced machine.config in the following folders with the machine.config.default file:C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config3) Reinstalled ADO.NET provider fromNETProvider-4.1.0.0.msi
4) Reinstalled DDEX provider fromDDEXProvider-3.0.1.0.msiHowever, I still get the same error. I can open the .EDMX file and view the entities, but I cannot update the model from the database.
Here is my connection string:metadata=res://*/TRS11Model.csdl|res://*/TRS11Model.ssdl|res://*/TRS11Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string='initial catalog="C:\Program Files (x86)\TRS11\Data\DATA1100.FDB";user id=sysdba;password=masterkey;data source=localhost'
The database path, userid, and password are all correct.Does this still sound like an issue with DDEX not being installed correctly?
If so, what else should I do to install it correctly, if my above steps are not sufficient.-Joe

--
Learn Graph Databases - Download FREE O'Reilly Book
Graph Databases is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

[Sibylle Koczian]

Am 28.09.2012 15:01, schrieb Jiri Cincura:
 Use null as initializer.

Thank you, that works. But it means that I can neither create nor change 
my database schema from the application. Only code first with an 
existing database is possible, right?

Not really a problem, but I'd like to know for sure.

Greetings,
Sibylle



--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://ad.doubleclick.net/clk;258768047;13503038;j?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

[Sibylle Koczian]

You have Migrations turned on, but Migrations are/is not supported (currently).How can I turn off Migrations? I dont want them for the moment. I would have thought using a Database Initializer derived from DropCreateDatabaseIfModelChanges would turn them off, because that seems incompatible with updating the database schema from the model. Wrong?Thank you,Sibylle

--
Got visibility?
Most devs has no idea what their production app looks like.
Find out how fast your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219671;13503038;y?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

[Jiri Cincura]

Use null as initializer.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Got visibility?
Most devs has no idea what their production app looks like.
Find out how fast your code is with AppDynamics Lite.
http://ad.doubleclick.net/clk;262219671;13503038;y?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework 5, code first: database created, then crash

[Sibylle Koczian]

Hello,Im trying to create a Firebird database in a small test application using Entity Framework 5 with Code First, but it doesnt work.Versions of everything:Windows 7 Home Premium, 64 bitFirebird 2.5.1Firebird net provider 2.7.7 (installed in the GAC, correct entries in machine.config)Visual Studio 2012 Express for DesktopThe exception I get (line is shown in the code):-  InnerException {Fehler beim Aktualisieren der Eintrge. Weitere Informationen finden Sie in der internen Ausnahme.} System.Exception {System.Data.UpdateException}[Failed to update the entries. More information, see the inner exception]+  InnerException {Dynamic SQL ErrorrnSQL error code = -204rnTable unknownrn__MigrationHistoryrnAt line 1, column 8} System.Exception {FirebirdSql.Data.FirebirdClient.FbException}The database is created, it has two tables: the table described in the model and a second table HistoryRow with the columnsMigrationId Varchar(255) not null, primary keyModel Blob sub_type 0 not nullProductVersion Varchar(32) not nullBoth tables are empty. What is wrong?The app.config:?xml version=1.0 encoding=utf-8?configuration configSections !-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -- section name=entityFramework type=System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 requirePermission=false / /configSections startup supportedRuntime version=v4.0 sku=.NETFramework,Version=v4.5 / /startup entityFramework defaultConnectionFactory type=System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework parameters parameter value=v11.0 / /parameters /defaultConnectionFactory /entityFramework connectionStrings add name=EinkaufContext connectionString=Database=localhost:einkauf;User=sib;Password=immergut;Charset=ISO8859_1 providerName=FirebirdSql.Data.FirebirdClient / /connectionStrings/configurationThe code:namespace CodeFirst_Konsole_1{ class Rubrik { public string RUBID { get; set; } public string RUBNAME { get; set; } }  class EinkaufContext : DbContext { public EinkaufContext() : base(name=EinkaufContext) { }  public DbSetRubrik Rubriken { get; set; } protected override void OnModelCreating(DbModelBuilder modelBuilder) { // base.OnModelCreating(modelBuilder); modelBuilder.EntityRubrik().ToTable(RUBRIK); modelBuilder.EntityRubrik().HasKey(t = t.RUBID); modelBuilder.EntityRubrik().Property(p = p.RUBID) .HasMaxLength(3) .IsFixedLength() .IsUnicode(false); modelBuilder.EntityRubrik().Property(p = p.RUBNAME) .IsRequired() .HasMaxLength(50); } } class EinkaufContextInitializer : DropCreateDatabaseIfModelChangesEinkaufContext { protected override void Seed(EinkaufContext context) { // base.Seed(context); } } class Program { static void Main(string[] args) { Database.SetInitializerEinkaufContext(new EinkaufContextInitializer()); using (var db = new EinkaufContext()) { var newrub = new Rubrik { RUBID = AAC, RUBNAME = - }; db.Rubriken.Add(newrub); // --- Exception here int recordsAffected = db.SaveChanges(); Console.WriteLine({0} Stze in die Datenbank geschrieben., recordsAffected); // Abfragen var allrubs = from p in db.Rubriken select p; foreach (var item in allrubs) { Console.WriteLine(Kennung {0}, Name {1}, item.RUBID, item.RUBNAME); } } Console.WriteLine(Weiter mit jeder Taste ...); Console.ReadKey(); } }}Thank you for help,Sibylle

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://ad.doubleclick.net/clk;258768047;13503038;j?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 5, code first: database created, then crash

[Jiri Cincura]

You have Migrations turned on, but Migrations are/is not supported (currently).

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://ad.doubleclick.net/clk;258768047;13503038;j?
http://info.appdynamics.com/FreeJavaPerformanceDownload.html
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework, Get Column Information gives specified type is not supported

[Newbie]

Entity Framework in Model Browser -Add Function Import for Stored 
procedure when clicking Get Column Information I get exception An 
exception of type System.NotSupportedException occured while 
attempting to get columns information. The exception message is: The 
specified type is not supported by this selector.

and this is for all stored procedures. how to solve it?

--
Virtualization  Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework

[Jiri Cincura]

On Tue, Oct 4, 2011 at 2:54 PM, Muthu Annamalai pearlamer...@gmail.com wrote:
 My doubt is the ObjectSet.ToList is the way it is supposed to work ? when we 
 prepare sql statement manually to retrieve records we only write once and not 
 one for each record. Secondly the problem in using the fast load From 
 statement is it gets back with anonymous type, which is a problem for 
 updating the records back...

Can you clarify that.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework

[Muthu Annamalai]

Let us say the Item Table has 1 records.

The Manual Sql Statement to retrieve records would be
Select * From Item 

In Entity Framework I am using the Objectset.ToList 
It seems like the provider is issuing select statement for each record and
it takes a while (8 min) to retrieve all records
I am also attaching the debug output for your reference.

Please let me know if you need any further info...

-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Tuesday, October 04, 2011 8:56 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework

On Tue, Oct 4, 2011 at 2:54 PM, Muthu Annamalai pearlamer...@gmail.com
wrote:
 My doubt is the ObjectSet.ToList is the way it is supposed to work ? when
we prepare sql statement manually to retrieve records we only write once and
not one for each record. Secondly the problem in using the fast load From
statement is it gets back with anonymous type, which is a problem for
updating the records back...

Can you clarify that.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com


--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
SELECT 
Extent1.ID AS ID, 
Extent1.ITEMID AS ITEMID, 
Extent1.STYLENAME AS STYLENAME, 
Extent1.DESCRIPTION AS DESCRIPTION, 
Extent1.BARCODE AS BARCODE, 
Extent1.LOOKUP AS LOOKUP, 
Extent1.LOCATION AS LOCATION, 
Extent1.VENDORITEMNUMBER AS VENDORITEMNUMBER, 
Extent1.COST AS COST, 
Extent1.PRICE AS PRICE, 
Extent1.STOCK AS STOCK, 
Extent1.CASEPACK AS CASEPACK, 
Extent1.REORDERLEVEL AS REORDERLEVEL, 
Extent1.REORDERQUANTITY AS REORDERQUANTITY, 
Extent1.AUTOREORDER AS AUTOREORDER, 
Extent1.SEASONTYPE AS SEASONTYPE, 
Extent1.DISCOUNTALLOWED AS DISCOUNTALLOWED, 
Extent1.ISACTIVE AS ISACTIVE
FROM ITEMSTYLE AS Extent1

SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID AS CATEGORYID, 
Extent1.VENDORID AS VENDORID, 
Extent1.ITEMNAME AS ITEMNAME, 
Extent1.TAXABLE AS TAXABLE, 
Extent1.ITEMTYPE AS ITEMTYPE
FROM ITEM AS Extent1
WHERE Extent1.ID = @EntityKeyValue1
FirebirdClient: Parameters:
FirebirdClient: Name:EntityKeyValue1Type:Integer Used Value:3
FirebirdClient: Command:
SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID AS CATEGORYID, 
Extent1.VENDORID AS VENDORID, 
Extent1.ITEMNAME AS ITEMNAME, 
Extent1.TAXABLE AS TAXABLE, 
Extent1.ITEMTYPE AS ITEMTYPE
FROM ITEM AS Extent1
WHERE Extent1.ID = @EntityKeyValue1
FirebirdClient: Parameters:
FirebirdClient: Name:EntityKeyValue1Type:Integer Used Value:1
FirebirdClient: Command:
SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID AS CATEGORYID, 
Extent1.VENDORID AS VENDORID, 
Extent1.ITEMNAME AS ITEMNAME, 
Extent1.TAXABLE AS TAXABLE, 
Extent1.ITEMTYPE AS ITEMTYPE
FROM ITEM AS Extent1
WHERE Extent1.ID = @EntityKeyValue1
FirebirdClient: Parameters:
FirebirdClient: Name:EntityKeyValue1Type:Integer Used Value:5
FirebirdClient: Command:
SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID AS CATEGORYID, 
Extent1.VENDORID AS VENDORID, 
Extent1.ITEMNAME AS ITEMNAME, 
Extent1.TAXABLE AS TAXABLE, 
Extent1.ITEMTYPE AS ITEMTYPE
FROM ITEM AS Extent1
WHERE Extent1.ID = @EntityKeyValue1
FirebirdClient: Parameters:
FirebirdClient: Name:EntityKeyValue1Type:Integer Used Value:5068
FirebirdClient: Command:
SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID AS CATEGORYID, 
Extent1.VENDORID AS VENDORID, 
Extent1.ITEMNAME AS ITEMNAME, 
Extent1.TAXABLE AS TAXABLE, 
Extent1.ITEMTYPE AS ITEMTYPE
FROM ITEM AS Extent1
WHERE Extent1.ID = @EntityKeyValue1
FirebirdClient: Parameters:
FirebirdClient: Name:EntityKeyValue1Type:Integer Used Value:9
FirebirdClient: Command:
SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID AS CATEGORYID, 
Extent1.VENDORID AS VENDORID, 
Extent1.ITEMNAME AS ITEMNAME, 
Extent1.TAXABLE AS TAXABLE, 
Extent1.ITEMTYPE AS ITEMTYPE
FROM ITEM AS Extent1
WHERE Extent1.ID = @EntityKeyValue1
FirebirdClient: Parameters:
FirebirdClient: Name:EntityKeyValue1Type:Integer Used Value:8
FirebirdClient: Command:
SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID AS CATEGORYID, 
Extent1.VENDORID AS VENDORID, 
Extent1.ITEMNAME AS ITEMNAME, 
Extent1.TAXABLE AS TAXABLE, 
Extent1.ITEMTYPE AS ITEMTYPE
FROM ITEM AS Extent1
WHERE Extent1.ID = @EntityKeyValue1
FirebirdClient: Parameters:
FirebirdClient: Name:EntityKeyValue1Type:Integer Used Value:10
FirebirdClient: Command:
SELECT 
Extent1.ID AS ID, 
Extent1.CATEGORYID

Re: [Firebird-net-provider] Entity Framework

[Jiri Cincura]

On Tue, Oct 4, 2011 at 5:44 PM, Muthu Annamalai
muthuannama...@sbcglobal.net wrote:
 It seems like the provider is issuing select statement for each record and

No it's not. It's doing it in one query. BTW provider isn't issuing
any query. It's just sending commands requested by EF:

 it takes a while (8 min) to retrieve all records

You're probably facing lazy loading.

 I am also attaching the debug output for your reference.

 Please let me know if you need any further info...



-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework

[Muthu Annamalai]

You are right. I thought lazy loading will be useful and scared to remove to
it. 
Thanks!

-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Tuesday, October 04, 2011 11:17 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework

On Tue, Oct 4, 2011 at 5:44 PM, Muthu Annamalai
muthuannama...@sbcglobal.net wrote:
 It seems like the provider is issuing select statement for each record and

No it's not. It's doing it in one query. BTW provider isn't issuing
any query. It's just sending commands requested by EF:

 it takes a while (8 min) to retrieve all records

You're probably facing lazy loading.

 I am also attaching the debug output for your reference.

 Please let me know if you need any further info...



-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com


--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework

[Muthu Annamalai]

I am using VS 2010, EF 4.0 with Firebird Dot Net Provider 2.6.5.0

 

When I use ObjectSet.ToList, the provider creates an select statement for
each and every record in the list and it takes forever to load an list of
1 records. 

 

But instead if I use like

From item in Objectset select item.id, item.. It only creates one single
statement and in blink of an eye it loads all the records. I am also
attaching the SQL  statements that is sent by the provider to the database.

  _  

ObjectSet.ToList creates one select statement for each record as follows and
takes forever

 

SELECT 

Extent1.ID AS ID, 

Extent1.CATEGORYID AS CATEGORYID, 

Extent1.VENDORID AS VENDORID, 

Extent1.ITEMNAME AS ITEMNAME, 

Extent1.TAXABLE AS TAXABLE, 

Extent1.ITEMTYPE AS ITEMTYPE

FROM ITEM AS Extent1

WHERE Extent1.ID = @EntityKeyValue1

FirebirdClient: Parameters:

FirebirdClient: Name:EntityKeyValue1   Type:Integer
Used Value:5

FirebirdClient: Command:

SELECT 

Extent1.ID AS ID, 

Extent1.CATEGORYID AS CATEGORYID, 

Extent1.VENDORID AS VENDORID, 

Extent1.ITEMNAME AS ITEMNAME, 

Extent1.TAXABLE AS TAXABLE, 

Extent1.ITEMTYPE AS ITEMTYPE

FROM ITEM AS Extent1

WHERE Extent1.ID = @EntityKeyValue1

FirebirdClient: Parameters:

FirebirdClient: Name:EntityKeyValue1   Type:Integer
Used Value:6

FirebirdClient: Command:

SELECT 

Extent1.ID AS ID, 

Extent1.CATEGORYID AS CATEGORYID, 

Extent1.VENDORID AS VENDORID, 

Extent1.ITEMNAME AS ITEMNAME, 

Extent1.TAXABLE AS TAXABLE, 

Extent1.ITEMTYPE AS ITEMTYPE

FROM ITEM AS Extent1

WHERE Extent1.ID = @EntityKeyValue1

FirebirdClient: Parameters:

FirebirdClient: Name:EntityKeyValue1   Type:Integer
Used Value:9

FirebirdClient: Command:

SELECT 

Extent1.ID AS ID, 

Extent1.CATEGORYID AS CATEGORYID, 

Extent1.VENDORID AS VENDORID, 

Extent1.ITEMNAME AS ITEMNAME, 

Extent1.TAXABLE AS TAXABLE, 

Extent1.ITEMTYPE AS ITEMTYPE

FROM ITEM AS Extent1

WHERE Extent1.ID = @EntityKeyValue1

FirebirdClient: Parameters:

FirebirdClient: Name:EntityKeyValue1   Type:Integer
Used Value:8

FirebirdClient: Command:

 

And goes on and on...

  _  

 

From item in ObjectSet creates just one sql statement as follows and loads
instantly 

 

SELECT 

Extent1.VENDORNAME AS VENDORNAME

FROM VENDOR AS Extent1

ORDER BY Extent1.VENDORNAME ASC

FirebirdClient: Parameters:

FirebirdClient: Command:

SELECT 

Extent1.DEPARTMENTNAME AS DEPARTMENTNAME

FROM DEPARTMENT AS Extent1

ORDER BY Extent1.DEPARTMENTNAME ASC

FirebirdClient: Parameters:

FirebirdClient: Command:

SELECT 

Extent1.CATEGORYNAME AS CATEGORYNAME

FROM CATEGORY AS Extent1

ORDER BY Extent1.CATEGORYNAME ASC

FirebirdClient: Parameters:

FirebirdClient: Command:

SELECT 

Extent1.ID AS ID, 

Extent3.VENDORNAME AS VENDORNAME, 

Extent6.DEPARTMENTNAME AS DEPARTMENTNAME, 

Extent7.CATEGORYNAME AS CATEGORYNAME, 

Extent4.ITEMNAME AS ITEMNAME, 

Extent1.STYLENAME AS STYLENAME, 

Extent1.BARCODE AS BARCODE, 

Extent1.LOOKUP AS LOOKUP, 

Extent1.LOCATION AS LOCATION, 

Extent1.VENDORITEMNUMBER AS VENDORITEMNUMBER, 

Extent1.COST AS COST, 

Extent1.PRICE AS PRICE, 

Extent1.STOCK AS STOCK, 

Extent1.CASEPACK AS CASEPACK, 

Extent1.REORDERLEVEL AS REORDERLEVEL, 

Extent1.REORDERQUANTITY AS REORDERQUANTITY, 

Extent1.AUTOREORDER AS AUTOREORDER, 

Extent1.SEASONTYPE AS SEASONTYPE, 

Extent1.DISCOUNTALLOWED AS DISCOUNTALLOWED, 

Extent4.TAXABLE AS TAXABLE, 

Extent1.ISACTIVE AS ISACTIVE

FROM   ITEMSTYLE AS Extent1

INNER JOIN ITEM AS Extent2 ON Extent1.ITEMID = Extent2.ID

LEFT OUTER JOIN VENDOR AS Extent3 ON Extent2.VENDORID =
Extent3.ID

LEFT OUTER JOIN ITEM AS Extent4 ON Extent1.ITEMID = Extent4.ID

LEFT OUTER JOIN CATEGORY AS Extent5 ON Extent4.CATEGORYID =
Extent5.ID

LEFT OUTER JOIN DEPARTMENT AS Extent6 ON Extent5.DEPARTMENTID =
Extent6.ID

LEFT OUTER JOIN CATEGORY AS Extent7 ON Extent4.CATEGORYID =
Extent7.ID

FirebirdClient: Parameters:

The thread 'No Name' (0x176c) has exited with code 0 (0x0).

The thread 'No Name' (0x15e8) has exited with code 0 (0x0).

The thread 'No Name' (0x1610) has exited with code 0 (0x0).

The thread 'No Name' (0x1568) has exited with code 0 (0x0).

The program '[5048] PearlPOS.vshost.exe: Managed (v4.0.30319)' has exited
with code 0 (0x0).

  _  

 

Any help is highly appreciated

Thanks!

Muthu Annamalai

--
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Default Value

[Jiri Cincura]

On Mon, Jan 24, 2011 at 20:13, Muthu Annamalai
muthuannama...@sbcglobal.net wrote:
 In VS 2010 I started using EF4 with firebird 2.5.0 and fb provider 2.6.0.0.
 AutoIncrement, Bool everything is working out well. Is there a way we can
 get the default value from database as well.
 I really appreciate your time and effort for providing an efficient
 provider.
 Thanks!
 Muthu Annamalai

Check DNET-336.

Problem is, that the default value can be something like
current_timestamp or some expression etc. and hence it's not trivial
to parse the value.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework Default Value

[Muthu Annamalai]

In VS 2010 I started using EF4 with firebird 2.5.0 and fb provider 2.6.0.0. 
AutoIncrement, Bool everything is working out well. Is there a way we can
get the default value from database as well.
I really appreciate your time and effort for providing an efficient
provider.
Thanks!
Muthu Annamalai


--
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework autoincrement problem

[Roberto Carlos | Unimed]

You can change your triggers to:



CREATE TRIGGER STUDENTS_BI FOR STUDENTS
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (COALESCE(new.id, 0)  1) then
new.id = gen_id(gen_students_id, 1);
end



--
From: Stan sphinx...@yahoo.com
Sent: Thursday, December 30, 2010 5:24 AM
To: firebird-net-provider@lists.sourceforge.net
Subject: Re: [Firebird-net-provider] Entity Framework autoincrement problem


 It seems that the firebird server performs
 insert into students(id, firstname) values(0, 'asdf')
 instead of
 insert into students(firstname) values('asdf')
 select id ...
 -- 
 View this message in context: 
 http://firebird.1100200.n4.nabble.com/Entity-Framework-autoincrement-problem-tp3167085p3167993.html
 Sent from the firebird-net-provider mailing list archive at Nabble.com.

 --
 Learn how Oracle Real Application Clusters (RAC) One Node allows customers
 to consolidate database storage, standardize their database environment, 
 and,
 should the need arise, upgrade to a full multi-node Oracle RAC database
 without downtime or disruption
 http://p.sf.net/sfu/oracle-sfdevnl
 ___
 Firebird-net-provider mailing list
 Firebird-net-provider@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework autoincrement problem

[Stan]

Yes I can do that thing but I want to return a currently generated id
in order to use it in my entity class, and it is still 0.

I mean the schema insert - select seems not working in my code using
firebird database.
In case with mssql it returns the proper value,
so maybe I have to do something else to use a firebird database?
-- 
View this message in context: 
http://firebird.1100200.n4.nabble.com/Entity-Framework-autoincrement-problem-tp3167085p3168244.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework autoincrement problem

[Jiri Cincura]

On Thu, Dec 30, 2010 at 07:45, Stan sphinx...@yahoo.com wrote:
 And the trigger fires in case with an sql query, but doesn't using Entity
 Framework in Visual Studio.
 Maybe I have to make this autoincrement implementation in some different
 way?
 Does that sql code look ok?

Did you marked the field as Identity in model? Or did you used
#PK_GEN# comment
(http://blog.cincura.net/230841-generated-primary-key-in-entity-framework-model-from-firebird/)?

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework autoincrement problem

[Stan]

I read that article before but the thing that the property Identity is
disappering
makes me think that I have another problem (I didn't have it disappeared).

Now I noticed that the comment in the column on the database side causes
the StoreGeneratedPattern property in the SSDL content section of the .edmx
file to appear.
So that was the problem, now it works fine.

Thank you for your answers.
-- 
View this message in context: 
http://firebird.1100200.n4.nabble.com/Entity-Framework-autoincrement-problem-tp3167085p3168347.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework autoincrement problem

[Stan]

Hi,

I have a problem with Identity store generation pattern.
It seems doesn't work or maybe I'm doing something wrong.

I've made the table students and the fields id and name as the key
field as well as
the generator. The simple insert sql statement - insert into students(name)
values('some_name')
works fine.
Using Visual Studio I created Entity Model and have this code:

using (var context = new fb1Container())
{
var st = new STUDENT { FIRSTNAME = some_name };
context.STUDENTS.AddObject(st);
context.SaveChanges();
}

After context.SaveChanges() has performed I'm getting the id = 0 in my
database table
and the generator doesn't change its value. The second call raise an
exception, because
I'm trying to insert id as 0 and it is already stored in the database.

Do you have any suggestion what's wrong here?
-- 
View this message in context: 
http://firebird.1100200.n4.nabble.com/Entity-Framework-autoincrement-problem-tp3167085p3167085.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework autoincrement problem

[Jiri Cincura]

On Wed, Dec 29, 2010 at 13:59, Stan sphinx...@yahoo.com wrote:
 After context.SaveChanges() has performed I'm getting the id = 0 in my
 database table
 and the generator doesn't change its value. The second call raise an
 exception, because
 I'm trying to insert id as 0 and it is already stored in the database.

 Do you have any suggestion what's wrong here?

Did the trigger fire?

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework autoincrement problem

[Stan]

That's what I have in the database:

CREATE GENERATOR GEN_STUDENTS_ID;

CREATE TABLE STUDENTS (
ID INTEGER NOT NULL,
FIRSTNAME  VARCHAR(50)
);

ALTER TABLE STUDENTS ADD CONSTRAINT PK_STUDENTS PRIMARY KEY (ID);

CREATE TRIGGER STUDENTS_BI FOR STUDENTS
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (new.id is null) then
new.id = gen_id(gen_students_id,1);
end

And the trigger fires in case with an sql query, but doesn't using Entity
Framework in Visual Studio.
Maybe I have to make this autoincrement implementation in some different
way?
Does that sql code look ok?
-- 
View this message in context: 
http://firebird.1100200.n4.nabble.com/Entity-Framework-autoincrement-problem-tp3167085p3167974.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework autoincrement problem

[Stan]

It seems that the firebird server performs
insert into students(id, firstname) values(0, 'asdf')
instead of
insert into students(firstname) values('asdf')
select id ...
-- 
View this message in context: 
http://firebird.1100200.n4.nabble.com/Entity-Framework-autoincrement-problem-tp3167085p3167993.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.

--
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity framework problems

[Bengt Skogvall]

Thanks!

It would be good if a note on the firebirdsql website would state that,
perhaps where the net provider can be downloaded.

Best regards,

Bengt

Am 04.12.2010 14:11, schrieb Jiri Cincura:
 http://j.mp/etvhlo


--
This SF Dev2Dev email is sponsored by:

WikiLeaks The End of the Free Internet
http://p.sf.net/sfu/therealnews-com
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity framework problems

[Jiri Cincura]

http://j.mp/etvhlo

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
What happens now with your Lotus Notes apps - do you make another costly 
upgrade, or settle for being marooned without product support? Time to move
off Lotus Notes and onto the cloud with Force.com, apps are easier to build,
use, and manage than apps on traditional platforms. Sign up for the Lotus 
Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity framework problems

[Bengt Skogvall]

I am able to connect the new 2.6.0 Net provider to my db and I can see
all the tables in vs2010 explorer.

Now I try to create an entity framework model from the db. Well, a model
is generated, but all fields are marked as being part of the primary
key, which they are not.

Also, all the foreign keys are not visible.

Am I doing something wrong, or is this the expected way to use entity
framework with Firebird 2.1?

Is there a workaround?

Best regards,
Bengt

--
Increase Visibility of Your 3D Game App  Earn a Chance To Win $500!
Tap into the largest installed PC base  get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework and Linq

[John R. Tomaselli]

Hi,

I just encountered the same issues reported in Vol 48, Issue #5 Topic #5
and (48,6,2) using VS2010, DDEX provider 2.0.5, Entity Framework 4 with
Firebird 2.5.2. I re-generated the emdx file, checked the csdl secttion
and have encountered the exact same error using Linqpad to test. I'm not
sure if issue has been dropped as it doesn't appear in the list and I'm
not sure of the protocols to follow-up unresolved issues.

Thanks,

John

 

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework 4.0 delete statements

[Jiri Cincura]

How is the cascading set?


-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework 4.0 delete statements

[Alexander Muylaert]

Hi Jiri

I have a question for you.  It looks like the generation of the delete 
statement has changed inside ef4.0.  (I'm not sure if it has changed, but 
I'm sure it is not the behavior i'm expecting)

When one is deleting a record with foreign navigation properties, it 
includes these properties inside the where clause of the deletestatement.

Table2 is a detail record of master Table.

delete from NEW_TABLE2
where ((ID = @p0) and (NEW_TABLE_ID = @p1))   the part  behind the and 
is weird to me.  Btw, concurrencymode is set to none on all fields.

Alexander

 


--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework Foreign Key Relation

[Muthu Annamalai]

I have the following installed

 

VS 2010

Dot Net Framework 4.0

Firebird 2.5.0

Dot Net Provider 2.5.1

 

I have following issues,

 

I have a Customer Table which has foreign key relationship with Person and
Address Table. I create PK values for these tables using triggers. When I
insert a record in customer table using Entity Framework all the PK's were
inserted as 0. I searched online and changed all the PK's as Identity
column, still no luck. See the sample row.

 

IDADDRESSID PERSONID   ROLEID
BIRTHDATE HIREDATE

0  0  0
0  1/1/0001  1/1/0001  

 

How would you avoid zero value for all PK's. Any code snippet is much
appreciated.

 

Thanks!

 

Muthu Annamalai

--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework Foreign Key Relation

[Muthu Annamalai]

I have the following installed

 

VS 2010

Dot Net Framework 4.0

Firebird 2.5.0

Dot Net Provider 2.5.1

 

I have following issues,

 

I have a Customer Table which has foreign key relationship with Person and
Address Table. I create PK values for these tables using triggers. When I
insert a record in customer table using Entity Framework all the PK's were
inserted as 0. I searched online and changed all the PK's as Identity
column, still no luck. See the sample row.

 

IDADDRESSID PERSONID   ROLEID
BIRTHDATE HIREDATE

0  0  0
0  1/1/0001  1/1/0001  

 

How would you avoid zero value for all PK's. Any code snippet is much
appreciated.

 

Thanks!

 

Muthu Annamalai

--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

[Jiri Cincura]

On Wed, Jan 20, 2010 at 18:51, Muthu Annamalai pearlamer...@hotmail.com wrote:
 How would you avoid zero value for all PK’s.

Didn't you just said that you're generating PKs with trigger? If so,
the trigger should populate the proper value.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

[Jiri Cincura]

On Wed, Jan 20, 2010 at 18:51, Muthu Annamalai pearlamer...@hotmail.com wrote:
 a record in customer table using Entity Framework all the PK’s were inserted
 as 0. I searched online and changed all the PK’s as Identity column, still
 no luck. See the sample row.

Reading this looks like you're talking about FK. Anyway if you have
proper associations created in your model and code, the EF will do the
FKs for you.

I.e.
Person p = new Person();
p.Name = ...;
p.Role = some role/new role object;
context.Persons.Add(p);
context.SaveChanges();

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

[Muthu Annamalai]

Yes. The trigger will make the insert value, only if the PK value is null.
But from entity framework, all my PK's are integer and sending zero value to
database.

-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Wednesday, January 20, 2010 5:04 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

On Wed, Jan 20, 2010 at 18:51, Muthu Annamalai pearlamer...@hotmail.com
wrote:
 How would you avoid zero value for all PK's.

Didn't you just said that you're generating PKs with trigger? If so,
the trigger should populate the proper value.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com


--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for
Conference
attendees to learn about information security's most important issues
through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 4791 (20100120) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 4791 (20100120) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 


--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

[Helen Borrie]

At 10:48 AM 21/01/2010, you wrote:
Yes. The trigger will make the insert value, only if the PK value is null.
But from entity framework, all my PK's are integer and sending zero value to
database.

If you want your trigger to work, don't include the PK in the INSERT statement!

Helen


--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

[Muthu Annamalai]

My FK associations are correct in model and code. 

I have bindingsource component on my customer form bind to Customer Entity. 
All the person related fields are mapped to customer. Person and address
related fields are mapped to customer. Address. 

On form load if it an existing customer, I just get that customer as below

  Public ReadOnly Property GetCustomer(ByVal customerId As Integer)
As CUSTOMER 
Get
Dim customer As CUSTOMERS =
db.CUSTOMERS.FirstOrDefault(Function(d) d.ID = customerId)
If Not customer.ADDRESSReference.IsLoaded Then
customer.ADDRESSReference.Load()
If Not customer.PERSONReference.IsLoaded Then
customer.PERSONReference.Load()
Return customer
End Get
  End Property

Or if it is a new customer form then

   Customer = New CUSTOMER
If Customer.ADDRESS Is Nothing Then
Customer.ADDRESS = New ADDRESS
End If
If Customer.PERSON Is Nothing Then
Customer.PERSON = New PERSON
End If

On SaveClose Button Click, If it is a new customer I just call
context.AddToCustomer(customer) or if is an update then I call
context.SaveChanges.


-Original Message-
From: Jiri Cincura [mailto:disk...@cincura.net] 
Sent: Wednesday, January 20, 2010 5:09 PM
To: For customers and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

On Wed, Jan 20, 2010 at 18:51, Muthu Annamalai pearlamer...@hotmail.com
wrote:
 a record in customer table using Entity Framework all the PK's were
inserted
 as 0. I searched online and changed all the PK's as Identity column, still
 no luck. See the sample row.

Reading this looks like you're talking about FK. Anyway if you have
proper associations created in your model and code, the EF will do the
FKs for you.

I.e.
Person p = new Person();
p.Name = ...;
p.Role = some role/new role object;
context.Persons.Add(p);
context.SaveChanges();

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com


--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for
Conference
attendees to learn about information security's most important issues
through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 4791 (20100120) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 4791 (20100120) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 


--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

[Muthu Annamalai]

I don't create the insert statement, it is created by Entity Framework. In
EF I have set the field as below
StoreGeneratedPattern: Identity
EntityKey: True
Name:Id
Nullable:False
Type:Int32

Thanks!
Muthu Annamalai

-Original Message-
From: Helen Borrie [mailto:hele...@tpg.com.au] 
Sent: Wednesday, January 20, 2010 6:08 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Entity Framework Foreign Key Relation

At 10:48 AM 21/01/2010, you wrote:
Yes. The trigger will make the insert value, only if the PK value is null.
But from entity framework, all my PK's are integer and sending zero value
to
database.

If you want your trigger to work, don't include the PK in the INSERT
statement!

Helen



--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for
Conference
attendees to learn about information security's most important issues
through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 4791 (20100120) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 
 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 4791 (20100120) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 


--
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

[Jiri Cincura]

Put it as FR into tracker.
-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

--
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

[Mercea Paul]

  Firebird doesn't have direct support for guids.
 
 Not native in Firebird but maybe with your Provider. By using
 smallint_bool in the ssdl i can use boolean in entities which isn't
 supported too. When i follow your advise from here
 http://blog.vyvojar.cz/jirka/archive/2007/07/08/guid-in-firebird.aspx
 and then generate entity classes from the database the wizard creates
 Entities with Strings. If i try to save something into the Database i
 get an exception which complains about malformed Guids. Can you suggest
 a Datatype that's close to the 128 bit of a Guid that i can use in the
 storage and conceptual model of the edmx?
 
 P.S. the combination of firebird with its small footprint and easy
 installation and the entity framework is really great. beside my small
 guid problem everything works flawless and rock solid.

[PM] I'll vote to support at provider level the guid.
I have the same problems with my web apps and i must work with triggers to
achieve the results i needed.
Guid differ from uuid and is annoying to create workaround to achieve
something that should be easy.

Regards,
Paul



--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Entity Framework, Firebird and Guid

[Jonas Blaausgedacht]

Hello,

when i create a SQL-Server database with an uniqueidentifier typed field as 
primary key the entity wizard creates an entity with a System.Guid typed 
field. Is something like that possible with FirebirdSQL? It would be really 
usefull if i can have System.Guid as a field in an entity.

Jonas B.




  --
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

[Jiri Cincura]

Firebird doesn't have direct support for guids.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

[Jonas Blaausgedacht]

 Firebird doesn't have direct support for guids.

Not native in Firebird but maybe with your Provider. By using smallint_bool 
in the ssdl i can use boolean in entities which isn't supported too. When i 
follow your advise from here 
http://blog.vyvojar.cz/jirka/archive/2007/07/08/guid-in-firebird.aspx and 
then generate entity classes from the database the wizard creates Entities with 
Strings. If i try to save something into the Database i get an exception which 
complains about malformed Guids. Can you suggest a Datatype that's close to the 
128 bit of a Guid that i can use in the storage and conceptual model of the 
edmx?

P.S. the combination of firebird with its small footprint and easy installation 
and the entity framework is really great. beside my small guid problem 
everything works flawless and rock solid.



  

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider