Re: [Firebird-net-provider] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
But the result depends how the columns look like. I have 2 views: CREATE TABLE Parents ( IdINTEGER NOT NULL, Name VARCHAR(100) NOT NULL ); CREATE VIEW ParentsView(Id, Name) AS SELECT * FROM Parents; CREATE TABLE Children ( IdINTEGER NOT NULL, ParentId INTEGER NOT NULL REFERENCES Parents (Id) ON DELETE CASCADE, Name VARCHAR(100) NOT NULL ); CREATE VIEW ChildrenView(Id, ParentId, Name) AS SELECT * FROM Children Do you see any problem with colums of this views? -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
On Mon, Feb 9, 2009 at 10:12, sasha trofim...@gmail.com wrote: Do you see any problem with colums of this views? Neither I or wizard: !--Errors Found During Generation: warning 6013: The table/view 'Firebird.Firebird.ChildrenView' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity you will need to review your schema, add the correct keys and uncomment it. EntityType Name=ChildrenView Property Name=Id Type=int / Property Name=ParentId Type=int / Property Name=Name Type=varchar MaxLength=100 / /EntityType Errors Found During Generation: warning 6013: The table/view 'Firebird.Firebird.ParentsView' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity you will need to review your schema, add the correct keys and uncomment it. EntityType Name=ParentsView Property Name=Id Type=int / Property Name=Name Type=varchar MaxLength=100 / /EntityType-- -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
Views in FB doesn't contain PK, so it's in model, but commented out. You have to uncomment these items and set up PK by hand. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
Views in FB doesn't contain PK, Same in MS SQL so it's in model, but commented out. Why? -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
On Sun, Feb 8, 2009 at 13:17, sasha trofim...@gmail.com wrote: Why? Because everything in EF must have key. It's a crucial part of whole stuff. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
On Mon, Feb 9, 2009 at 01:29, sasha trofim...@gmail.com wrote: Have you seen behavior of Microsoft's provider for MS SQL? It imports all views, marks all fields as key fields generates entities and shows them in the model. Why FB provider simply does not do the same? FirebirdClient does the same. But the result depends how the columns look like. I'm not generating the SSDL nor CSDL. This is done by EF API, so you're weeping on wrong place. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
Hi! I've tested this for working with entities - there are tonns of problems while updating model from database :-( 1) Primary keys not recognized 2) Relations not recognized Than i've tried to import real database and had an empty diagram as a result of importing... I even don't know what to post in bug tracker... This is not beta version. This is pre-pre-pre alpha... -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
On Sat, Feb 7, 2009 at 23:02, sasha trofim...@gmail.com wrote: 1) Primary keys not recognized This isn't problem in provider but in server. 2) Relations not recognized Which is caused by 1), in fact. I even don't know what to post in bug tracker... This is not beta version. This is pre-pre-pre alpha... Sometimes it's enough to search tracker, http://tracker.firebirdsql.org/browse/DNET-203. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-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] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
Checked on 2.5. With keys all fine. But the next problem with views. 1) If i'm importing model from database with views than empty model generated 2) If i'm importing only tables on first step, than all fine. But if i want to import views on second step than nothing happens. Views inporting not working. -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] ANN: Firebird ADO.NET Data Provider 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support]
Hi *, I'm pleased to announce 2.5.0 Beta 1 for .NET 3.5/2.0 [with Entity Framework support] version. It contains several bugfixes as well as brand new Entity Framework support (still beta!). Looking forward to your feedback. Binary as well as sources can be downloaded from http://www.firebirdsql.org/index.php?op=filesid=netprovider. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider