Skip to content

Instantly share code, notes, and snippets.

@Kayli
Last active December 14, 2016 16:00
Show Gist options
  • Save Kayli/fc1679abc667390e2d7c3cad74d49cf5 to your computer and use it in GitHub Desktop.
Save Kayli/fc1679abc667390e2d7c3cad74d49cf5 to your computer and use it in GitHub Desktop.
database query using EF
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="Default" connectionString="Server=localhost;Database=RegoV2;Persist Security Info=True;integrated security=false;User Id=sa; Password=sa;" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
class Program
{
static void Main(string[] args)
{
var context = new DbContext(ConfigurationManager.ConnectionStrings["Default"].ConnectionString);
var records = context.Database.SqlQuery<SomeTableRecord>("select Id, Name from SomeTable").ToArray();
}
}
class SomeTableRecord
{
public int Id { get; set; }
public string Name { get; set; }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment