Linq sample code for ado.net - sql server?
Posted: Mon 13 Apr 2020 21:28
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!
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!