Alexander Filipov

Use JOIN instead of LEFT JOIN for associations with non-nullable foreign key columns

Currently OpenAccess uses left joins to retrieve data from multiple related tables in a single query. It is more optimal to use inner joins when the foreign key column does not allow null values.

Example:
from product in context.Products
select new { product.ProductName, product.Category.CategoryName };

results in the following SQL statement:
SELECT a.[ProductName] AS COL1, b.[CategoryName] AS COL2 FROM [Products] a LEFT JOIN [Categories] AS b ON (a.[CategoryID] = b.[CategoryID])

but could be optimized as follows, if a.[CategoryID] is not a nullable column.:
SELECT a.[ProductName] AS COL1, b.[CategoryName] AS COL2 FROM [Products] a JOIN [Categories] AS b ON (a.[CategoryID] = b.[CategoryID])
Feature Request by Alexander Filipov Status: Reviewed Comments: 1 Last update: 2017-03-30T21:42:25 by Yijun Huang
0
Norbert Haberl

Mono support

Hey guys,

Mono support would be nice - just for the fluent API.
See this post, it's from 2009 and nothing happened so far (http://www.telerik.com/community/forums/orm/general-discussions/mono.aspx)


Bye Norbert
Feature Request by Norbert Haberl Status: Reviewed Comments: 6 Last update: 2017-02-21T10:09:41 by Rafał Kasa
0
Nancy Gauvin

google

Feedback by Nancy Gauvin Status: New Comments: 0 Last update: 2016-12-30T17:10:58 by Nancy Gauvin
0
Anne S

data-centers

The Sitefinity dec data-centers are down.
Feedback by Anne S Status: New Comments: 0 Last update: 2016-12-30T09:51:00 by Anne S
0
Viktor Zhivkov
Team Member

Out of the box asynchronous queries

As OpenAccess developer I would like to be able to queries against database in asynchronous manner. This will allow me to develop more responsive applications and improve performance in numeric scenarios.
Currently I have to implement asynchronous queries manually which is tedious and error prone work.
Feature Request by Viktor Zhivkov Status: Reviewed Comments: 3 Last update: 2016-12-05T16:08:56 by Philip Chamberlin
0
Michael Plahuta
0
Doroteya Agayna

Generation of fluent models with Data Access Q2 2015 and higher

After the deprecation of the Visual Studio integration, the database-first approach of building Data Access models is not supported, and a tool that provides it will be handy.
Feature Request by Doroteya Agayna Status: New Comments: 108 Attachments: 2 Last update: 2016-10-19T18:23:48 by Marko Gluhak
0
Yan Mamoyko

support for async operations to save, delete, update and insert

please, add support for async operation, would be a good option
Feature Request by Yan Mamoyko Status: Reviewed Comments: 28 Last update: 2016-10-06T07:50:31 by Nuno Coimbra
0
Aleksandr Shevchenko

download Data Access Q1 2015 doesn't work

Resource Request by Aleksandr Shevchenko Status: New Comments: 7 Last update: 2016-09-22T13:39:52 by Jason Douglas
0
Doroteya Agayna

Data Access support for ASP.NET 5

ASP.NET 5 is in development, but RC1 is already available. As a web developer I would like to be able to use Data Access and ASP.NET 5.
Feature Request by Doroteya Agayna Status: New Comments: 6 Last update: 2016-08-31T21:11:34 by Joshua Holt
0
Displaying items 1 - 10 of 221