UOW - Stored Proc about devicemanager.api HOT 5 CLOSED

Hi @arunprasathv

1. You don't have to change UoW to execute raw sql.
2. You just need to add following method to generic repository (Repository.cs):

       public IQueryable<T> FromSql(string sqlQuery)
        {
            return this.dbSet.FromSql(sqlQuery);
        }

...
var users = userRepository.FromSql(""EXECUTE dbo.GetUsers").ToList();
....

Hi @Boriszn

I already have this method in repository.cs , the stored proc will not be related to any repository as it might get results from a couple of tables. Do I need to create a repository/model that matches SPs response and use it to call the SP.

public IQueryable FromSql(string query, params object[] parameters)
{
return this.dbSet.FromSql(query, parameters);
}

from devicemanager.api.

Hi @arunprasathv

Yeah better would be create custom repository derived from generic one and use this in Business Layer.
And you need model (you can map it in select like: FromSql(sql, params).Select(t => new Test {Id = t.Id}))

from devicemanager.api.

@Boriszn Yep. Something like this makes sense. Thanks.

from devicemanager.api.

Hi @arunprasathv Welcome. Let me know if you need more info ;)

from devicemanager.api.