http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Tables created on the fly Mon, 27 Apr 2026 01:16:57 -700 Wed, 04 Dec 2013 08:48:10 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4619 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=4619&PID=17283#17283 Author: smi-mark
Subject: 4619
Posted: 04-Dec-2013 at 8:48am

Can you have a stored procedure that will return the data based on the year/month you pass to it, and then map the stored procedure to return your PercapHist entity?]]> Wed, 04 Dec 2013 08:48:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4619&PID=17283#17283 http://www.ideablade.com/forum/forum_posts.asp?TID=4619&PID=17282#17282 Author: kimj
Subject: 4619
Posted: 04-Dec-2013 at 8:47am

The mapping to the storage layer, which is done by EF not DevForce, is static and can't be changed at runtime.   You're best bet here is probably a stored proc query or view.]]> Wed, 04 Dec 2013 08:47:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4619&PID=17282#17282 http://www.ideablade.com/forum/forum_posts.asp?TID=4619&PID=17280#17280 Author: BillG
Subject: 4619
Posted: 04-Dec-2013 at 5:53am

I know that my DevForce entity model needs to know my tables ahead of time to take a snapshot. But how do I handle this situation. I have a base table named PercapHist. Each month a new table is created in a stored procedure. (ex PercapOEDues1301, PercapOEDues1302 etc.)

In a certain routine I need to know if the percap routine was run for a previous month or already run for the current month. such as the following

string thisMonth = (percapMonth.Year + percapMonth.Month).ToString();
string percapThisMonth = "PercapOEDues" + thisMonth;

DateTime lastPercap = percapMonth.AddMonths(-1);
string lastMonth = (lastPercap.Year + percapMonth.Month).ToString();
string percapLastMonth = "PercapOEDues" + lastMonth;

Now I need to query either of the two tables PercapThisMonth or PercapLastMonth and see if they have any rows in them.



]]> Wed, 04 Dec 2013 05:53:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4619&PID=17280#17280