vb.net about fastcrud HOT 7 CLOSED

its c# 6.0 ability.

string.Format("{0}=@fFirstNameParam", "FirstName") 

equal to

$"{nameof(Entity.FirstName)}=@FirstNameParam"

second one has intellisense and refactoring advantage.

if you are new on c# try install visual studio 2015 and use lastes version of c# and .net framework.

from fastcrud.

Thank you for your fast reply. I'm sorry to say i must use Net 4.5. In your descrition you say it is possible. Please send me an example.

from fastcrud.

try this. its pure string way.

dbConnection.Find( whereClause:"FirstName=@FirstNameParam", orderClause:"LastName DESC", skipRowsCount:10, limitRowsCount:20, queryParameters: new {FirstNameParam: "John"});

from fastcrud.

Sorry it dosn't work. The compiler says "not a definition for Find with this parameter".
May be, I'm too stupid ;-)

from fastcrud.

@OleeOlsen First of all Ole, welcome to our wonderful C# world. It's beautiful, but it's not gonna be easy for you, as I myself have realized while trying to come up with this simple VB.NET example when I have zero experience in this language.

Imports System.Data.SqlClient
Imports Dapper.FastCrud

Module Module1

    Sub Main()
        Using conn As New SqlConnection
            Dim persons = conn.Find(Of Person)(
                   whereClause := $"{NameOf(Person.FirstName)}=@FirstNameParam",
                   queryParameters := New With{.FirstNameParam="John"})
        End Using
    End Sub

End Module

I hope it makes sense. This translates to C# as follows:

using System.Data.SqlClient;
using Dapper.FastCrud;

namespace YourNamespace
{

    class Program
    {
        static void Main(string[] args)
        {
            using (var conn = new SqlConnection())
            {
                var persons = conn.Find<Person>(
                    whereClause: $"{nameof(Person.FirstName)}=@FirstNameParam",
                    queryParameters: new { FirstNameParam="John" });
            }
        }
    }
}

Both obviously assume there is a class Person defined with FirstName as a string property.

Regardless whether you want to write in VB.NET or C#, you have to use Visual Studio 2015. String interpolation is mostly a language feature, handled by the compiler, thus you can target even .NET 4.5 if you so desire. Just make sure that, before you add the FastCrud Nuget package, your project is already targeting that version of the framework in the Properties => Application screen.

from fastcrud.

@MoonStorm Thank you for this extendet reply. You shold write a requirement-section in the wiki.
I have now installed VS 2015 and use Net 4.5. And it woks. ;-)

from fastcrud.

You're right. I've added more on the front page. Thanks to you, now I know string interpolation was made available in VB 14 😆

from fastcrud.