text:
Ford goes premium with Vignale
The Ford Mondeo is about to make a move upmarket thanks to the introduction of a new premium sub-brand called Vignale. Promising to be much more than another trim level, Vignale is a portrayed more as a lifestyle extension consisting of dedicated 'Relationship Managers' and exclusive lounges. You won't even have to go to a regular Ford dealership to buy one, instead you'll do so in the Vignale Lounge of a FordStore where said relationship manager will help you spec up your car on a 'specially designed touch table'. They'll even use 'tablet devices'! According to the official release the Vignale Lounge "provides an environment designed to ensure customers feel valued and respected". Shouldn't all car dealerships ensure that anyway?
So just what is a Vignale? Basically, Ford is attempting to create a more exclusive car out of its mainstream Mondeo. Some might call it putting lipstick on a pig but let's be fair, the current Mondeo despite its tardiness to market is a handsome car, especially if you go for the higher Titanium grade. But Vignale takes it one step further.
All the cars are made at the same facility as the regular Mondeo in Valencia, Spain. Each car is taken off the main production line and moved into a 'Vignale Centre' where six people carry out an additional one hundred or so checks to ensure that it meets the grade. This includes checking shut lines and panel alignment, the quality of the interior stitching and all that is topped off with "more than two hours of hand-polishing the paintwork". As Chairman and Managing Director of Ford Ireland, Ciarán McMahon said during the car's launch: "There's no such thing as a perfect vehicle, every car will have issues that a customer might find". He added: "Our vision for Vignale is to create a modern, contemporary upscale experience that is a valued part of customers' lives."
The hexagonal grille at the front gets a specific look consisting of a dark matt metallic finish with a polished aluminium surround while the lower grille features a chrome base that extends out and around front fog lights. We've not seen this much chrome on the front of a saloon since the Saab 9-5 of 2009, but it is infinitely better in this instance.
Along the flanks designers have added an upwardly sloping chrome strip that runs across the lower sections of the front and rear doors. It looks a little odd, and some might say superfluous, but hey nothing says premium like lashings of chrome. The car also gets model-specific 18-inch alloy wheels and the option of 19-inch 'Vignale lustre nickel' alloy wheels. There's a special exterior paint available too, called Vignale Nocciola.
Inside there's a leather interior that uses a higher grade of hide than what is found in a regular Ford while the front seats are heated and the driver can adjust it in ten ways to find that sweet spot. The much improved and usually extra SYNC 2 infotainment system with its 8-inch touchscreen features as standard and flashes up the Vignale logo every time you start the car just to remind you that you're not in a regular Mondeo. On the safety front there is a Lane Keeping Aid that includes a Traffic Sign Recognition and a reversing camera and parking sensors, both of which feature already as standard equipment on the Titanium-grade Mondeo.
To help make the Mondeo Vignale feel that bit more special additional sound deadening material is built in and the stereo system also employs sound cancelling speakers to reduce road noise. In the brief drive we had in the car we could detect no noticeable difference. The leather interior is of a better quality but isn't quite up to the standard seen in the likes of an Audi or BMW.
Ford expects to sell two to three hundred Mondeo Vignales each year in Ireland, which given the €43,900 starting price that rises to €50,405 for the all-wheel drive estate version, we think is a somewhat optimistic target.


text:
Q: Raw SQL Query without DbSet - Entity Framework Core With Entity Framework Core removing dbData.Database.SqlQuery<SomeModel> I can't find a solution to build a raw SQL Query for my full-text search query that will return the tables data and also the rank.
The only method I've seen to build a raw SQL query in Entity Framework Core is via dbData.Product.FromSql("SQL SCRIPT"); which isn't useful as I have no DbSet that will map the rank I return in the query.
Any Ideas???

A: Add Nuget package - Microsoft.EntityFrameworkCore.Relational
using Microsoft.EntityFrameworkCore;
...
await YourContext.Database.ExecuteSqlCommandAsync("... @p0, @p1", param1, param2 ..)

This will return the row numbers as an int
See - https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationaldatabasefacadeextensions.executesqlcommand?view=efcore-3.0

A: try this: (create extension method)
public static List<T> ExecuteQuery<T>(this dbContext db, string query) where T : class, new()
        {
            using (var command = db.Database.GetDbConnection().CreateCommand())
            {
                command.CommandText = query;
                command.CommandType = CommandType.Text;

                db.Database.OpenConnection();

                using (var reader = command.ExecuteReader())
                {
                    var lst = new List<T>();
                    var lstColumns = new T().GetType().GetProperties(BindingFlags.DeclaredOnly | BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic).ToList();
                    while (reader.Read())
                    {
                        var newObject = new T();
                        for (var i = 0; i < reader.FieldCount; i++)
                        {
                            var name = reader.GetName(i);
                            PropertyInfo prop = lstColumns.FirstOrDefault(a => a.Name.ToLower().Equals(name.ToLower()));
                            if (prop == null)
                            {
                                continue;
                            }
                            var val = reader.IsDBNull(i) ? null : reader[i];
                            prop.SetValue(newObject, val, null);
                        }
                        lst.Add(newObject);
                    }

                    return lst;
                }
            }
        }

Usage:
var db = new dbContext();
string query = @"select ID , Name from People where ... ";
var lst = db.ExecuteQuery<PeopleView>(query);

my model: (not in DbSet):
public class PeopleView
{
    public int ID { get; set; }
    public string Name { get; set; }
}

tested in .netCore 2.2 and 3.0.

Note: this solution has the slow performance

A: In Core 2.1 you can do something like this:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
       modelBuilder.Query<Ranks>();
}

and then define you SQL Procedure, like:
public async Task<List<Ranks>> GetRanks(string value1, Nullable<decimal> value2)
{
    SqlParameter value1Input = new SqlParameter("@Param1", value1?? (object)DBNull.Value);
    SqlParameter value2Input = new SqlParameter("@Param2", value2?? (object)DBNull.Value);

    List<Ranks> getRanks = await this.Query<Ranks>().FromSql("STORED_PROCEDURE @Param1, @Param2", value1Input, value2Input).ToListAsync();

    return getRanks;
}

This way Ranks model will not be created in your DB.
Now in your controller/action you can call:
List<Ranks> gettingRanks = _DbContext.GetRanks(value1,value2).Result.ToListAsync();

This way you can call Raw SQL Procedures.

A: Building on the other answers I've written this helper that accomplishes the task, including example usage:
public static class Helper
{
    public static List<T> RawSqlQuery<T>(string query, Func<DbDataReader, T> map)
    {
        using (var context = new DbContext())
        {
            using (var command = context.Database.GetDbConnection().CreateCommand())
            {
                command.CommandText = query;
                command.CommandType = CommandType.Text;

                context.Database.OpenConnection();

                using (var result = command.ExecuteReader())
                {
                    var entities = new List<T>();

                    while (result.Read())
                    {
                        entities.Add(map(result));
                    }

                    return entities;
                }
            }
        }
    }

Usage:
public class TopUser
{
    public string Name { get; set; }

    public int Count { get; set; }
}

var result = Helper.RawSqlQuery(
    "SELECT TOP 10 Name, COUNT(*) FROM Users U"
    + " INNER JOIN Signups S ON U.UserId = S.UserId"
    + " GROUP BY U.Name ORDER BY COUNT(*) DESC",
    x => new TopUser { Name = (string)x[0], Count = (int)x[1] });

result.ForEach(x => Console.WriteLine($"{x.Name,-25}{x.Count}"));

I plan to get rid of it as soon as built-in support is added. According to a statement by Arthur Vickers from the EF Core team it is a high priority for post 2.0. The issue is being tracked here.

A: In EF Core you no longer can execute "free" raw sql. You are required to define a POCO class and a DbSet for that class.
In your case you will need to define Rank:
var ranks = DbContext.Ranks
   .FromSql("SQL_SCRIPT OR STORED_PROCEDURE @p0,@p1,...etc", parameters)
   .AsNoTracking().ToList();

As it will be surely readonly it will be useful to include the .AsNoTracking() call.
EDIT - Breaking change in EF Core 3.0:
DbQuery() is now obsolete, instead DbSet() should be used (again). If you have a keyless entity, i.e. it don't require primary key, you can use HasNoKey() method:
ModelBuilder.Entity<SomeModel>().HasNoKey()

More information can be found here

A: I used Dapper to bypass this constraint of Entity framework Core.
IDbConnection.Query

is working with either sql query or stored procedure with multiple parameters.
By the way it's a bit faster (see benchmark tests )
Dapper is  easy to learn. It took 15 minutes  to write and run stored procedure with parameters. Anyway you may use both EF and Dapper. Below is an example:
 public class PodborsByParametersService
{
    string _connectionString = null;

    public PodborsByParametersService(string connStr)
    {
        this._connectionString = connStr;

    }

    public IList<TyreSearchResult> GetTyres(TyresPodborView pb,bool isPartner,string partnerId ,int pointId)
    {

        string sqltext  "spGetTyresPartnerToClient";

        var p = new DynamicParameters();
        p.Add("@PartnerID", partnerId);
        p.Add("@PartnerPointID", pointId);

        using (IDbConnection db = new SqlConnection(_connectionString))
        {
            return db.Query<TyreSearchResult>(sqltext, p,null,true,null,CommandType.StoredProcedure).ToList();
        }

        }
}

A: I found the package EntityFrameworkCore.RawSQLExtensions on github. To use it, add the nuget package.
<PackageReference Include="EntityFrameworkCore.RawSQLExtensions" Version="1.2.0" />

The library is not documented but below is my using of it with .NET 6 + EF Core 6 + Npgsql 6
public class DbResult
{
    public string Name { get; set; }
    public int Age { get; set; }
}

using EntityFrameworkCore.RawSQLExtensions.Extensions;

var results = await context.Database
    .SqlQuery<DbResult>(
        @"select name, age from ""users"" where age > @Age",
        new NpgsqlParameter("@Age", 15))
    .ToListAsync();

A: For now, until there is something new from EFCore I would used a command
and map it manually
  using (var command = this.DbContext.Database.GetDbConnection().CreateCommand())
  {
      command.CommandText = "SELECT ... WHERE ...> @p1)";
      command.CommandType = CommandType.Text;
      var parameter = new SqlParameter("@p1",...);
      command.Parameters.Add(parameter);

      this.DbContext.Database.OpenConnection();

      using (var result = command.ExecuteReader())
      {
         while (result.Read())
         {
            .... // Map to your entity
         }
      }
  }

Try to SqlParameter to avoid Sql Injection.
 dbData.Product.FromSql("SQL SCRIPT");

FromSql doesn't work with full query.  Example if you want to include a WHERE clause it will be ignored.
Some Links:
Executing Raw SQL Queries using Entity Framework Core
Raw SQL Queries

A: Not directly targeting the OP's scenario, but since I have been struggling with this, I'd like to drop these ex. methods that make it easier to execute raw SQL with the DbContext:
public static class DbContextCommandExtensions
{
  public static async Task<int> ExecuteNonQueryAsync(this DbContext context, string rawSql,
    params object[] parameters)
  {
    var conn = context.Database.GetDbConnection();
    using (var command = conn.CreateCommand())
    {
      command.CommandText = rawSql;
      if (parameters != null)
        foreach (var p in parameters)
          command.Parameters.Add(p);
      await conn.OpenAsync();
      return await command.ExecuteNonQueryAsync();
    }
  }

  public static async Task<T> ExecuteScalarAsync<T>(this DbContext context, string rawSql,
    params object[] parameters)
  {
    var conn = context.Database.GetDbConnection();
    using (var command = conn.CreateCommand())
    {
      command.CommandText = rawSql;
      if (parameters != null)
        foreach (var p in parameters)
          command.Parameters.Add(p);
      await conn.OpenAsync();
      return (T)await command.ExecuteScalarAsync();
    }
  }
}

A: My case used stored procedure instead of raw SQL
Created a class
Public class School
{
    [Key]
    public Guid SchoolId { get; set; }
    public string Name { get; set; }
    public string Branch { get; set; }
    public int NumberOfStudents  { get; set; }
}

Added below on my DbContext class
public DbSet<School> SP_Schools { get; set; }

To execute the stored procedure:
var MySchools = _db.SP_Schools.FromSqlRaw("GetSchools @schoolId, @page, @size ",
              new SqlParameter("schoolId", schoolId),
              new SqlParameter("page", page),
              new SqlParameter("size", size)))
.IgnoreQueryFilters();

A: I updated extension method from @AminRostami to return IAsyncEnumerable (so LINQ filtering can be applied) and it's mapping Model Column name of records returned from DB to models (Tested with EF Core 5):
Extension itself:
public static class QueryHelper
{
    private static string GetColumnName(this MemberInfo info)
    {
        List<ColumnAttribute> list = info.GetCustomAttributes<ColumnAttribute>().ToList();
        return list.Count > 0 ? list.Single().Name : info.Name;
    }
    /// <summary>
    /// Executes raw query with parameters and maps returned values to column property names of Model provided.
    /// Not all properties are required to be present in model (if not present - null)
    /// </summary>
    public static async IAsyncEnumerable<T> ExecuteQuery<T>(
        [NotNull] this DbContext db,
        [NotNull] string query,
        [NotNull] params SqlParameter[] parameters)
        where T : class, new()
    {
        await using DbCommand command = db.Database.GetDbConnection().CreateCommand();
        command.CommandText = query;
        command.CommandType = CommandType.Text;
        if (parameters != null)
        {
            foreach (SqlParameter parameter in parameters)
            {
                command.Parameters.Add(parameter);
            }
        }
        await db.Database.OpenConnectionAsync();
        await using DbDataReader reader = await command.ExecuteReaderAsync();
        List<PropertyInfo> lstColumns = new T().GetType()
            .GetProperties(BindingFlags.DeclaredOnly | BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic).ToList();
        while (await reader.ReadAsync())
        {
            T newObject = new();
            for (int i = 0; i < reader.FieldCount; i++)
            {
                string name = reader.GetName(i);
                PropertyInfo prop = lstColumns.FirstOrDefault(a => a.GetColumnName().Equals(name));
                if (prop == null)
                {
                    continue;
                }
                object val = await reader.IsDBNullAsync(i) ? null : reader[i];
                prop.SetValue(newObject, val, null);
            }
            yield return newObject;
        }
    }
}

Model used (note that Column names are different than actual property names):
public class School
{
    [Key] [Column("SCHOOL_ID")] public int SchoolId { get; set; }

    [Column("CLOSE_DATE", TypeName = "datetime")]
    public DateTime? CloseDate { get; set; }

    [Column("SCHOOL_ACTIVE")] public bool? SchoolActive { get; set; }
}

Actual usage:
public async Task<School> ActivateSchool(int schoolId)
{
    // note that we're intentionally not returning "SCHOOL_ACTIVE" with select statement
    // this might be because of certain IF condition where we return some other data
    return await _context.ExecuteQuery<School>(
        "UPDATE SCHOOL SET SCHOOL_ACTIVE = 1 WHERE SCHOOL_ID = @SchoolId; SELECT SCHOOL_ID, CLOSE_DATE FROM SCHOOL",
        new SqlParameter("@SchoolId", schoolId)
    ).SingleAsync();
}

A: Done this for Entity Framework Core 5, need to install
Microsoft.EntityFrameworkCore.Relational

The helper extension methods
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Storage;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;

public static class EfHelper
{
    public static DbTransaction GetDbTransaction(this IDbContextTransaction source)
    {
        return (source as IInfrastructure<DbTransaction>).Instance;
    }

    private class PropertyMapp
    {
        public string Name { get; set; }
        public Type Type { get; set; }

        public bool IsSame(PropertyMapp mapp)
        {
            if (mapp == null)
            {
                return false;
            }
            bool same = mapp.Name == Name && mapp.Type == Type;
            return same;
        }
    }

    public static IEnumerable<T> FromSqlQuery<T>(this DbContext context, string query, params object[] parameters) where T : new()
    {
        const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;
        List<PropertyMapp> entityFields = (from PropertyInfo aProp in typeof(T).GetProperties(flags)
                                           select new PropertyMapp
                                           {
                                               Name = aProp.Name,
                                               Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType
                                           }).ToList();
        List<PropertyMapp> dbDataReaderFields = new List<PropertyMapp>();
        List<PropertyMapp> commonFields = null;

        using (var command = context.Database.GetDbConnection().CreateCommand())
        {
            if (command.Connection.State != ConnectionState.Open)
            {
                command.Connection.Open();
            }
            var currentTransaction = context.Database.CurrentTransaction;
            if (currentTransaction != null)
            {
                command.Transaction = currentTransaction.GetDbTransaction();
            }
            command.CommandText = query;
            if (parameters.Any())
            {
                command.Parameters.AddRange(parameters);
            }
            using (var result = command.ExecuteReader())
            {
                while (result.Read())
                {
                    if (commonFields == null)
                    {
                        for (int i = 0; i < result.FieldCount; i++)
                        {
                            dbDataReaderFields.Add(new PropertyMapp { Name = result.GetName(i), Type = result.GetFieldType(i) });
                        }
                        commonFields = entityFields.Where(x => dbDataReaderFields.Any(d => d.IsSame(x))).Select(x => x).ToList();
                    }

                    var entity = new T();
                    foreach (var aField in commonFields)
                    {
                        PropertyInfo propertyInfos = entity.GetType().GetProperty(aField.Name);
                        var value = (result[aField.Name] == DBNull.Value) ? null : result[aField.Name]; //if field is nullable
                        propertyInfos.SetValue(entity, value, null);
                    }
                    yield return entity;
                }
            }
        }
    }

    /*
     * https://entityframeworkcore.com/knowledge-base/35631903/raw-sql-query-without-dbset---entity-framework-core
     */
    public static IEnumerable<T> FromSqlQuery<T>(this DbContext context, string query, Func<DbDataReader, T> map, params object[] parameters)
    {
        using (var command = context.Database.GetDbConnection().CreateCommand())
        {
            if (command.Connection.State != ConnectionState.Open)
            {
                command.Connection.Open();
            }
            var currentTransaction = context.Database.CurrentTransaction;
            if (currentTransaction != null)
            {
                command.Transaction = currentTransaction.GetDbTransaction();
            }
            command.CommandText = query;
            if (parameters.Any())
            {
                command.Parameters.AddRange(parameters);
            }
            using (var result = command.ExecuteReader())
            {
                while (result.Read())
                {
                    yield return map(result);
                }
            }
        }
    }
}

Model
public class UserModel
{
    public string Name { get; set; }
    public string Email { get; set; }
    public bool? IsDeleted { get; set; }
}

Manual mapping
List<UserModel> usersInDb = Db.FromSqlQuery
(
    "SELECT Name, Email FROM Users WHERE Name=@paramName",
    x => new UserModel
    {
        Name = (string)x[0],
        Email = (string)x[1]
    },
    new SqlParameter("@paramName", user.Name)
)
.ToList();

usersInDb = Db.FromSqlQuery
(
    "SELECT Name, Email FROM Users WHERE Name=@paramName",
    x => new UserModel
    {
        Name = x["Name"] is DBNull ? "" : (string)x["Name"],
        Email = x["Email"] is DBNull ? "" : (string)x["Email"]
    },
    new SqlParameter("@paramName", user.Name)
)
.ToList();

Auto mapping using reflection
List<UserModel> usersInDb = Db.FromSqlQuery<UserModel>
(
    "SELECT Name, Email, IsDeleted FROM Users WHERE Name=@paramName",
    new SqlParameter("@paramName", user.Name)
)
.ToList();

A: You can execute raw sql in EF Core - Add this class to your project.
This will allow you to execute raw SQL and get the raw results without having to define a POCO and a DBSet.
See https://github.com/aspnet/EntityFramework/issues/1862#issuecomment-220787464 for original example.
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Internal;
using Microsoft.EntityFrameworkCore.Storage;
using System.Threading;
using System.Threading.Tasks;

namespace Microsoft.EntityFrameworkCore
{
    public static class RDFacadeExtensions
    {
        public static RelationalDataReader ExecuteSqlQuery(this DatabaseFacade databaseFacade, string sql, params object[] parameters)
        {
            var concurrencyDetector = databaseFacade.GetService<IConcurrencyDetector>();

            using (concurrencyDetector.EnterCriticalSection())
            {
                var rawSqlCommand = databaseFacade
                    .GetService<IRawSqlCommandBuilder>()
                    .Build(sql, parameters);

                return rawSqlCommand
                    .RelationalCommand
                    .ExecuteReader(
                        databaseFacade.GetService<IRelationalConnection>(),
                        parameterValues: rawSqlCommand.ParameterValues);
            }
        }

        public static async Task<RelationalDataReader> ExecuteSqlQueryAsync(this DatabaseFacade databaseFacade,
                                                             string sql,
                                                             CancellationToken cancellationToken = default(CancellationToken),
                                                             params object[] parameters)
        {

            var concurrencyDetector = databaseFacade.GetService<IConcurrencyDetector>();

            using (concurrencyDetector.EnterCriticalSection())
            {
                var rawSqlCommand = databaseFacade
                    .GetService<IRawSqlCommandBuilder>()
                    .Build(sql, parameters);

                return await rawSqlCommand
                    .RelationalCommand
                    .ExecuteReaderAsync(
                        databaseFacade.GetService<IRelationalConnection>(),
                        parameterValues: rawSqlCommand.ParameterValues,
                        cancellationToken: cancellationToken);
            }
        }
    }
}

Here's an example of how to use it:
// Execute a query.
using(var dr = await db.Database.ExecuteSqlQueryAsync("SELECT ID, Credits, LoginDate FROM SamplePlayer WHERE " +
                                                          "Name IN ('Electro', 'Nitro')"))
{
    // Output rows.
    var reader = dr.DbDataReader;
    while (reader.Read())
    {
        Console.Write("{0}\t{1}\t{2} \n", reader[0], reader[1], reader[2]);
    }
}

A: You can use this:
public static class SqlQueryExtensions
{
    public static IList<T> SqlQuery<T>(this DbContext db, string sql, params object[] parameters) where T : class
    {
        using (var db2 = new ContextForQueryType<T>(db.Database.GetDbConnection()))
        {
            // share the current database transaction, if one exists
            var transaction = db.Database.CurrentTransaction;
            if (transaction != null)
                db2.Database.UseTransaction(transaction.GetDbTransaction());
            return db2.Set<T>().FromSqlRaw(sql, parameters).ToList();
        }
    }

    private class ContextForQueryType<T> : DbContext where T : class
    {
        private readonly DbConnection connection;

        public ContextForQueryType(DbConnection connection)
        {
            this.connection = connection;
        }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseSqlServer(connection, options => options.EnableRetryOnFailure());

            base.OnConfiguring(optionsBuilder);
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<T>().HasNoKey();
            base.OnModelCreating(modelBuilder);
        }
    }
}

And the usage:
    using (var db = new Db())
    {
        var results = db.SqlQuery<ArbitraryType>("select 1 id, 'joe' name");
        //or with an anonymous type like this
        var results2 = db.SqlQuery(() => new { id =1, name=""},"select 1 id, 'joe' name");
    }

A: If you're using EF Core 3.0 or newer
You need to use keyless entity types, previously known as query types:

This feature was added in EF Core 2.1 under the name of query types.
In EF Core 3.0 the concept was renamed to keyless entity types. The
[Keyless] Data Annotation became available in EFCore 5.0.

To use them you need to first mark your class SomeModel with [Keyless] data annotation or through fluent configuration with .HasNoKey() method call like below:
public DbSet<SomeModel> SomeModels { get; set; }

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<SomeModel>().HasNoKey();
}

After that configuration, you can use one of the methods explained here to execute your SQL query. For example you can use this one:
var result = context.SomeModels.FromSqlRaw("SQL SCRIPT").ToList();
var result = await context.SomeModels.FromSql("SQL_SCRIPT").ToListAsync();

If you're using EF Core 2.1
If you're using EF Core 2.1 Release Candidate 1 available since 7 may 2018, you can take advantage of the proposed new feature which is query types:

In addition to entity types, an EF Core model can contain query types,
which can be used to carry out database queries against data that
isn't mapped to entity types.

When to use query type?

Serving as the return type for ad hoc FromSql() queries.
Mapping to database views.
Mapping to tables that do not have a primary key defined.
Mapping to queries defined in the model.

So you no longer need to do all the hacks or workarounds proposed as answers to your question. Just follow these steps:
First you defined a new property of type DbQuery<T> where T is the type of the class that will carry the column values of your SQL query. So in your DbContext you'll have this:
public DbQuery<SomeModel> SomeModels { get; set; }

Secondly use FromSql method like you do with DbSet<T>:
var result = context.SomeModels.FromSql("SQL_SCRIPT").ToList();
var result = await context.SomeModels.FromSql("SQL_SCRIPT").ToListAsync();

Also note that DbContexts are partial classes, so you can create one or more separate files to organize your 'raw SQL DbQuery' definitions as best suits you.

A: This solution leans heavily on the solution from @pius.  I wanted to add the option to support query parameters to help mitigate SQL injection and I also wanted to make it an extension off of the DbContext DatabaseFacade for Entity Framework Core to make it a little more integrated.
First create a new class with the extension:
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Linq;
using System.Threading.Tasks;

namespace EF.Extend
{

    public static class ExecuteSqlExt
    {
        /// <summary>
        /// Execute raw SQL query with query parameters
        /// </summary>
        /// <typeparam name="T">the return type</typeparam>
        /// <param name="db">the database context database, usually _context.Database</param>
        /// <param name="query">the query string</param>
        /// <param name="map">the map to map the result to the object of type T</param>
        /// <param name="queryParameters">the collection of query parameters, if any</param>
        /// <returns></returns>
        public static List<T> ExecuteSqlRawExt<T, P>(this DatabaseFacade db, string query, Func<DbDataReader, T> map, IEnumerable<P> queryParameters = null)
        {
            using (var command = db.GetDbConnection().CreateCommand())
            {
                if((queryParameters?.Any() ?? false))
                    command.Parameters.AddRange(queryParameters.ToArray());

                command.CommandText = query;
                command.CommandType = CommandType.Text;

                db.OpenConnection();

                using (var result = command.ExecuteReader())
                {
                    var entities = new List<T>();

                    while (result.Read())
                    {
                        entities.Add(map(result));
                    }

                    return entities;
                }
            }

        }
    }

}

Note in the above that "T" is the type for the return and "P" is the type of your query parameters which will vary based on if you are using MySql, Sql, so on.
Next we will show an example.  I'm using the MySql EF Core capability, so we'll see how we can use the generic extension above with this more specific MySql implementation:
//add your using statement for the extension at the top of your Controller
//with all your other using statements
using EF.Extend;

//then your your Controller looks something like this
namespace Car.Api.Controllers
{

    //Define a quick Car class for the custom return type
    //you would want to put this in it's own class file probably
    public class Car
    {
        public string Make { get; set; }
        public string Model { get; set; }
        public string DisplayTitle { get; set; }
    }

    [ApiController]
    public class CarController : ControllerBase
    {
        private readonly ILogger<CarController> _logger;
        //this would be your Entity Framework Core context
        private readonly CarContext _context;

        public CarController(ILogger<CarController> logger, CarContext context)
        {
            _logger = logger;
            _context = context;
        }

        //... more stuff here ...

       /// <summary>
       /// Get car example
       /// </summary>
       [HttpGet]
       public IEnumerable<Car> Get()
       {
           //instantiate three query parameters to pass with the query
           //note the MySqlParameter type is because I'm using MySql
           MySqlParameter p1 = new MySqlParameter
           {
               ParameterName = "id1",
               Value = "25"
           };

           MySqlParameter p2 = new MySqlParameter
           {
               ParameterName = "id2",
               Value = "26"
           };

           MySqlParameter p3 = new MySqlParameter
           {
               ParameterName = "id3",
               Value = "27"
           };

           //add the 3 query parameters to an IEnumerable compatible list object
           List<MySqlParameter> queryParameters = new List<MySqlParameter>() { p1, p2, p3 };

           //note the extension is now easily accessed off the _context.Database object
           //also note for ExecuteSqlRawExt<Car, MySqlParameter>
           //Car is my return type "T"
           //MySqlParameter is the specific DbParameter type MySqlParameter type "P"
           List<Car> result = _context.Database.ExecuteSqlRawExt<Car, MySqlParameter>(
        "SELECT Car.Make, Car.Model, CONCAT_WS('', Car.Make, ' ', Car.Model) As DisplayTitle FROM Car WHERE Car.Id IN(@id1, @id2, @id3)",
        x => new Car { Make = (string)x[0], Model = (string)x[1], DisplayTitle = (string)x[2] },
        queryParameters);

           return result;
       }
    }
}

The query would return rows like:
"Ford", "Explorer", "Ford Explorer"
"Tesla", "Model X", "Tesla Model X"
The display title is not defined as a database column, so it wouldn't be part of the EF Car model by default.  I like this approach as one of many possible solutions. The other answers on this page reference other ways to address this issue with the [NotMapped] decorator, which depending on your use case could be the more appropriate approach.
Note the code in this example is obviously more verbose than it needs to be, but I thought it made the example clearer.

A: Actually you can create a generic repository and do something like this
public class GenericRepository<TEntity> : IGenericRepository<TEntity> where TEntity : BaseEntity
{
    private readonly DataContext context;
    private readonly DbSet<TEntity> dbSet;

    public GenericRepository(DataContext context)
    {
        this.context = context;
        this.dbSet = context.Set<TEntity>();
    }

    public IEnumerable<TEntity> ExecuteCommandQuery(string command)
        => dbSet.FromSqlRaw(command);

}

A: For Querying Data: Without existing Entity
               string query = "SELECT r.Name as roleName, ur.roleId, u.Id as userId   FROM dbo.AspNetUserRoles AS ur INNER JOIN dbo.AspNetUsers AS u ON ur.UserId = u.Id INNER JOIN dbo.AspNetRoles AS r ON ur.RoleId = r.Id ";

               ICollection<object> usersWithRoles = new List<object>();
                using (var command = _identityDBContext.Database.GetDbConnection().CreateCommand())
                {
                    command.CommandText = query;
                    command.CommandType = CommandType.Text;

                    await _identityDBContext.Database.OpenConnectionAsync();

                    using (var reader = await command.ExecuteReaderAsync())
                    {
                        while (await reader.ReadAsync())
                        {
                            usersWithRoles.Add(new {
                                roleName = reader.GetFieldValueAsync<string>(0).Result,
                                roleId = reader.GetFieldValueAsync<string>(1).Result,
                                userId = reader.GetFieldValueAsync<string>(2).Result
                            });
                        }
                    }
                }

Detailed:
 [HttpGet]
    [Route("GetAllUsersWithRoles")]
    public async Task<IActionResult> GetAllUsersWithRoles()
    {
        string query = "SELECT r.Name as roleName, ur.roleId, u.Id as userId   FROM dbo.AspNetUserRoles AS ur INNER JOIN dbo.AspNetUsers AS u ON ur.UserId = u.Id INNER JOIN dbo.AspNetRoles AS r ON ur.RoleId = r.Id ";
        try
        {
            ICollection<object> usersWithRoles = new List<object>();
            using (var command = _identityDBContext.Database.GetDbConnection().CreateCommand())
            {
                command.CommandText = query;
                command.CommandType = CommandType.Text;

                await _identityDBContext.Database.OpenConnectionAsync();

                using (var reader = await command.ExecuteReaderAsync())
                {
                    while (await reader.ReadAsync())
                    {
                        usersWithRoles.Add(new {
                            roleName = reader.GetFieldValueAsync<string>(0).Result,
                            roleId = reader.GetFieldValueAsync<string>(1).Result,
                            userId = reader.GetFieldValueAsync<string>(2).Result
                        });
                    }
                }
            }
                return StatusCode(200, usersWithRoles); // Get all users
        }
        catch (Exception e)
        {
            return StatusCode(500, e);
        }
    }

RESULT looks like this:
[
  {
    "roleName": "admin",
    "roleId": "7c9cb1be-e987-4ec1-ae4d-e4c9790f57d8",
    "userId": "12eadc86-6311-4d5e-8be8-df30799df265"
  },
  {
    "roleName": "user",
    "roleId": "a0d5ef46-b1e6-4a53-91ce-9ff5959f1ed8",
    "userId": "12eadc86-6311-4d5e-8be8-df30799df265"
  },
  {
    "roleName": "user",
    "roleId": "a0d5ef46-b1e6-4a53-91ce-9ff5959f1ed8",
    "userId": "3e7cd970-8c52-4dd1-847c-f824671ea15d"
  }
]

A: You can also use QueryFirst. Like Dapper, this is totally outside EF. Unlike Dapper (or EF), you don't need to maintain the POCO, you edit your sql SQL in a real environment, and it's continually revalidated against the DB. Disclaimer: I'm the author of QueryFirst.

A: I've came to this question because we have over 100 instances of entity-less usages of SqlQuery in Entity Framework 6 and so going the Microsoft suggested way(s) simply cannot not easily work in our case.
In addition, we had to maintain a single EF (Entity Framework 6) / EFC (Entity Framework Core 5) code base for several months, while migrating from EF to EFC. The code base is fairly large and it was simply impossible to migrate "overnight".
The answer below is based on great answers above and it is just a small extension to make them work for a few more edge cases.
First, for each EF based project we created an EFC based project (e.g. MyProject.csproj ==> MyProject_EFC.csproj) and inside all such EFC projects we defined a constant EFCORE. If you are doing a quick one-time migration from EF to EFC, then you don't need that and you can just keep what's inside #if EFCORE ... #else and remove what's inside #else ... #endif below.
Here is the main interop extension class.
using System;
using System.Collections.Generic;
using System.Threading;

#if EFCORE
using System.ComponentModel.DataAnnotations.Schema;
using System.Data;
using System.Data.Common;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.ChangeTracking;
using Microsoft.EntityFrameworkCore.Storage;
using Database = Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade;
using MoreLinq.Extensions;
#else
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
#endif

namespace YourNameSpace.EntityFrameworkCore
{
    /// <summary>
    /// Collection of extension methods to simplify migration from EF to EFC.
    /// </summary>
    public static class EntityFrameworkCoreInterop
    {
        /// <summary>
        /// https://stackoverflow.com/questions/6637679/reflection-get-attribute-name-and-value-on-property
        /// </summary>
        public static TAttribute? TryGetAttribute<TAttribute>(this PropertyInfo prop) where TAttribute : Attribute =>
            prop.GetCustomAttributes(true).TryGetAttribute<TAttribute>();

        public static TAttribute? TryGetAttribute<TAttribute>(this Type t) where TAttribute : Attribute =>
            t.GetCustomAttributes(true).TryGetAttribute<TAttribute>();

        public static TAttribute? TryGetAttribute<TAttribute>(this IEnumerable<object> attrs) where TAttribute : Attribute
        {
            foreach (object attr in attrs)
            {
                switch (attr)
                {
                    case TAttribute t:
                    {
                        return t;
                    }
                }
            }

            return null;
        }

        /// <summary>
        /// Returns true if the source string matches *any* of the passed-in strings (case insensitive)
        /// </summary>
        public static bool EqualsNoCase(this string? s, params string?[]? targets)
        {
            if (s == null && (targets == null || targets.Length == 0))
            {
                return true;
            }

            if (targets == null)
            {
                return false;
            }

            return targets.Any(t => string.Equals(s, t, StringComparison.OrdinalIgnoreCase));
        }

#if EFCORE
        public class EntityException : Exception
        {
            public EntityException(string message) : base(message)
            {
            }
        }

        public static TEntity GetEntity<TEntity>(this EntityEntry<TEntity> entityEntry)
            where TEntity : class => entityEntry.Entity;

        #region SqlQuery Interop

        /// <summary>
        /// kk:20210727 - This is a little bit ugly but given that this interop method is used just once,
        /// it is not worth spending more time on it.
        /// </summary>
        public static List<T> ToList<T>(this IOrderedAsyncEnumerable<T> e) =>
            Task.Run(() => e.ToListAsync().AsTask()).GetAwaiter().GetResult();

        private static string GetColumnName(this MemberInfo info) =>
            info.GetCustomAttributes().TryGetAttribute<ColumnAttribute>()?.Name ?? info.Name;

        /// <summary>
        /// See: https://stackoverflow.com/questions/35631903/raw-sql-query-without-dbset-entity-framework-core
        /// Executes raw query with parameters and maps returned values to column property names of Model provided.
        /// Not all properties are required to be present in the model. If not present then they will be set to nulls.
        /// </summary>
        private static async IAsyncEnumerable<T> ExecuteQuery<T>(this Database database, string query, params object[] parameters)
        {
            await using DbCommand command = database.GetDbConnection().CreateCommand();
            command.CommandText = query;
            command.CommandType = CommandType.Text;

            if (database.CurrentTransaction != null)
            {
                command.Transaction = database.CurrentTransaction.GetDbTransaction();
            }

            foreach (var parameter in parameters)
            {
                // They are supposed to be of SqlParameter type but are passed as objects.
                command.Parameters.Add(parameter);
            }

            await database.OpenConnectionAsync();
            await using DbDataReader reader = await command.ExecuteReaderAsync();
            var t = typeof(T);

            // TODO kk:20210825 - I do know that the code below works as we use it in some other place where it does work.
            // However, I am not 100% sure that R# proposed version does. Check and refactor when time permits.
            //
            // ReSharper disable once CheckForReferenceEqualityInstead.1
            if (t.IsGenericType && t.GetGenericTypeDefinition().Equals(typeof(Nullable<>)))
            {
                t = Nullable.GetUnderlyingType(t)!;
            }

            var lstColumns = t
                .GetProperties(BindingFlags.DeclaredOnly | BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic)
                .ToList();

            while (await reader.ReadAsync())
            {
                if (t.IsPrimitive || t == typeof(string) || t == typeof(DateTime) || t == typeof(Guid) || t == typeof(decimal))
                {
                    var val = await reader.IsDBNullAsync(0) ? null : reader[0];
                    yield return (T) val!;
                }
                else
                {
                    var newObject = Activator.CreateInstance<T>();

                    for (var i = 0; i < reader.FieldCount; i++)
                    {
                        var name = reader.GetName(i);
                        var val = await reader.IsDBNullAsync(i) ? null : reader[i];
                        var prop = lstColumns.FirstOrDefault(a => a.GetColumnName().EqualsNoCase(name));

                        if (prop == null)
                        {
                            continue;
                        }

                        prop.SetValue(newObject, val, null);
                    }

                    yield return newObject;
                }
            }
        }

        #endregion

        public static DbRawSqlQuery<TElement> SqlQuery<TElement>(this Database database, string sql, params object[] parameters) =>
            new(database, sql, parameters);

        public class DbRawSqlQuery<TElement> : IAsyncEnumerable<TElement>
        {
            private readonly IAsyncEnumerable<TElement> _elements;

            internal DbRawSqlQuery(Database database, string sql, params object[] parameters) =>
                _elements = ExecuteQuery<TElement>(database, sql, parameters);

            public IAsyncEnumerator<TElement> GetAsyncEnumerator(CancellationToken cancellationToken = new ()) =>
                _elements.GetAsyncEnumerator(cancellationToken);

            public async Task<TElement> SingleAsync() => await _elements.SingleAsync();
            public TElement Single() => Task.Run(SingleAsync).GetAwaiter().GetResult();
            public async Task<TElement> FirstAsync() => await _elements.FirstAsync();
            public TElement First() => Task.Run(FirstAsync).GetAwaiter().GetResult();
            public async Task<TElement?> SingleOrDefaultAsync() => await _elements.SingleOrDefaultAsync();
            public async Task<int> CountAsync() => await _elements.CountAsync();
            public async Task<List<TElement>> ToListAsync() => await _elements.ToListAsync();
            public List<TElement> ToList() => Task.Run(ToListAsync).GetAwaiter().GetResult();

        }
#endif
    }
}

and the usages are indistinguishable from the former EF usages:
public async Task<List<int>> GetMyResults()
{
    using var ctx = GetMyDbContext();
    const string sql = "select 1 as Result";
    return await ctx.GetDatabase().SqlQuery<int>(sql).ToListAsync();
}

where GetMyDbContext is a method to get your database context and GetDatabase is an one-liner interop that returns ((DbContext)context).Database for a given IMyDbContext : DbContext. This is to simplify simultaneous EF / EFC operations.
This works for primitive types (the example is above), entities, local classes (but not anonymous ones). Column renaming is supported via GetColumnName, but, ... it was already done above.

A: With Entity Framework 6 you can execute something like below

Create Modal Class as

Public class User
{
        public int Id { get; set; }
        public string fname { get; set; }
        public string lname { get; set; }
        public string username { get; set; }
}

Execute Raw DQL SQl command as below:
var userList = datacontext.Database.SqlQuery<User>(@"SELECT u.Id ,fname , lname ,username FROM dbo.Users").ToList<User>();

redpajama_set_name: RedPajamaStackExchange


Henrietta is a four month old blue bridle pup that we rescued from the Indianapolis animal shelter. She's a solid little hippo that found a pond to settle down in. Congratulations to her foster family for becoming her forever family!
Here's little Henrietta Hippo snoozing on the cool floor with her housemate.
After three hours of playing with her foster brother, Henrietta, finally shows signs of tiring down.
A very boston terrier shaped muzzle on Henrietta.
Oh darling, I love toys!


text:
BooksPaper Magician Trilogy
Breathe: Paper Magician Trilogy One Shots
By: cloudychelc
The oneshots focus mainly on Ceony x Emery, though there might be other tidbits of other ships or whatever comes to mind. Rated T for safety, though there's nothing wild. R&R! Cover by: breath-art on deviantart.
Rated: Fiction T - English - Romance/Fantasy - [Ceony T., Emery T.] - Chapters: 19 - Words: 41,427 - Reviews: 7 - Favs: 8 - Follows: 6 - Updated: 8/24/2020 - Published: 8/27/2017 - id: 12630193
1. Restless Evenings2. Blessings3. The Intoxicated Banquet4. What Was Once Theirs, Gone Forever5. Innuendos6. Nightmares7. Birthdays8. The Royal Family9. Unrequited10. Waiting11. Looking at a Goddess12. A Single Week and a Funeral13. Pastry Class14. Sleeping Arrangements15. The Music Magician16. Sleep, My Dear17. Forecast of the Future18. Midnight Companionship19. Thousand Cuts
We're just gonna pretend that Saraj did some damage to Ceony, enough to hurt at the end of the climax so we can get some nice angst and hurt/comfort.
Ceony exhaled a shaky breath as Emery spoke a spell she had never heard of, watching the life die within Saraj's eyes. She was bleeding and wounded in many different areas-Saraj wasn't the type to leave without a trace-and from her own spell usage of bursting glass. By grace she was glad Emery was mostly unharmed, save for some bruised areas and two wounds that could heal with time.
She solidified her promise to herself that he wasn't going to die here.
But she wasn't sure of her own well-being.
Saraj had used quite the amount of hair blades, along with some extra weapons she didn't know Excisioners could create. Not that she would know anyway. She managed to dodge the first few, but she still was cut in many areas, dress torn and body bruised blue.
Falling to her knees, Emery rushed to catch her before her head hit the ground. The pain throbbed insistently-something that she had ignored while fighting Saraj. The rush of adrenaline died down, creating new pain that she had never felt before. She understood emotional pain without qualm, but physical pain was a whole new division she had yet to truly learn.
"Ceony, Ceony, love-" For the first time, he looked panicked without even attempting to hide it. The coolness he tended to extrude had been thrown out for a new emotion on his face: fear. It was an emotion that tended to be brief and short, but for the most part he'd come to his senses without fail. Usually. The draft from the windows blew his hair in such a manner where his emerald eyes were constantly shrouded, but even in small glimpses , she could see wetness.
"You're talking like I'm going to die. Ah..." She laughed, groaning as a particular wound opened in a different direction. Muttering a curse, she watched him attempt his best way to staunch one deep wound on her abdomen, the raw and weeping flesh, seeping out red in waves from her movements. "I don't really think this whole Excisioner hunting is for me."
"I don't understand Ceony. I simply don't understand you." Emery said, applying pressure to the wound as if he had done it many times before. Maybe he had. She wasn't really sure of his past, besides the fact that he was in this line of work briefly when he was against Lira. "I explicitly told you not to do anything stupid. You do exactly that without fail. What am I supposed to do with you?"
"It got the job done, didn't it, Emery? Besides, you're equally as in trouble for the crime you're accusing me of." She asked, crying out slightly when she lifted her hand to his cheek. He grabbed hold of her wrist and she realized that he was trembling, his fingers sliding between her own to hold them.
"But that's not the point, Ceony. You're harmed! You could have died! You gave away the secrets to bond breaking to a dangerous criminal. Even though it didn't work in his favor-you did it without thinking, without tact, without any sort of judgement! Just like you always do!" Ceony's eyes widened slightly at his outburst, his voice raising in a manner that she had only seen once, maybe twice if she put her mind to it. "You could have died. I..."
It was rare for Emery to yell.
It was another thing to see him sob.
She had never seen him cry.
The way he cried had a rawness that she hadn't witnessed before, as though whatever wounds she was carrying, he mirrored, plus some more. It was the type of crying one would expect from one who had heard news that caused one to tremble and lose all sense of calm. He attempted to stifle it at first, but the thought of her dying already consumed him like a tsunami.
She tried to bring herself to think of their previous interactions, particularly within his heart that would provide a moment that he had sobbed in such a matter. There was nothing that immediately came to mind, but it wasn't easy to access her memories with such pain enveloping her every movement. She wondered briefly of the canyon she had seen in his heart, if it had expanded further due to this incident.
"Emery-" she attempted to wipe his tears with her other hand, even as her fresh wounds were moving in new directions. "I'm fine. Look at me. Stop looking at the blood, stop looking at the wounds. Look at me."
In a feat that Ceony knew was difficult for him, he moved his attention to her face. When he did, he was the textbook definition of grief and devastation, even if he didn't actually lose anything.
She recalled back when her siblings would get wounds and cuts from playing. As the bigger sister, she calmed them to placidity, enough to get them help for their wounds and to put them back to the world. Perhaps she could do the same for her heartbroken love.
"Breathe, Emery. Breathe like you're a brand new paper creation that was just told to do so." Ceony spoke in a tone she hadn't used in so long, one that demanded attention without necessarily forcing authority onto the listener. She watched him take her words without qualm, taking deep breaths as though he really was a brand new paper creation in her hands. "It's just blood. It hurts, yes, I openly admit to that. But it's going to be fine. Do you hear the sounds of the outdoors? Of the cars that I am sure carry help?" He only nodded. "Help is on the way. We made quite the ruckus, you and I. And Saraj, but we're the only people they could probably get upset at."
He laughed at that. Mirthless as it was, it kept him from sobbing.
"If I could take it from you, I would, you know that, my darling?" He lovingly moved a strand of stray ginger hair, "I would take all the pain from you if it meant you would be fine."
"I know. But I'm sure it'll be fine." She felt her eyelids becoming heavy, the room warping around her as though another distortion spell had been done. She could briefly hear the loud bash of a door and a man that sounded like Mg. Hughes calling her name.
Her eyes adjusted the bright lights when she opened them after what felt like an eternity. She blinked in an effort to adjust her vision, finding herself under the same ceiling from when she woke to some odd time ago after facing Grath.
The feelings were of equal, the same throb of her head, the stone feeling of being unable to move-it was reminiscent to that same time. From that, she deduced that Mg. Kilmer probably helped her yet again. She must find that man and thank him for both times, but it was less of her concern as she realized there were two other people with her.
"She's awake. Welcome back, Miss Twill, to the land of the living." Ceony managed to focus enough to attribute the voice to Mg. Aviosky. Had she been more focused, she would have said that Mg. Aviosky's tone betrayed a touch concern and relief-sounds Ceony would have never thought to hear from her.
"I died?" She questioned, her voice indicating dryness. Emery pushed a cup to her lips, which she drank from without question. The cold water made contact with her tongue-it was wonderful, inviting. She glanced up to him, seeing that he was patched up, worse for wear, but still fine as it was.
"Not exactly, that may be a bit of an exaggeration on my part." Mg. Aviosky absentmindedly adjusted her sleeves, "Mg. Kilmer used some spells to assist in your return, though we quite almost lost you there. Had we not gained a testimony from Mr. Bennet, along with the disturbance you two made, it would be quite a different story. Be glad that Criminal Affairs has quite the abundance of resources." Even when she was sure she was being scolded, she couldn't help but smile.
"I see." Ceony looked to Emery, who practically seemed like he was about to fall apart between his tight lips and white knuckles. He still extruded professionalism, leaning back against the wall, but Ceony knew better. "May I talk to Em- Magician Thane? I'd like to uhm...talk about something. But please don't leave, I do have more to tell you." Glancing between the two, Mg. Aviosky could have said something in objection but instead only nodded.
"Of course. I will be outside." Mg. Aviosky made her leave and the moment the door closed, he rushed straight for her bed, combing his hand through her unbraided ginger locks.
"Thank the heavens you're okay." He murmured, kiss her forehead in earnest, "You're the type of woman that makes me pray to God, Ceony."
"How long was I out?" She questioned, bringing herself to a sitting position. He sat at the edge of the bed, right next to her hip.
"Long. Similarly to last time, roughly ten days." He smiled, one of those smiles that were more than just in response-an true one. "Mg. Kilmer will have to finish up with you, but then you'll have to go back to the jurisdiction of Prit."
"The Excisioner, I take it?" She still didn't quite understand why Criminal Affairs carried such individuals in their employ, but she supposed that it couldn't be helped. The man still saved her life, twice.
"Binder, my dear." He took ahold of her hand, kissing her knuckles gently. "I do despise that I have to practically bring you back into Prit's hands. I've missed you."
"You miss my cooking." She clarified, smirking. She glanced at his frame. "You've lost weight. Are you only eating sandwiches again? You know, there are other foods out there."
"Perhaps. But I trust you more with a stove than myself, my dear. What I can create typically turns to inedible mush." They shared a laugh, the thought amusing to entertain. "But after that, everyone can finally call you Magician Twill. And I will be graced back with my dear."
"So sure, are you?" She quirked an eyebrow at him, to which he only grinned wider.
"I trained you myself, Ceony. Give me some credit here. Might I add that a measly test is nothing in comparison to what we have gone through these past years." He stood up, "And there won't be anything strange about our union any longer."
She returned his smile in equal favor. Someone knocked on the door, to which Emery returned back to his brooding position of professionalism against the wall to prevent any questions. She glanced at him, to which he merely winked and whispered, "Soon, my dear."

redpajama_set_name: RedPajamaCommonCrawl


in all categories where the query is *	and	the type_id is 35251739	and	the width is lt5.	The results are sorted in descending order by date last photographed.
It was most recently photographed on February 20, 2015.


Explore the numerous day-trip ideas around Maseru: Teyateyaneng (Ha Kome Cave Houses & Setsoto Design Gallery), Maletsunyane Falls (in Semonkong) and Gates of Paradise Pass (in Malealea). The adventure continues: take in the awesome beauty at Maluti Mountains, try your luck at Lesotho Sun Casino, take in the architecture and atmosphere at Our Lady of Victory Cathedral, and look for gifts at Thorkild Hand Weaving and Moteng Weavers.
To find other places to visit, reviews, maps, and more tourist information, read our Maseru sightseeing planner.
Port Elizabeth, South Africa to Maseru is an approximately 7.5-hour car ride. You can also fly. Expect a daytime high around 24°C in September, and nighttime lows around 15°C. You'll set off for home on the 20th (Wed).


text:
Kangana Ranaut dazzles at LFW in lehenga choli
IANS February 03, 2019 11:55 AM IST
Actress Kangana Ranaut showcases fashion designer Anushree Reddy's creation during Lakme Fashion Week (LFW) Summer/Resort 2019 in Mumbai on Saturday. (Photo: IANS)
Mumbai: Actress Kangana Ranaut says in pursuit of making her warrior film 'Manikarnika: The Queen of Jhansi', which is packed full of gravity defying stunts, she hasn't felt 'sexy' for a while.
But a welcome change came for Kangana when she dolled up in a feminine and elegant 'lehenga choli' by Anushree Reddy at the Lakme Fashion Week (LFW) Summer/Resort 2019 here on Saturday.
At a post-show conference, the actress told the media: "First of all, if I cough and it looks like I am going to die, please excuse me because I have got a very bad viral.
Actress Kangana Ranaut along with fashion designer Anushree Reddy (L) during Lakme Fashion Week (LFW) Summer/Resort 2019 in Mumbai on Saturday. (Photo: IANS)
"I love walking the ramp, and for Anushree... I love her clothes. I was telling her that for a while when I was doing this warrior film, I've not felt sexy for a while.
"The way she has dressed me up and the way she has done my hair, I feel very polished, chic and sexy at the same time. I am very happy to be here, and I just don't want to spread the cough virus around."
Kangana was also happy to talk about the love and appreciation that has come her way for 'Manikarnika...', but she refused to answer queries surrounding the controversies over the film out of respect for her commitment as a showstopper.
On woman power, Kangana, who is known for being fearless in expressing her views, said: "Women are very strong and that's why they do things which test them emotionally.
"Strength is not about muscles, because we are not in the age where we have to go and hunt. In today's time and age, what is your emotional strength, what is your mental strength... that is true strength."
MORE IN BEAUTY & FASHION


ARUP HAS snatched the multimillion pound detail design contract for Hong Kong's £455M record breaking Stonecutters Bridge from the original design competition winner.
A formal announcement from the Hong Kong Highways Department is expected tomorrow to confirm Arup and Danish subconsultant Cowi as winners.
Until the news leaked late last week it was widely believed that the Halcrow/Flint & Neill/Dissing + Weitling/Shanghai Municipal Engineering Design Group JV would win the detail design work, having won last year's first stage design competition (NCE 14 December 2000). The detail design contract also includes site supervision.
This is believed to be the first time that one structural engineer has taken over another engineer's design in this way.
A condition of the original competition was that design copyright would be assigned to the Hong Kong government.
'Obviously we're very disappointed, and we'll be asking the client to continue to acknowledge the authorship of the design, ' said Halcrow Group director of bridge engineering Roger Buckby.
Flint & Neill partner Ian Firth said that losing the detail design work was like 'giving birth to a beautiful child, then having to hand it over to foster parents'.
The original runners-up included a Scott Wilson/Leonhardt Andra JV and a joint venture built around top US bridge designer TY Lin International.
Among the runners-up Scott Wilson was shortlisted for the detail design phase, along with Mott Connell, which pre-qualified for the original design competition but was unsuccessful.
Arup did not enter the original competition as it acted with Cowi as advisers to the Highways Department during the original design competition.
With a central steel deck spanning 1,018m, the new crossing will be 128m longer than that of the the current record holder, Japan's Tatara Bridge.
The most unusual feature of the design is the choice of circular section single leg pylons nearly 300m high, with two fans of cables supporting the deck.
Concrete was chosen for the first 200m, with the upper section designed to be prefabricated in steel.
According to Buckby, the cost of tendering for the detail design stage has more than wiped out the £180,000 the Halcrow/ Flint& Neill JV received for winning the original design prize. 'But we entered with our eyes open, knowing the risk, so we can't really complain, ' he said.


The United Nations has indicated that Spain lacks the capacity to deal with the ongoing Europe-wide migrant surge, with some 9,300 individuals arriving in Spain midway through 2017. There is a need for increased social services, resources, and programs that help migrants to integrate into Spanish society and enter the formal economy. With this intention, the Cuinant Oportunitats (Cooking Opportunities) Program at Mescladis emerged, which is a culinary training program for migrants, most of whom have already passed through social institutions but struggle to find employment.
Planeterra worked with Mescladis, to provide them a link to a steady market of travellers to increase the impacts of their cooking classes offered to generate income for their programs. Cooking classes for travellers are conducted by students of the culinary school, Cuinant Oportunitats. The experience at Mescladis seeks to create a meeting point between cultures, using the kitchen and food that has been infused with the traditions and flavours of migrants' home countries as a stepping stone for discussion. More than 500 G Adventures travellers partake in this discussion and culinary experience annually.
"In Mescladis they have given me the will to do the training … and they told me we are going to work together, and we will fight together so that everything goes well. They were behind me, teaching me little by little, from cutting an onion. I learned that in this life we never, never, never have to lower our arms, we always have to fight. " – Idrissa, who works today at the CheeseMe Restaurant.


Listed share markets, which are the main drivers of growth fund performance, were mixed in November. Australian shares were down 0.7%, and while hedged international shares were up slightly at 0.7%, the appreciation of the Australian dollar (up 1¢ to US$0.72 over the month) meant that the return in unhedged terms was actually down 2.1%. Listed property also had a negative month, with Australian and global REITs down 2.8% and 1.2%, respectively.
Chant West director, Warren Chant says: "With only two weeks of the year left, and despite increasingly shaky investment markets, it's still likely that the median growth fund will produce another positive calendar year return. While it won't reach the heights of the past three years (12.8% in 2012, 17.2% in 2013 and 8.5% in 2014), it would still represent the sixth positive return in the past seven years and the eleventh in the past thirteen.
"A more subdued return this year isn't really a surprise. For some time, asset managers have been commenting that we're heading into a lower return / higher volatility environment. They believe that many asset sectors are now close to being fully valued, and say they're finding it harder to identify future sources of growth.
"Key themes that have affected global investment markets in 2015 include uncertainty over the timing of the US Federal Reserve's long-awaited first interest rate hike, slowing economic growth in China, falling commodity prices and monetary easing in Europe, Japan and China in response to concerns over deflation. Back at home in Australia, we've seen muted growth as the mining sector slumped further. In an attempt to boost our sluggish economy, the Reserve Bank lowered interest rates to a record low of 2%.
"The main things to keep an eye on over the next year will be the rate at which the Fed raises rates, and whether China is able to avoid a hard landing. Domestically, the extent to which non-mining sectors pick up will determine the degree to which the RBA might cut interest rates even further."
Note: The CPI figure for October and November 2015 are estimates.
Industry funds outperformed retail funds in November with a return of -0.2% versus -0.5%. Industry funds also hold the advantage over the longer term, having returned 6.9% per annum against 5.8% for retail funds over the 15 years to November 2015, as shown in Table 2.


text:
Blastomyces Resource: Review Treatment of Blastomycosis
Clinical Treatment and Monitoring
DECADES OF FUNGAL TESTING EXPERIENCE
Leaders in Fungal Diagnostics
MiraVista was founded by Dr. Joseph Wheat, a renowned infectious disease physician, who developed the first Histoplasma antigen test in 1986.
» Download PDF
Treatment of Blastomycosis in Dogs and Cats
Generic FDA approved itraconazole is the treatment of choice, 5 mg/kg twice daily for 3 days and then once daily (do not combine with terbinafine, unnecessary). See dosing for cats, differs from dogs.
Itraconazole should be administered with food.
Serum should be obtained for trough (just before dosage) itraconazole blood levels 2 weeks after starting treatment (do not combine with terbinafine-falsely elevated itraconazole levels in bioassay).
Itraconazole dosage should be adjusted to achieve trough levels of 2-7 mcg/mL.
Treatment could be stopped if (a) at least 6 months treatment, (b) clinical findings resolved, (c) imaging abnormalities resolved, (d) antigen levels urine are negative (or serum if they are higher than urine).
If criteria for stopping treatment or not met continue treatment for another 3 months and reassess criteria for stopping treatment.
Antigen levels in urine (or serum if they are higher than urine) should be tested at 6 and 12 months after stopping or if suspect relapse.
Hepatic enzymes and bilirubin should be measured at baseline, periodically during treatment and if hepatotoxicity is suspected.
Obtain consultation if these criteria have not been met by 12 months or you have other questions.
Several studies have evaluated fluconazole and itraconazole for treatment of blastomycosis in dogs and humans, but none have determined the best treatment or duration of treatment. Only two studies in dogs were prospective (Table 1). The itraconazole study evaluated 107 dogs that were treated for only two months and many of the dogs were severely ill, dying during the first week of treatment [1]. Among survivors, 39% relapsed. The prospective fluconazole study evaluated 21 dogs [2]. They were not severely ill and there were no deaths. However, 26% relapsed. In a retrospective study comparing itraconazole and fluconazole, 25% of dogs in the fluconazole group died within the first 2 weeks compared to 10% in the itraconazole group [3].
FDA approved itraconazole is recommended for treatment of blastomycosis in dogs and humans [4,5]. Generic FDA approved itraconazole is less expensive than Sporanox® and achieves similar concentrations in the blood [6,7]. Itraconazole capsules should be administered with food to achieve maximum blood levels. Compounded itraconazole powder should not be used, as blood levels are undetectable or very low. 4,6 Guidance for use of itraconazole for treatment of dogs with blastomycosis is reviewed below.
Life-Threatening Illness
Euthanasia may be avoided by an aggressive approach to life-threatening illness. Lipid or liposomal encapsulated (Abelcet® or Ambisome®) is recommended at a dosage of 1.0 mg/kg, three times weekly (or EOD) by intravenous infusion, over 4-6 hours for a cumulative dose up to 12 mg/kg (cat) or 24 mg/kg (dog) (Table 2). Low dose corticosteroids may reduce systemic toxicity caused by amphotericin B (fever, chills, malaise) and worsening of clinical signs related to inflammatory reaction to antigen released by dying fungal organisms. Renal function, electrolytes, and potassium levels should be monitored during treatment. Respiratory failure is the cause of death in most cases and supplemental oxygen is appropriate. Reasons that amphotericin B is more effective than itraconazole include immediate achievement of therapeutic blood levels and its fungicidal mode of action: itraconazole requires up to a week to reach therapeutic levels and is fungistatic.
Treatment Ocular Disease
The best treatment for ocular blastomycosis is uncertain. Some veterinary ophthalmologists prefer fluconazole because of higher penetration than itraconazole into ocular fluids and tissues [8]. However, studies in cats with ocular histoplasmosis reported response to itraconazole [9,10] In dogs voriconazole concentrations in aqueous humor are approximately 20% of that in blood, which due to the relative low MIC for blastomycosis might be effective. This study was performed in healthy dogs and it is possible that more drug enters the eye with inflammation.
Treatment CNS disease
Information on treatment of CNS blastomycosis is not available in veterinary patients. Initial treatment with a lipid or liposomal formulation of amphotericin B followed by fluconazole, itraconazole or voriconazole is recommended in humans [5]. In humans, voriconazole is preferred because of greater in vitro activity compared to fluconazole and good penetration into CSF.11 In dogs CSF concentrations are approximately 20% of that in blood, although CSF concentrations might under estimate brain tissue concentrations. In a review of CNS blastomycosis, in humans, outcome was favorable in 9 of 10 patients that received voriconazole after initial treatment with amphotericin B [11].
Itraconazole penetrates CSF poorly but achieves good concentration in brain tissue [8]. But CSF penetration may not be important for treatment of meningitis. Itraconazole was equally as effective as amphotericin B and more effective than fluconazole in an experimental model of Histoplasma meningitis and is recommended for treatment of meningitis in humans.12,13 Itraconazole and fluconazole were equally effective in a rabbit model of Coccidioides meningitis and itraconazole was effective as salvage treatment in patients who failed standard therapy for Coccidioides meningitis [14,15]
Combined Treatment with Terbinafine
Some veterinarians recommend terbinafine in combination with other antifungal agents in dogs failing treatment. In vitro activity has been demonstrated with MICs below 0.39 µg/ml in 90% of strains [16]. Pharmacokinetic studies demonstrate that blood levels exceed MICs of Blastomyces dermatitidis, Histoplasma capsulatum and Coccidioides immitis [17]. In vivo animal studies suggest terbinafine may be effective in treating histoplasmosis [18].
Role of anti-inflammatory treatment
A retrospective study reported that administration of steroids did not improve survival [19]. Of 139 dogs with pulmonary blastomycosis treated with corticosteroids and itraconazole, 61% survived at least 30 days. Of non-survivors, 27% were euthanized and the median time to death was 3 days (range 1-15 days). Studies in humans with acute respiratory distress syndrome (ARDS) showed no benefit from use of corticosteroids [20]. Anti-inflammatory treatment (low dose corticosteroid) is commonly used in veterinary medicine to reduce fever, malaise, and lethargy, hastening clinical improvement.
Generic FDA approved itraconazole, compounded FDA approved itraconazole capsules (see below), and brand name Sporanox capsules contain "pelletized" drug coated onto spheres and polyethylene glycol, which improves oral bioavailability. Itraconazole capsules should be administered with food for better absorption (see Sporanox capsule package insert). Sporanox® and Itrafungol® oral solutions contains cyclodextrin which improves bioavailability. Blood levels of itraconazole are similar with FDA approved brand name Sporanox® and generic FDA approved itraconazole [6]. Compounded itraconazole powder should not be used as blood levels are undetectable or very low [6].
Itraconazole should be administered 5 mg/kg twice daily for 3 days and then once daily in dogs [1]. In cats, the starting dose for itraconazole capsules is 10 mg/kg/day and for solution is 7.5 mg/kg/day. Itraconazole blood levels should be measured after 2 weeks in dogs and 3 weeks in cats to verify that levels are in the therapeutic range (2-7 mcg/mL). Dosage may need to be increased in puppies/kittens and adult dogs or cats that have lost considerable weight caused by the illness and regain weight during treatment: consider repeating blood levels 1-2 months intervals until weight stabilizes.
Small dogs pose challenges for use of 100 mg capsules. Alternatives include Sporanox solution (more expensive than generic itraconazole) and compounded pelletized itraconazole capsules. At least two veterinary pharmacies provide that service: Pet Health (623-214-2791); Pet Apothecary (414-247-8633). Prices for FDA approved itraconazole are presented in Table 4 but should be verified for your location. Alternatively, some veterinarians prescribe 100 mg generic FDA approved capsules and instruct the pet owners to empty the capsules onto a hard surface and divide the pellets into roughly equal size piles in dosages appropriate for the weight of the dog. They instruct the owners to coat the pellets onto peanut butter for administration. Finally, findings of a pharmacokinetic study support the use of 100 mg itraconazole capsules once every other day in cats [21].
Therapeutic drug level monitoring
It's important to obtain serum for trough (just before next dose) itraconazole blood level at the end of 2 weeks in dogs and 3 weeks in cats to verify than concentrations are between 2-7 mcg/mL. A dosage change is recommended if concentrations are outside that range. Blood levels should be determined again following a dosage change to verify levels between 2-7 mcg/mL. Itraconazole blood level testing measured by bioassay is offered at MiraVista Diagnostics.
At least 6 months of itraconazole is recommended in humans [5]. Although 3-6 months is recommended in dogs, 39% of dogs treated for 2 months relapsed, supporting treatment for at least 6 months, Table 3 [4]. Many cases require a year or more of treatment, especially those with bone, ocular, central nervous system involvement or widespread disseminated disease.
Toxicity and Drug Interactions
Toxicities are usually caused by high blood levels. A human study reported 31% of patients with levels below 17 µg/mL experienced toxicity compared to 86% with levels above 17.1 mcg/mL. Toxicity occurred in 20 to 40% of patients with levels between 5 and 10 mcg/mL and may occur with levels between 2-7 mcg/mL. Levels above 7 mcg/mL are unnecessary and dose reduction decreases toxicity and cost.
The most common toxicities observed in humans were fluid retention (21%) and gastrointestinal intolerance (21%) [22]. Central nervous system toxicity occurred in 19%. Diffuse nonpruritic maculopapular rash (7%) resolved after stopping treatment and may be caused by hypersensitivity rather than high blood levels. Hepatic toxicity with a bilirubin greater than 3 times the reference limit occurred in 2% of humans. Congestive heart failure occurred in 1%. Itraconazole also can cause hypertension and hypokalemia, although these have not been reported in dogs and cats (see Sporanox® and Itrafungol® package inserts).
Toxicities in dogs resemble those in humans. Median ALT levels were higher in dogs receiving 5 mg/kg twice daily (84 IU/L) than once daily (35 IU/L). ALT and ALP elevation in the absence of clinical findings of hepatotoxicity can be managed by dose reduction or discontinuation until they have resolved, after which itraconazole could be resumed at a lower dosage [1]. Ulcerative skin lesions (a sign of cutaneous vasculitis) also occurred in approximately 7% dogs receiving 10 mg/kg/d [1]. Itraconazole is a negative inotrope and should be used with caution in dogs and cats with significant heart disease.
Most toxicities resolve within a week or two after stopping or reducing the dose of itraconazole. Drug levels should be rechecked 2 weeks after resuming itraconazole to verify the level is therapeutic but nontoxic. Itraconazole can be resumed at a lower dose in dogs with clinical evidence of hepatotoxicity once clinical findings have resolved and ALT and ALP levels declined [1,23]. ALT, ALP, bilirubin, and itraconazole blood levels should be monitored closely if itraconazole is resumed.
Itraconazole inhibits cytochrome P450 3A4 isoenzymes and may increase levels of drugs cleared by that mechanism. Serious drug interactions, including death may occur when itraconazole is used with certain drugs that are cleared by P450 CYP3A4 [24]. Drugs that might be affected include amitriptyline, amlodipine, benzodiazepines, cisapride, corticosteroids, cyclosporine, ivermectin, and macrolides, to name a few.
Inducers of CYP3A4, such as phenobarbital, accelerate metabolism of itraconazole and may cause treatment failure because of subtherapeutic blood levels. Drugs that decrease gastric acid secretion reduce itraconazole blood levels. Review potential drug interactions in patients receiving medications that affect or are affected by hepatic metabolism.
Antigen monitoring
A prospective study assessed antigen clearance during treatment with fluconazole [2]. The Antigen concentrations decreased during treatment but there was no correlation between residual antigen concentration at discontinuation of treatment and the occurrence of relapse. The authors proposed criteria for stopping treatment: normal physical exam including fundic evaluation, normal or static chest radiographic findings, and to be conservative, a negative urine antigen. Obtain consultation if antigen levels are not declining after 3 months of treatment or if treatment must be extended beyond 12 months based on the above criteria.
Antigen should be tested in urine at least every 3 months during treatment, at 6 and 12 months after stopping treatment, and any time the clinical findings suggest recurrence. And if the urine antigen is "Above Limit of Quantification, ALQ" serum should be used for treatment monitoring instead. When the serum antigen is negative resume monitoring urine antigen until negative.
Alternatives to Itraconazole
Fluconazole is not recommended as a first-line treatment because in vitro activity against Blastomyces is inferior to that of itraconazole (Table 3). It should be noted that a retrospective study failed to detect a significant difference in survival or relapse rates between dogs with blastomycosis treated with itraconazole or fluconazole [3]. This suggests that fluconazole could be considered if itraconazole is not a viable option. Several new triazoles are available for treatment of patients unable to take itraconazole, but they are several-fold more expensive. Posaconazole is highly active against Blastomyces (Table 4) [25]. Posaconazole was more effective than itraconazole and equally as effective as amphotericin B in a murine model of blastomycosis [25]. Posaconazole was more effective than itraconazole in experimental models of histoplasmosis in immunocompetent and immunocompromised mice [26,27]. Four case reports in humans describe successful treatment with posaconazole in patients who could not take itraconazole because of adverse effects or insurance restrictions [28-30]. Itraconazole is the treatment of choice, and posaconazole may be the best alternative based on MICs and limited clinical experience. [4].
Cost for itraconazole treatment
Prices for FDA approved itraconazole are presented in Table 4 but should be verified for your location.
When to Stop Treatment
Treat for at least 6 months and until (1) clinical findings have resolved, (2) radiographic findings have resolved or improved significantly and are thought to represent residual scarring, and (3) antigen test is negative. If these criteria are not met, continue treatment for another 3 months and reevaluate. Obtain a consultation if the antigen concentration has not decreased after 3 months of treatment or remains positive after 12 months of treatment.
Legendre AM, Rohrbach BW, Toal RL, et al. Treatment of blastomycosis with itraconazole in 112 dogs. J Vet Intern Med 1996;10:365-371.
Foy DS, Trepanier LA, Kirsch EJ, et al. Serum and urine Blastomyces antigen concentrations as markers of clinical remission in dogs treated for systemic blastomycosis. J Vet Intern Med 2014;28:305-310.
Mazepa AS, Trepanier LA, Foy DS. Retrospective comparison of the efficacy of fluconazole or itraconazole for the treatment of systemic blastomycosis in dogs. J Vet Intern Med 2011;25:440-445.
Sykes JE and Merkel LK. Blastomycosis in Canine and Feline Infectious Disease. Sykes JE Ed. St. Louis, MO. Elsevier Saunders; 2019.
Chapman SW, Dismukes WE, Proia LA, et al. Clinical practice guidelines for the management of blastomycosis: 2008 update by the Infectious Diseases Society of America. Clin Infect Dis 2008;46:1801-1812.
Renschler J, Albers A, Sinclair-Mackling H, et al. Comparison of Compounded, Generic, and Innovator-Formulated Itraconazole in Dogs and Cats. J Am Anim Hosp Assoc 2018;54:195-200.
Mawby DI, Whittemore JC, Genger S, et al. Bioequivalence of orally administered generic, compounded, and innovator-formulated itraconazole in healthy dogs. J Vet Intern Med 2014;28:72-77.
Felton T, Troke PF, Hope WW. Tissue penetration of antifungal agents. Clin Microbiol Rev 2014;27:68-88.
Hodges RD, Legendre AM, Adams LG, et al. Itraconazole for the treatment of histoplasmosis in cats. J Vet Intern Med 1994;8:409-413.
Bromel C, Sykes JE. Histoplasmosis in dogs and cats. Clin Tech Small Anim Pract 2005;20:227-232.
Bariola JR, Perry P, Pappas PG, et al. Blastomycosis of the central nervous system: a multicenter review of diagnosis and treatment in the modern era. Clin Infect Dis 2010;50:797-804.
Haynes RR, Connolly PA, Durkin MM, et al. Antifungal therapy for central nervous system histoplasmosis, using a newly developed intracranial model of infection. J Infect Dis 2002;185:1830-1832.
Wheat LJ, Freifeld AG, Kleiman MB, et al. Clinical practice guidelines for the management of patients with histoplasmosis: 2007 update by the Infectious Diseases Society of America. Clin Infect Dis 2007;45:807-825.
Sorensen KN, Sobel RA, Clemons KV, et al. Comparison of fluconazole and itraconazole in a rabbit model of coccidioidal meningitis. Antimicrob Agents Chemother 2000;44:1512-1517.
Tucker RM, Denning DW, Dupont B, et al. Itraconazole therapy for chronic coccidioidal meningitis. Ann Intern Med 1990;112:108-112.
Shadomy S, Espinel-Ingroff A, Gebhart RJ. In-vitro studies with SF 86-327, a new orally active allylamine derivative. Sabouraudia 1985;23:125-132.
Sakai MR, May ER, Imerman PM, et al. Terbinafine pharmacokinetics after single dose oral administration in the dog. Vet Derm 2011;22:528-534.
Hay RJ. Therapeutic potential of terbinafine in subcutaneous and systemic mycoses. Br J Dermatol 1999;141 Suppl 56:36-40.
Walton RAL, Wey A, Hall KE. A retrospective study of anti-inflammatory use in dogs with pulmonary blastomycosis: 139 cases (2002-2012). J Vet Emerg Crit Care 2017;27:439-443.
Hough CL. Steroids for acute respiratory distress syndrome? Clin Chest Med 2014;35:781-795.
Middleton SM, Kubier A, Dirikolu L, et al. Alternate-day dosing of itraconazole in healthy adult cats. J Vet Pharmacol Ther 2016;39:27-31.
Lestner JM, Roberts SA, Moore CB, et al. Toxicodynamics of itraconazole: implications for therapeutic drug monitoring. Clin Infect Dis 2009;49:928-930.
Plumb D. Itraconazole. In Veterinary Drug Handbook, 9th ed. Stockholm, WI. Pharma Vet Inc.; 2018.
Dresser GK, Spence JD, Bailey DG. Pharmacokinetic-pharmacodynamic consequences and clinical relevance of cytochrome P450 3A4 inhibition. Clin Pharmacokinet 2000;38:41-57.
Sugar AM, Liu XP. In vitro and in vivo activities of SCH 56592 against Blastomyces dermatitidis. Antimicrob Agents Chemother 1996;40:1314-1316.
Connolly P, Wheat J, Schnizlein-Bick C, et al. Comparison of a new triazole antifungal agent, Schering 56592, with itraconazole and amphotericin B for treatment of histoplasmosis in immunocompetent mice. Antimicrob Agents Chemother 1999;43:322-328.
Connolly P, Wheat LJ, Schnizlein-Bick C, et al. Comparison of a new triazole, posaconazole, with itraconazole and amphotericin B for treatment of histoplasmosis following pulmonary challenge in immunocompromised mice. Antimicrob Agents Chemother 2000;44:2604-2608.
Proia LA, Harnisch DO. Successful use of posaconazole for treatment of blastomycosis. Antimicrob Agents Chemother 2012;56:4029.
Day SR, Weiss DB, Hazen KC, et al. Successful treatment of osseous blastomycosis without pulmonary or disseminated disease and review of the literature. Diagn Microbiol Infect Dis 2014;79:242-244.
Hussaini SMQ, Madut D, Tong BC, et al. Pulmonary blastomycosis presenting as primary lung cancer. BMC Infect Dis 2018;18:336.
Chapman SW, Rogers PD, Rinaldi MG, et al. Susceptibilities of clinical and laboratory isolates of Blastomyces dermatitidis to ketoconazole, itraconazole, and fluconazole. Antimicrob Agents Chemother 1998;42:978-980.
Li RK, Ciblak MA, Nordoff N, et al. In vitro activities of voriconazole, itraconazole, and amphotericin B against Blastomyces dermatitidis, Coccidioides immitis, and Histoplasma capsulatum. Antimicrob Agents Chemother 2000;44:1734-1736.
Wiederhold NP, Patterson HP, Tran BH, et al. Fungal-specific Cyp51 inhibitor VT-1598 demonstrates in vitro activity against Candida and Cryptococcus species, endemic fungi, including Coccidioides species, Aspergillus species and Rhizopus arrhizus. J Antimicrob Chemother 2018;73:404-408.
Clinical Diagnosis
Blastomycosis Algorithm
FAQ Blastomycosis
Testing For Blastomycosis
Case Example Antibody Testing Blasto & Histo
Blasto Antibody Testing
Blasto v Histo Antibody Testing
Blastomycosis Review
Blastomycosis Notes
Review Treatment of Blastomycosis
Monitoring Treatment Blasto & Histo
When to Stop Antifungal Treatment
Anti-Fungal Therapy
Itra v Flu Which to Choose
Posaconazole and Voriconazole
AmBisome® Protocol
Case Example Itraconazole TDM


text:
Q: Silverlight Object Binary Serialization to Database Right now I am programming a multiplayer card game in Silverlight
I am wondering how to store a object best binary in a sql database.
I have a GameState Object which contains the current state of a game between two players. I want to store this object in a sql database that both player can access and change it anytime.
How would you do that with Silverlight + RIA Services? Especially the part where you serialize the object in Silverlight.
Thanks

A: I would do the serialization on the server side.  Add an Invoke operation to your RIA services domain context that accepts your GameState object.  On the server side you can then use standard .NET serialization (personally I would recommend XML serialization instead of binary, but it shouldn't matter).

A: First, you can not possibly simply serialize something at the server. It must be serialized before it can be sent to the server. But it seems that perhaps you are making things too complicated/magical.
Given what you have said, I would start with by defining my GameState object (and any other object you need) inside the Entity Framework. Include any and all fields that are needed to save the state of the game. Then you should be able to have the framework create the needed tables.
Once you have done this, add a DomainService to the web project and when you compile the objects will then be available inside your Silverlight project.

A: Finally i decided to use XML serialization.
I found a great article about XML Serialization: http://www.ingebrigtsen.info/post/2008/11/29/Serialization-in-Silverlight.aspx
That's how it looks like in my Silverlight code:
public static class MySerializer
{
    public static string Serialize<T>(T data)
    {
        using (var memoryStream = new MemoryStream())
        {
            var serializer = new DataContractSerializer(typeof(T));
            serializer.WriteObject(memoryStream, data);

            memoryStream.Seek(0, SeekOrigin.Begin);

            var reader = new StreamReader(memoryStream);
            string content = reader.ReadToEnd();
            return content;
        }
    }

    public static T Deserialize<T>(string xml)
    {
        using (var stream = new MemoryStream(Encoding.Unicode.GetBytes(xml)))
        {
            var serializer = new DataContractSerializer(typeof(T));
            T theObject = (T)serializer.ReadObject(stream);
            return theObject;
        }
    }
}

A: I've found the SharpSerializer package very easy to use for fast binary serlization in Silverlight: http://www.sharpserializer.com/en/index.html


Lavanda's Double room offers one double or two twin beds (available on request), as well as, en suite bathroom with shower, hairdryer and shower products, TV with Czech and international channels, tea set. Free Wi-Fi is availble in the room and all public places. Extra bed is not available for this type of room.


text:
02 Regular (1)
02 Autoflowering (1)
Yield Indoor (g/m²)
02 Medium (301 - 400g/m²) (3)
03 High (401 - 500g/m²) (1)
Yield Outdoor (g/plant)
02 Medium (61 - 200g) (1)
03 High (200 - 500g) (3)
Flowering Time Indoor
08 weeks (1)
Harvest Month Outdoor
Life cycle (Auto)
First Lady | Indoor
The CannaBioGen collection: more than twenty years of travelling around the world in search of the holy grail, from the mountains of Jamaica and Colombia in the new world, to Pakistan, India and Thailand.
Meticulous selections from more than a hundred varieties and years of seed evaluations have culminated in magnificent specimens which provide us with a sublime range. Most varieties are traditional native crops from around the world with unique genetics which should be preserved. The best Dutch genetics have also been taken into account and hybrids of exquisite quality have been created so as to bring together the best in the world.
As a general rule, the following cultivation parameters are recommended: A pH of 6.2 in biological substrates is the most appropriate. The optimum pH in hydroponics is 5.8 and an EC of 1.2 to 1.8 Ms/cm2. The recommended relative humidity is 50% to 60%, and may be slightly higher during the growing season. A constant temperature of 22ºC to 26ºC is recommended for a high production of cannabinoids.
At CannaBioGen, we select the seeds one by one, testing the germination of the batches every three months. Most failures are due to the decay of the embryo by bacteria and fungi in the culture media and excess water. The seeds should be germinated in sterile media and substrates. The seeds should be treated with fungicide, and failing that, sterile water should be used. The temperature must be between 21ºC to 24ºC preferably. The plants are overmatured in order to obtain a harvest of seeds under the best conditions, and the remaining plant matter is destroyed. CannaBioGen is the first seed bank to set an expiry date on the seeds. If the seeds have germination problems, the batch is checked and the seeds are replaced by others.
€35.20 €44.00 -20 % In Stock
Auto CBG | Feminised, Auto, Indoor & Outdoor
€35.20 €44.00 -20 %
€60.00 Out of stock
Destroyer | Feminised, Indoor & Outdoor
Destroyer | Indoor & Outdoor
Hash Fruit | Feminised, Indoor & Outdoor


text:
Foreign languages schools
ACTIVE ENGLISH SCHOOL
Foreign languages schools Belgrade
Address: 28 Svetog Save st., Vracar
Phone: +381 11 2436 745, +381 63 8289 964
E-mail: activenglishschool@gmail.com
Website: www.activenglishschool.com/sr/skole-engleskog-jezika-u-beogradu
Like I was here Report an error! Send a message
Sunday We are closed
Active English School was founded in 2000 by native English-speaking ESOL* teachers from Britain. Our aim has always been that each of our students should have the knowledge which enables them to gain at least one of the most widely accepted, internationally recognised, English language certificates as an aid to employment and/or further education at home or abroad.
*English for speakers of other languages
The University of Cambridge ESOL examinations require a high standard of English. Exam candidates need to be skilled in speaking, writing, listening, reading and use of English. Active English School's standards, therefore, are in line with those demanded by Cambridge and, as a result, we are proud to say that we have achieved a 100% pass rate at FCE (First Certificate in English), CAE (Certificate in Advanced English) and CPE (Certificate of Proficiency in English).
Although we take students of any age, we know that the most effective way to achieve the high level of English language knowledge needed in today's world is for children to grow up with the language, use it in context and eventually to think in English. Our youngest students, therefore, start with us from the age of four.
Our four and five year-olds spend one hour a week with us. They learn that English is fun and make a start on their vocabulary and listening skills.
At six years old they spend one-and-a-half hours a week with us, they will be familiar with the alphabet and start to read and write words. They will extend their vocabulary and listening comprehension skills.
By nine, ten or eleven years old they will have learned the basics of reading and writing in English, started to tackle the complexities of English spelling, simple grammar learnt in context and improved their speaking and listening comprehension skills. They will then be ready to spend three hours a week with us tackling a systematic approach to grammar, concentrate on their writing and further develop their speaking, listening and reading.
As teenagers and university students, they will also be trained in study skills which not only help them to pass examinations in English but also help with their own studies.
Learning English properly is a commitment from both students and teachers alike. It pays dividends however, as in today's world of instant global communication, being able to speak and write English is a necessity.
'If it wasn't for the English course I did with you ten years ago, and the exam I passed, I wouldn't have got my job or been able to do an MBA in Edinburgh. I'm now finance manager of the Belgrade office of a well-known international pharmaceutical firm. Your school is unique, that's why I want my daughter to learn English with you.'
Lana Vukovic
Through an administrative ban / installment