StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



SQL FunctionsExpand / Collapse
Author
Message
Posted 08/18/2006 8:48:06 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 08/30/2007 12:23:01 PM
Posts: 25, Visits: 64
In the scenarios that I'll be deploying, I know always that I will be going against SQL Server, which allows functions

I'd like to be able to include the functions, and get them created in the correct order. I consider it perfectly acceptable for the client to be unable to install against back ends that don't allow the use of functions
Need: Some of the Views use functions (Pure SQL functions, NOT .Net functions (Yet, but that's coming soon too), for speed reasons. The view creation explicitly fails if the function doesn't exist. Next project is quite likely to require function usage. To add to the fun, some functions use other functions, so should probably be dumped into the creation pool with the views (e.g. Create all Tables, Create all Views/Functions, then Create procs. At least this is the modifications I would have to make to our own, custom deployment app, hoping you guys handle it already!)
Post #2269
Posted 08/18/2006 8:52:06 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890
The DDT does not support the deployment of UDFs or UDTs... if you need to deploy them, then you'll need to stick to scripting or some other database deployment model.

However, the Application Framework supports them and quite frankly doesn't care where the data comes from, so you could use it for your application without any problems.


www.bungie.net
Post #2271
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 3:09am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.125. 13 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.