Menu
▾
▴
firebird-net-provider
|
From: Joseph M. <jo...@jm...> - 2013-01-07 20:24:13
|
I previously created an Entity Framework model for a Firebird 2.5 database in Visual Studio 2012 Professional. At the time, I imported the tables only, and not the stored procedures. Now, I need to access some of my stored procedures. I right-click on the .edmx diagram, and selected "Update Model from Database". On the "Add" tab, it correctly shows me the list of stored procedures in the database. I select the ones I want and click "Finish". The output window shows the following: Generated model file: TRS11Model.edmx. Loading metadata from the database took 00:00:00.3591910. Generating the model took 00:00:18.1822456. However, it doesn't seem like it did anything. I can't find anything about the stored procedures in the diagram. Also, if I go to "Update Model...", and go to the "Refresh" tab, the stored procedures section is empty. If I right-click on the diagram and select "Add New->Function Import", the "Stored Procedure / Function Name" combo box is empty. I have been using Firebird for a long time, but I am very new at ADO.NETand Entity Framework, so I think I must be just missing something. What might I be doing wrong? -Joe |
|
From: Jiri C. <di...@ci...> - 2013-01-08 05:32:01
|
Are the SPs in store model?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Jiri C. <di...@ci...> - 2013-01-11 05:44:10
|
On Wed, Jan 9, 2013 at 7:27 PM, Joseph Martinez <jo...@jm...> wrote:
> Do you see anything about it that may cause it to not get imported?
The procedure is not selectable.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: didmiller <jdi...@ho...> - 2014-07-14 04:34:37
|
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. |
|
From: Joseph M. <jo...@jm...> - 2013-01-08 09:30:24
|
Jiri,
I'm not sure what you mean by "in store model".
-Joe
On Mon, Jan 7, 2013 at 9:31 PM, Jiri Cincura <di...@ci...> wrote:
> Are the SPs in store model?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiri C. <di...@ci...> - 2013-01-08 12:11:00
|
SSDL part of EDM.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-08 17:55:22
|
Ok, I found the SSDL file, and there are no references to the stored
procedures in it.
-Joe
On Tue, Jan 8, 2013 at 4:10 AM, Jiri Cincura <di...@ci...> wrote:
> SSDL part of EDM.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiri C. <di...@ci...> - 2013-01-09 07:13:31
|
On Tue, Jan 8, 2013 at 6:55 PM, Joseph Martinez <jo...@jm...> wrote:
> Ok, I found the SSDL file, and there are no references to the stored
> procedures in it.
Then SPs were not imported. Probably there's a message in error/output window.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-09 07:58:13
|
Jiri,
There are no messages in the Error window.
The only thing in the Output window is:
Generated model file: TRS11Model.edmx.
Loading metadata from the database took 00:00:00.5293632.
Generating the model took 00:00:20.3206378.
-Joe
On Tue, Jan 8, 2013 at 11:13 PM, Jiri Cincura <di...@ci...> wrote:
> On Tue, Jan 8, 2013 at 6:55 PM, Joseph Martinez <jo...@jm...>
> wrote:
> > Ok, I found the SSDL file, and there are no references to the stored
> > procedures in it.
>
> Then SPs were not imported. Probably there's a message in error/output
> window.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
> and much more. Keep your Java skills current with LearnJavaNow -
> 200+ hours of step-by-step video tutorials by Java experts.
> SALE $49.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122612
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiri C. <di...@ci...> - 2013-01-09 13:39:47
|
Without any further clue, it's hard to guess. Is the database queried
for SPs? Do you see the query (TraceAPI, Output log, ...)?
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-09 17:03:43
|
Jiri,
I'm not familiar with Trace API. What output log would I look at, and how?
-Joe
On Wed, Jan 9, 2013 at 5:13 AM, Jiri Cincura <di...@ci...> wrote:
> Without any further clue, it's hard to guess. Is the database queried
> for SPs? Do you see the query (TraceAPI, Output log, ...)?
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
> and much more. Keep your Java skills current with LearnJavaNow -
> 200+ hours of step-by-step video tutorials by Java experts.
> SALE $49.99 this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122612
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
|
|
From: Jiri C. <di...@ci...> - 2013-01-10 10:40:15
|
On Wed, Jan 9, 2013 at 6:03 PM, Joseph Martinez <jo...@jm...> wrote:
> What output log would I look at, and how?
Output from FirebirdClient, it uses TraceSource, so you can see it in
attached listeners. If you attach VS, the default listener is going to
write to Output Window.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
|
|
From: Joseph M. <jo...@jm...> - 2013-01-09 18:27:27
|
Just in case it helps, here's the source for one of my SPs:
create procedure PREDICT_COST_1 (BARCODE VarChar(25), STOREID INTEGER)
returns (THE_COST Double Precision) as
DECLARE VARIABLE TEMP_COST Double Precision;
BEGIN
select first 1 itemcost from orderitems A inner join orders B on A.orderid
= B.orderid
where A.itembarcode = :BARCODE and A.itemqtyordered > A.itemqtyreceived
and A.itemcost > 0 order by B.orderdate desc into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 A.vpcost from vendorproducts A inner join products B
on A.VPUPC = B.PRODBARCODE and A.VPVENDOR = B.PRODSOURCE
where B.prodbarcode = :BARCODE and A.STOREID = :STOREID and A.vpcost > 0
into :TEMP_COST;
if (TEMP_COST is null) then
BEGIN
select first 1 vpcost from vendorproducts
where vpupc = :BARCODE and STOREID = :STOREID and vpcost > 0 into
:TEMP_COST;
END
END
THE_COST = TEMP_COST;
END
Do you see anything about it that may cause it to not get imported?
-Joe
On Wed, Jan 9, 2013 at 9:03 AM, Joseph Martinez <jo...@jm...>wrote:
> Jiri,
>
> I'm not familiar with Trace API. What output log would I look at, and how?
>
> -Joe
>
>
> On Wed, Jan 9, 2013 at 5:13 AM, Jiri Cincura <di...@ci...> wrote:
>
>> Without any further clue, it's hard to guess. Is the database queried
>> for SPs? Do you see the query (TraceAPI, Output log, ...)?
>>
>> --
>> Jiri {x2} Cincura (x2develop.com founder)
>> http://blog.cincura.net/ | http://www.ID3renamer.com
>>
>>
>> ------------------------------------------------------------------------------
>> Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
>> and much more. Keep your Java skills current with LearnJavaNow -
>> 200+ hours of step-by-step video tutorials by Java experts.
>> SALE $49.99 this month only -- learn more at:
>> http://p.sf.net/sfu/learnmore_122612
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X