Snippets tagged SQL
-
Functional Unparsing SQL
A combinator based DSL for composing type-safe parameterized sql queries. Inspired by Olivier Danvy's "Functional Unparsing" paper.
10 people like this
Like the snippet!Posted: 14 years ago by Nick Palladinos
-
F# 3.0 - EntityFramework Type Provider usage with Northwind DB
A small sample how to use F# 3.0 Entity Framework (EF) Type Provider. Visual Studio 11 Beta (and Northwind sample database) needed.
5 people like this
Like the snippet!Posted: 14 years ago by Tuomas Hietanen
-
One script to create MS-SQL-database and host OWIN Web-server with SignalR-clients
One script to create MS-SQL-database and host OWIN Web-server with SignalR-clients
1 people like this
Like the snippet!Posted: 10 years ago by Tuomas Hietanen
-
LINQ to SQLite
Simplest possible sample code for accessing an in-process SQLite database file using LINQ The code does not use a dbml file for the mapping, but an attribute enriched type. (F# script, .Net 4.0, F# 2.0)
6 people like this
Like the snippet!Posted: 14 years ago by Dirk Devriendt
-
FsSql usage example
FsSql is originally here: https://github.com/mausch/FsSql and better sample is there too but I just want to share it.
2 people like this
Like the snippet!Posted: 13 years ago by Ash Harley
-
Basic F# LINQ GroupBy example and multiple aggregates
Converting F# LINQ queries to SQL: - Basic example of simple group-by - Also if you want to have multiple aggregates (SUM, COUNT, MAX, MIN, AVG, ...) in the same SQL-clause, that is done with groupBy over a constant value.
2 people like this
Like the snippet!Posted: 6 years ago by Tuomas Hietanen