I have a project vsto with sql server, and I want to use ado.net to read and write data to it because I want to create dynamic queries when using linq.
I am fairly new with sql and linq. I would like to ask if devart provide some basic code samples to access reading, writing even formula in the query (such a query string: "Select left(Column1,3) from Table1")
I mean I want to customize the query string more,
ex: get the header or not, support formula sum, average, etc. (if I'm using dotconnect for sql server then can I access these Canonical Functions? )
if they don't already exist and I have to build by myself whether I should choose devart linq to sql or entity framework? . Mostly my work is reporting but not too complicated, I will load all the data into sql database and customize the data to report through the query string.
Thank you!
Linq sample code for ado.net - sql server?
Re: Linq sample code for ado.net - sql server?
I have just tested dotconnect for sqlserver, I would like to ask if I use the query multiple times, what should I do to improve performance, such as creating a virtual table or stored procedure, objectquery or querystring cache, ... I Not sure exactly what will help ?
Re: Linq sample code for ado.net - sql server?
dotConnect for SQL Server doesn't support any ORM frameworks.
You can use a standard provider System.Data.SqlClient.
Our product line includes the following tools for SQL Server (choose any):
You can use a standard provider System.Data.SqlClient.
Our product line includes the following tools for SQL Server (choose any):
- Entity Developer LINQ to SQL Edition -> generates LINQ to SQL Model with System.Data.SqlClient
- LinqConnect Standard Edition -> our ORM framework that is developed closely to the Microsoft LINQ to SQL technology (https://www.devart.com/linqconnect/linq ... sions.html), also works via System.Data.SqlClient
- Entity Developer Entity Framework Edition -> generates Entity Framework model with System.Data.SqlClient
Re: Linq sample code for ado.net - sql server?
Thanks shalex, i got it.