Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Data.Entity;
- namespace DAL.Models
- {
- public static class IDbSetExtensions
- {
- /// <summary>
- /// When using IDbSet Interface the SQLQuery method is hidden this extension method will allow us to expose the method
- /// </summary>
- /// <typeparam name="TEntity">Entity Class</typeparam>
- /// <param name="set">IDbSet</param>
- /// <param name="query">String sql query</param>
- /// <returns></returns>
- public static IEnumerable<TEntity> SearchQuery<TEntity>(this IDbSet<TEntity> set, string query)
- where TEntity : class
- {
- var dbSet = set as DbSet<TEntity>;
- if (dbSet != null)
- {
- return dbSet.SqlQuery(query);
- }
- throw new NotSupportedException();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement