Entitiy Framework Where If Extension Method.

public static class Extension
{
public static IQueryable<TSource> WhereIf<TSource>(this IQueryable<TSource> source, bool condition, Expression<Func<TSource, bool>> predicate)
{
return condition ? source.Where(predicate) : source;
}
}

var query = db.USERS.WhereIf(txtName.Text.IsNotNull(), x => x.Name==txtName.Text).WhereIf(txtSurName.Text.IsNotNull(), x => x.SurName==txtSurName.Text);

 

 

How to connect oracle 12 c with entitiy framework v.5.0 - visual studio 2017

1) install oracle 12 c 12.1.0.2.0(http://www.oracle.com/technetwork/database/enterprise edition/downloads/database12c-win64-download-2297732.html)

2) if you have dr0ulib.sql.sbs error when install oracle 12 c

•  Abort the current installer


• Open the winx64_12c_database_2of2 directory and navigate to ..\winx64_12c_database_2of2\database\stage\Components directory copy all the files


• Paste all files to the following location..\winx64_12c_database_1of2\database\stage\Components

 

• Now run the setup.exe “Run as administrator” and follow the instructions to complete the installation without error.

3) install ( 64-bit ODAC 12c Release 1 (12.1.0.1.0) for Windows x64) http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html - VS 2017

http://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownload-2745497.html - VS2015

4)Open visual studio

5)İnstall Entitiy Framework 5.0 on nuget

6)Project Right Click > Add > New Item > Data > ADO.NET Enitity Data Model>  > EF Desiger From database > New Connection > You must fill the area (Username,Password) you check connect as sysdba role and then select the connection type (im using ez connect ) database host name 127.0.0.1, port number 1521 , database service name orcl  (you have to grant sysdba database user GRANT SYSDBA to BURAK;)

7) if you have error 'Unable to find the requested .Net Framework Data Provider. It may not be installed'

8) İnstall Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntitiyFramework on nuget.

 

 

no privileges on tablespace 'USERS' ORA-06512

GRANT UNLIMITED TABLESPACE TO BURAK;

how to create new user / schema oracle 12 c

ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
CREATE USER BURAK
IDENTIFIED BY "1";
GRANT SYSDBA to BURAK;