StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5674242
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
11
CommunityOwnedDate
CreationDate
2011-04-15T08:35:38.820
FavoriteCount
0
LastActivityDate
2011-05-27T03:48:15.187
LastEditDate
2011-05-27T03:48:15.187
LastEditorUserId
2671158
OwnerUserId
2671158
ParentId
5666703
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
I believe it can be done. However, F# core library is the sole property of Microsoft. This means you can't modify its code and recompile it to match and comply with SQLCLR SAFE. I suggest you add suggestion to Microsoft using Microsoft's connect website. Microsoft connect is at: <a href="http://connect.microsoft.com" rel="nofollow">http://connect.microsoft.com</a> (you have to register and have email account on live.com or hotmail.com before register). To manually add your .NET DLL and integrate it to SQL Server, you can do this: In this example, the DLL from your F# code has to be compiled first. I take this step from MSDN Library link: <a href="http://msdn.microsoft.com/en-us/library/ms254956(v=vs.80).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms254956(v=vs.80).aspx</a> Just don't forget to add PERMISSION_SET = SAFE to the CREATE ASSEMBLY command. Here are the steps I quote from above link: <blockquote> Loading and Running the "Hello World" Stored Procedure in SQL Server Once the sample procedure has successfully compiled, you can test it in SQL Server. To do this, open SQL Server Management Studio and create a new query, connecting to a suitable test database (for example, the AdventureWorks sample database). We will need to create the assembly so we can access the stored procedure. For this example, we will assume that you have created the helloworld.dll assembly in the C:\ directory. Add the following Transact-SQL statement to your query. <pre><code>CREATE ASSEMBLY helloworld from 'c:\helloworld.dll' WITH PERMISSION_SET = SAFE </code></pre> Once the assembly has been created, we can now access our HelloWorld method by using the create procedure statement. We will call our stored procedure "hello": <pre><code>CREATE PROCEDURE hello AS EXTERNAL NAME helloworld.HelloWorldProc.HelloWorld </code></pre> Once the procedure has been created, it can be run just like a normal stored procedure written in Transact-SQL. Execute the following command: <pre><code>EXEC hello </code></pre> This should result in the following output in the SQL Server Management Studio messages window. <pre><code>Hello world! </code></pre> </blockquote> Edit: based on the commenter below, he's right about F# is now open source! You can modify and recompile it to suit your needs. Edit: adding more detail guide on how to integrate the DLL to SQL Server CLR integration.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCan the F# core libs be SQLCLR-approved?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USEriawan Kusumawardhono
UserOwnerUserId
1. USEriawan Kusumawardhono
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.