Skip to content

Instantly share code, notes, and snippets.

View hbulens's full-sized avatar

Hendrik Bulens hbulens

6 followers · 4 following
View GitHub Profile
@hbulens
hbulens / 2015-05-26-developing-real-time-applications-with-signalr-and-sqldependency-in-asp-net-mvc-and-c_003.cshtml
Last active January 13, 2018 18:39
<div class="row">
<div class="col-md-12">
<div id="messagesTable">
</div>
</div>
</div>
@section scripts
{
<script src="~/Scripts/jquery.signalR-2.2.0.min.js"></script>
@hbulens
hbulens / 2015-05-26-developing-real-time-applications-with-signalr-and-sqldependency-in-asp-net-mvc-and-c_002.cs
Created January 13, 2018 18:32
using Microsoft.AspNet.SignalR;
using Microsoft.AspNet.SignalR.Hubs;
public class ChatHub : Hub
{
[HubMethodName(&quot;sendMessages&quot;)]
public static void SendMessages()
{
IHubContext context = GlobalHost.ConnectionManager.GetHubContext&lt;ChatHub&gt;();
context.Clients.All.updateMessages();
@hbulens
hbulens / 2015-05-26-developing-real-time-applications-with-signalr-and-sqldependency-in-asp-net-mvc-and-c_001.cs
Created January 13, 2018 18:31
string connectionString = Settings.Default.ConnString;
string listenQuery = @ & quot;
SELECT[Name] FROM[dbo].[Insurers] & quot;;
// Create instance of the DB Listener
DatabaseChangeListener changeListener = new DatabaseChangeListener(connectionString);
// Define what to do when changes were detected
changeListener.OnChange += () =>
{
@hbulens
hbulens / 2015-05-05-c-and-the-wordpress-api_001.cs
Created January 13, 2018 18:29
public IEnumerable GetWordPressPosts()
{
using(WebClient webClient = new WebClient())
{
string blogUrl = @ "https://public-api.wordpress.com/rest/v1.1/sites/hendrikbulens.wordpress.com/posts/";
string response = webClient.DownloadString(blogUrl);
WordPressBlog blogPosts = JsonConvert.DeserializeObject(response);
IEnumerable posts = blogPosts.posts.OrderByDescending(x => x.date).Take(3).Select(x => new BlogPost() {
Title = x.title,
@hbulens
hbulens / 2015-04-28-tutorial-on-creating-loosely-coupled-applications-with-mef_003.cs
Created January 13, 2018 18:25
T item = container.GetExportedValue()
@hbulens
hbulens / 2015-04-28-tutorial-on-creating-loosely-coupled-applications-with-mef_002.cs
Created January 13, 2018 18:24
AggregateCatalog catalog = new AggregateCatalog();
// Add all the parts found in all assemblies in
// the same directory as the executing program
catalog.Catalogs.Add(
new DirectoryCatalog(
Path.GetDirectoryName(
Assembly.GetExecutingAssembly().Location )
)
@hbulens
hbulens / 2015-04-28-tutorial-on-creating-loosely-coupled-applications-with-mef_001.cs
Created January 13, 2018 18:24
[Export(typeof(IRepository<>))]
[PartCreationPolicy(CreationPolicy.NonShared)]
@hbulens
hbulens / 2015-04-28-c-firing-code-after-database-changes-with-sqldependency-it_002.cs
Created January 13, 2018 18:21
public class DatabaseChangeListener
{
#region Constructor
public DatabaseChangeListener(string connectionString)
{
this.connectionString = connectionString;
SqlDependency.Stop(connectionString);
SqlDependency.Start(connectionString);
connection = new SqlConnection(connectionString);
@hbulens
hbulens / 2015-04-28-c-firing-code-after-database-changes-with-sqldependency-it_001.cs
Created January 13, 2018 18:19
class Program
{
static void Main(string[] args)
{
string connectionString = Settings.Default.ConnString;
var changeListener = new DatabaseChangeListener(connectionString);
changeListener.OnChange += () => {
Console.WriteLine("There was a change");
changeListener.Start(@ "SELECT [Name] FROM [dbo].[Cars]");
};
@hbulens
hbulens / 2015-04-27-creating-sql-schemas-using-entity-framework-code-first_002.cs
Created January 13, 2018 18:16
public static void ProvisionTenant(string tenantSchema, DbConnection connection)
{
using(DbContext ctx = Create(tenantSchema, connection))
{
if (!ctx.Database.Exists())
{
ctx.Database.Create();
}
else
{