Back to Questions
1.4k
views1
comment
How to use SQLite while building web using Websharper?
websharperrpcwebsiteui

I'm building a site that functions to get data from "input" to update the database from the server side. To do it of course I have to use the call to the server side and then use SQLite to be able to update the data to the database (* .db file) . But do not be shy, I received the unwanted :

1

System.Exception: Could not load method (act : unit -> Microsoft.FSharp.Control.FSharpAsync`1<unit>) candidates: [||]

I do not know how to fix this, please help me !

Main.fs : https://gist.github.com/tungandcun/3d0a8c5008343861624d94d3e52c56a4 Client.fs : https://gist.github.com/tungandcun/c43fb92bb9e8956dbd9332779c9bfd72 Remoting.fs : https://gist.github.com/tungandcun/980ecb346f886fd6f710eebe0b160823 sample.fs : https://gist.github.com/tungandcun/465b19b60a64b4b6c578e3704c155a0e

And I installed the following packages from Nuget : SQLProvider System.Data.SQLite.Core

Thank you very much !

Or you can comment in https://stackoverflow.com/questions/48946108/how-to-use-sqlite-while-building-web-using-websharper-or-suave

.

I think here the issue is that act is a value and not a function, so it can't be called as an RPC. You need to declare it as a function taking unit as argument:

1
2
3
4
5

    [<Remote>]
    let act() =
        async{
            sample.main()
        }

and call it the same way.

Note that you should also change sample.main to take a unit argument, otherwise it will only be run once on startup, instead of every time you call act().

This is definitely something that should get a clearer error message though!

By on 2/23/2018 12:51 PM ()

    Topic tags

    IntelliFactory Offices Copyright (c) 2011-2012 IntelliFactory. All rights reserved.
    Home | Products | Consulting | Trainings | Blogs | Jobs | Contact Us | Terms of Use | Privacy Policy | Cookie Policy     		Built with WebSharper