Cross-Platform EF6 with .NET Core 3.0!

Thu, 01 Aug 2019 10:00:00 GMT

Even if you don’t want to mess with your stable Entity framework 6 production code, you might like to port it from .NET to .NET Core 3.0 to take advantage of the many benefits of .NET Core -- especially its cross-platform talents. To demonstrate, Julie Lerman creates a new ASP.NET Core 3.0 API with EF6.3 on her MacBook, in macOS, using Visual Studio Code, and then deploys it to a Linux-based Docker container.

Read article

EF Core in a Docker Containerized App, Part 3

Mon, 03 Jun 2019 10:00:00 GMT

In the final installment of her series on using EF Core and Docker together to build a containerized app and add a data persistence mechanism, Julie Lerman integrates a dedicated, containerized SQL Server into her API development.

Read article

EF Core in a Docker Containerized App, Part 2

Wed, 01 May 2019 10:00:00 GMT

In the second in a series on using EF Core and Docker together to build a containerized app and add a data persistence mechanism, Julie Lerman looks at production-worthy solutions for targeting SQL Server when publishing an API inside of a Docker image.

Read article

EF Core in a Docker Containerized App

Mon, 01 Apr 2019 10:00:00 GMT

Given the time she’s spent learning about EF Core and Docker, Julie Lerman thought it wouldn’t be too difficult to use them together to build a containerized app and add a data persistence mechanism. It turned out to be harder than she thought. Learn how and why, and use her experiences to ease your pain.

Read article

A Peek at the EF Core Cosmos DB Provider Preview, Part 2

Fri, 01 Mar 2019 10:00:00 GMT

Julie Lerman continues her exploration of the Cosmos DB provider preview in EF Core, with a discussion of some more advanced features, including configuring containers, integrating owned entities into the mix, and using logging to check out some of the SQL and other actions generated from the API.

Read article

Exploring the Multi-Model Capability of Azure Cosmos DB Using Its API for MongoDB

Fri, 01 Feb 2019 10:00:00 GMT

In an effort to gain a better understanding of the Azure Cosmos DB multi-model capability, as well as to have a bit of fun checking out a new database, Julie Lerman takes a look at the Cosmos DB API for MongoDB.

Read article

A Peek at the EF Core Cosmos DB Provider Preview

Wed, 02 Jan 2019 10:00:00 GMT

In the first of a two-part series, Julie Lerman takes a look at the Cosmos DB provider preview in EF Core, discussing some of the basics, including getting the provider into your solution, letting EF Core create the Cosmos DB database, and storing data into a collection.

Read article

Collaborative Development with Visual Studio Live Share

Wed, 19 Dec 2018 10:00:00 GMT

Visual Studio Live Share lets groups of developers collaborate in real time on code projects, even if they use different operating systems and languages, and even if they are miles apart. The minimal amount of data transfer during sessions ensures quick and easy sharing, and each developer gets to work in the environment of their choice.

Read article

Manage Data Across Multiple Sources with Azure Data Studio

Sat, 01 Dec 2018 10:00:00 GMT

Azure Data Studio, now the official name of SQL Operations Studio, was released in September. The biggest news regarding the release is the extensions that are now available, as Julie Lerman describes.

Read article

Logging SQL and Change-Tracking Events in EF Core

Mon, 01 Oct 2018 10:00:00 GMT

Julie Lerman introduces you to the new logging APIs in .NET Core, concentrating on SQL and change-tracking events, with a focus on providers that output to the console and the debugger.

Read article

Deep Dive into EF Core HasData Seeding

Wed, 01 Aug 2018 10:00:00 GMT

The ability to seed data when running migrations disappeared in in the transition from EF6 to EF Core. Now EF Core 2.1 brings a new mechanism that’s a nice improvement over the workflow that existed in earlier versions of Entity Framework.

Read article

EF Core 2.1 Query Types

Mon, 02 Jul 2018 10:00:00 GMT

Julie Lerman delves into the new EF Core 2.1 Query Type feature, which lets you more easily query a database without needing true entities with key properties to consume the results.

Read article

Replacing a Bulky API with Azure Functions

Fri, 01 Jun 2018 10:00:00 GMT

Julie Lerman updates some old NodeJS Web APIs that worked with Azure DocumentDB to take advantage of Azure Functions and Cosmos DB and realizes she can eliminate a whole lot of the code. Learn how that’s possible.

Read article

EF Core 2 Owned Entities and Temporary Work-Arounds

Sun, 01 Apr 2018 10:00:00 GMT

The current version of EF Core doesn’t allow properties based on value objects to be null, and there’s no way to replace properties that contain a value object. Julie Lerman presents work-arounds that let you get past these temporary limitations.

Read article

Calling Azure Functions from the Universal Windows Platform

Thu, 01 Mar 2018 10:00:00 GMT

In the final column in this series, you’ll see how to make requests from the UWP application to previously created Azure functions both to send game scores and to receive and display top scores for the player across all of her devices as well as top scores for all players around the globe.

Read article

Creating Azure Functions That Can Read from Cosmos DB with Almost No Code

Thu, 01 Feb 2018 10:00:00 GMT

In the third column in this series, Julie Lerman shows you how to create the Azure functions that will respond to a request to retrieve two sets of score data from users playing the CookieBinge game locally and around the world.

Read article

Creating Azure Functions to Interact with Cosmos DB

Mon, 01 Jan 2018 10:00:00 GMT

In the second column in a series, Julie Lerman updates her Cookie Binge app. This time she shows you how to take advantage of Azure Functions to hook up your app with Azure Cosmos DB.

Read article

SQL Operations Studio: Cross-Platform SQL Server Management

Fri, 15 Dec 2017 10:00:00 GMT

Take a tour of the new SQL Operations Studio, a free, standalone tool that works with Azure SQL Database, Azure SQL Data Warehouse and SQL Server running anywhere. Even better—it’s cross-platform!

Read article

Building UWP Apps for Local and Cloud Data Storage

Fri, 01 Dec 2017 10:00:00 GMT

Julie Lerman begins a two-part series in which she updates her CookieBinge app in order to demonstrate that EF Core can now work directly on a device because it now relies on .NET Standard, not the full .NET Framework, and the Universal Windows Platform (UWP) supports .NET Standard. Now you can store your UWP app data on a device or in the cloud.

Read article

DDD-Friendlier EF Core 2.0, Part 2

Sun, 01 Oct 2017 10:00:00 GMT

Julie Lerman continues her discussion of EF Core 2.0 features that align nicely with Domain-Driven Design (DDD) principles, this time evolving the classes to look more like what you’d write for a real-world implementation of DDD patterns.

Read article

DDD-Friendlier EF Core 2.0

Fri, 01 Sep 2017 10:00:00 GMT

Learn how EF Core 2.0 understands one-to-one uni-directional relationships and how it can persist data from entities where scalar, navigation and collection properties are fully encapsulated. You’ll also see how to use value objects in your domain model and how to persist those as well.

Read article

On-the-Fly SQL Servers with Docker

Sat, 01 Jul 2017 10:00:00 GMT

Julie Lerman shows you a simple way to share a pre-configured database along with a SQL Server across your team, allowing everyone to have a locally running server and a local copy of the database. And, because you’re doing it all with a container, nobody needs to install SQL Server on their computer or execute any scripts to get the database set up for use.

Read article

Visual Studio Code: Create a Database IDE with MSSQL Extension

Thu, 01 Jun 2017 10:00:00 GMT

Julie Lerman shows how you can turn VS Code into a smart IDE for a variety of SQL Server databases—Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse—by taking advantage of the mssql extension.

Read article

Tips for Building Tests with EF Core and Its InMemory Provider

Sat, 01 Apr 2017 10:00:00 GMT

The new EF Core InMemory provider can prove useful when your tests don’t require actual database interaction. Julie Lerman provides an introduction to this handy tool and shares some tips and tricks about creating automated tests with EF Core she discovered while learning to use it.

Read article

First Look at Azure Search—a Handheld Walk-Through

Wed, 01 Feb 2017 10:00:00 GMT

Julie Lerman explores Azure Search, a service that lets you use Microsoft’s processing and intelligence to add sophisticated search capabilities to your own data.

Read article

EF Core 1.1: A Few of My Favorite Things

Sun, 01 Jan 2017 10:00:00 GMT

Julie Lerman explores the latest version of Entity Framework Core—the 1.1 Preview—taking note of fixes, additions that bring it closer to EF6, and some brand new capabilities.

Read article

CQRS and EF Data Models

Tue, 01 Nov 2016 10:00:00 GMT

Command Query Responsibility Segregation (CQRS) is a pattern that has a lot of benefits—and some drawbacks—when you’re defining data models with Entity Framework. Julie Lerman explains why it’s worth considering.

Read article

Run EF Core on Both .NET Framework and .NET Core

Sat, 01 Oct 2016 10:00:00 GMT

Entity Framework Core (EF Core) is the newest version of EF and runs equally well on both the full .NET Framework and the cross-platform .NET Core. Julie Lerman walks you through two projects that explore how to use EF Core in APIs and applications that run across both frameworks.

Read article

EF Core Change-Tracking Behavior: Unchanged, Modified and Added

Mon, 01 Aug 2016 10:00:00 GMT

Julie Lerman examines how the change-tracking behavior of Entity Framework Core differs from that of EF6, pointing out that while much of the syntax and behavior has been replicated, EF Core is a brand new API and should be treated accordingly.

Read article

The New Azure DocumentDB Node.js SDK

Fri, 01 Jul 2016 10:00:00 GMT

Over the past year, Julie Lerman has been developing a sample app that uses Aurelia on the front end, a server-side API written in Node.js, and Azure DocumentDB for its data store. But all these parts have changed, so it’s time for an update.

Read article

Dapper, Entity Framework and Hybrid Apps

Sun, 01 May 2016 10:00:00 GMT

A popular micro-ORM called Dapper can help solve performance issues, and you don’t have to give up Entity Framework to take advantage of it. Julie Lerman explains how hybrid apps may be just what you need.

Read article

Handling the State of Disconnected Entities in EF

Fri, 01 Apr 2016 10:00:00 GMT

Julie Lerman looks at the enduring problem of disconnected data and presents a simple recipe for dealing with it in EF6 and the upcoming EF Core.

Read article

Refactoring an ASP.NET 5/EF6 Project and Dependency Injection

Mon, 01 Feb 2016 10:00:00 GMT

Taking advantage of the dependency injection capabilities in ASP.NET 5--recently renamed ASP.NET Core 1.0--Julie Lerman refactors an existing EF6 solution to leverage an IoC container that makes it easier to inject object instances into logic that needs to use them.

Read article

EF7 Migrations: Not New but Definitely Improved

Fri, 01 Jan 2016 10:00:00 GMT

Code First Migrations has undergone some dramatic changes with Entity Framework 7. The workflow is much cleaner and more straightforward, and source control is far easier, as Julie Lerman explains.

Read article

Aurelia Meets DocumentDB: A Matchmaker’s Journey, Part 2

Tue, 01 Dec 2015 10:00:00 GMT

In the second of her two-part series detailing the difficulties in learning how to useDocumentDB and the Aurelia framework together, Julie Lerman presentsthe path to the solution that ultimately proved successful.

Read article

Aurelia Meets DocumentDB: A Matchmaker’s Journey

Sun, 01 Nov 2015 10:00:00 GMT

After exploring both DocumentDB and the new Aurelia framework, Julie Lerman decided it was time to use them together, but that proved more difficult than expected. Learn how she finally found the path to the correct solution.

Read article

Revisiting JavaScript Data Binding -- Now with Aurelia

Tue, 01 Sep 2015 10:00:00 GMT

Julie Lerman has long been a fan of the Knockout JavaScript framework and its data binding talents. Here she explores the new Aurelia framework, which is quickly gaining momentum with Web developers, and finds that it offers a lot to like for data-oriented programmers.

Read article

Explore Entity Framework Behavior at the Command Line with Scriptcs

Wed, 01 Jul 2015 10:00:00 GMT

Julie Lerman learns how to explore Entity Framework behavior interactively using Scriptcs.

Read article

An Overview of Microsoft Azure DocumentDB

Mon, 01 Jun 2015 10:00:00 GMT

Julie Lerman takes a first look at the Microsoft entry into the document database field—Azure DocumentDB.

Read article

Data Points - The EF6, EF7 and ASP.NET 5 Soup

Fri, 01 May 2015 10:00:00 GMT

Julie Lerman discusses the difference between the next version of .NET and what ASP.NET 5 apps will run on, then explains how Entity Framework 6 and Entity Framework 7 fit into the mix.

Read article

Data Points - EF6 Code First Migrations for Multiple Models

Wed, 01 Apr 2015 10:00:00 GMT

The new support for Code First Migrations in Entity Framework 6 makes it easier to store data for multiple models in a single database. But that support may not be what you imagine. Julie Lerman explains what this feature does and doesn’t do, and how to use it.

Read article

Data Points - Looking Ahead to Entity Framework 7

Fri, 02 Jan 2015 10:00:00 GMT

In this first look at EF7, Julie Lerman discusses what EF7 will bring to developers, the motivations behind decisions being made about the framework, and what this version means to existing apps that use EF6 or earlier.

Read article

Data Points - A Pattern for Sharing Data Across Domain-Driven Design Bounded Contexts, Part 2

Mon, 01 Dec 2014 10:00:00 GMT

Julie Lerman continues her exploration of sharing data across DDD bounded contexts using a publish-subscribe pattern by looking into when it makes sense to publish messages.

Read article

Data Points - A Code First Migrations Mystery: Solved

Mon, 03 Nov 2014 10:00:00 GMT

Julie Lerman solves the mystery of why a friend’s Microsoft Azure database migrated automatically.

Read article

Data Points - A Pattern for Sharing Data Across Domain-Driven Design Bounded Contexts

Wed, 01 Oct 2014 10:00:00 GMT

Julie Lerman explores a way to mirror data as one scenario for sharing data across DDD bounded contexts.

Read article

Data Points - Git: It’s Just Data!

Tue, 02 Sep 2014 10:00:00 GMT

Julie Lerman had struggled with Git, until a colleague showed her that Git is really just a database. Follow along as Julie explores the lower level plumbing commands of the Git source control system.

Read article

Data Points - Cool (and Free) Tools for Entity Framework

Fri, 01 Aug 2014 10:00:00 GMT

Julie Lerman highlights some handy, community-based tools that can enhance your productivity with Entity Framework.

Read article

Data Points - Tips for Updating and Refactoring Your Entity Framework Code, Part 2

Tue, 01 Jul 2014 10:00:00 GMT

Julie Lerman breaks out a small Entity Data Model and, using that model, works through some of the problems you might encounter when switching from the ObjectContext API to the newer DbContext API.

Read article

Data Points - Tips for Updating and Refactoring Your Entity Framework Code

Thu, 01 May 2014 10:00:00 GMT

Updating to a new version of Entity Framework and refactoring your code presents some real challenges. Julie Lerman’s tips can help ease the pain.

Read article

Data Points - Adding New Life to a 10-Year-Old ASP.NET Web Forms App

Tue, 01 Apr 2014 10:00:00 GMT

Legacy code: can’t live with it, can’t live without it.Julie Lerman figures out how to update an old ASP.NET WebForms app using Knockout.js and Breeze.

Read article

Data Points - Data, Meet My Friend, F#

Mon, 03 Feb 2014 10:00:00 GMT

Julie Lerman explores functional languages and finds that they’re really good at working with sets of data.

Read article

Data Points - Data, Meet My Friend, F#

Mon, 03 Feb 2014 10:00:00 GMT

Julie Lerman explores functional languages and finds that they’re really good at working with sets of data.

Read article

Data Points - Code First Goodies in Entity Framework 6

Thu, 02 Jan 2014 10:00:00 GMT

Julie Lerman rounds out her coverage of Entity Framework 6 with a discussion of new Code First features relating to mappings and migrations.

Read article

Entity Framework - Entity Framework 6: The Ninja Edition

Mon, 02 Dec 2013 10:00:00 GMT

Entity Framework 6 is no longer part of the .NET Framework—and it’s open source, Find out what else is new as Julie Lerman takes you for a tour.Julie Lerman explores Entity Framework 6.0, which introduces key new features of Microsoft object relational mapping solution.

Read article

Data Points - Coding for Domain-Driven Design: Tips for Data-Focused Devs, Part 3

Tue, 01 Oct 2013 10:00:00 GMT

Julie Lerman explores two important technical patterns of Domain Driven Design (DDD) coding--unidirectional relationships and the importance of balancing tasks between an aggregate root and a repository--and how they apply to the Object Relational Mapper (ORM), Entity Framework.

Read article

Data Points - Coding for Domain-Driven Design: Tips for Data-Focused Devs, Part 2

Mon, 02 Sep 2013 10:00:00 GMT

In the second column in her series on Domain Driven Design, Julie Lerman shares more tips for data-first developers who are interested in benefiting from some of the coding patterns of DDD.

Read article

Data Points - Coding for Domain-Driven Design: Tips for Data-Focused Devs

Thu, 01 Aug 2013 10:00:00 GMT

Domain Driven Design can help handle complex behaviors when building software. But for data-driven devs, the change in perspective isn’t always easy. Julie Lerman shares some pointers that helped her get comfortable with DDD.

Read article

Data Points - Behavior-Driven Design with SpecFlow

Mon, 01 Jul 2013 10:00:00 GMT

Julie Lerman demonstrates how behavior driven development focuses on building up logic and tests around user stories, helping to ensure that your software actually meets the required specifications.

Read article

Data Points - A New Option for Creating OData: Web API

Mon, 03 Jun 2013 10:00:00 GMT

Julie Lerman explores two ways of creating ODATA feeds—WCF Data Services and the new ASP.NET Web API—and discusses why you might choose one approach over the other.

Read article

Data Points - Why Does Entity Framework Reinsert Existing Objects into My Database?

Mon, 01 Apr 2013 10:00:00 GMT

Entity Framework sometimes reinserts existing objects into databases. In the first of a two-part series, Julie Lerman explains why this happens, and how you can avoid it.

Read article

Data Points - Playing with the EF6 Alpha

Fri, 01 Mar 2013 10:00:00 GMT

Explore new features in the first packaged alpha release of Entity Framework 6, including asynchronous processing and custom Code First conventions.

Read article

Data Points - Shrink EF Models with DDD Bounded Contexts

Wed, 02 Jan 2013 10:00:00 GMT

Applying a concept from domain-driven design—Bounded Context—can help you build a targeted model with Entity Framework.

Read article

Data Points - Pain-Free Data Access in JavaScript--Yes, JavaScript

Mon, 03 Dec 2012 10:00:00 GMT

Julie Lerman takes a look at Breeze, an open source data access API that makes working with JavaScript a whole lot easier.

Read article

Data Points - Entity Framework Designer Gets Some Love in Visual Studio 2012

Thu, 01 Nov 2012 10:00:00 GMT

The new Entity Framework Designer in Visual Studio 2012 gets a couple of big improvements and a slew of smaller ones, all adding up to an enhanced user experience.

Read article

Data Points - Moving Existing Projects to EF 5

Tue, 04 Sep 2012 10:00:00 GMT

To take advantage of enum support and other features added to Entity Framework in the Microsoft .NET Framework 4.5, you need the compatible version of EntityFramework.dll, EF 5. Julie Lerman helps to ease the migration.

Read article

Data Points - Pitfalls and Pointers for a Base Logging Class in EF Models

Wed, 01 Aug 2012 10:00:00 GMT

An unfortunate use of a base class to provide logging data for all classes in an Entity Data Model creates chaos in the database. Learn why this happens and how to avoid the problem.

Read article

Data Points - Create and Consume JSON-Formatted OData

Mon, 02 Jul 2012 10:00:00 GMT

JSON is an increasingly important format for application development. Make sure you know how to consume OData in JSON format and create WCF Data Services that return JSON.

Read article

Data Points - Data Bind OData in Web Apps with Knockout.js

Fri, 01 Jun 2012 10:00:00 GMT

Knockout.js brings many benefits to client side web apps. Julie Lerman looks at leveraging it to perform data binding with OData.

Read article

Data Points - Let Power Users Create Their Own OData Feeds

Mon, 02 Apr 2012 10:00:00 GMT

Julie Lerman takes a look at the current preview of SQL Azure Labs Codename “Data Explorer,” and puts it to use to let a customer create his own OData feed.

Read article

Data Points - Entity Framework Code First and DbContext FAQs

Thu, 01 Mar 2012 10:00:00 GMT

Lots of people have lots of questions about Code First and DbContext in Entity Framework 4.2. This month, Julie Lerman shares the answers to some of the most common ones.

Read article

Data Points - A Few of My Favorite Things... in the Entity Framework 4.2 DbContext

Wed, 01 Feb 2012 10:00:00 GMT

The Entity Framework DbContext API simplifies many of the most common coding tasks, says Julie Lerman, who shows you her three favorite DbContext features.

Read article

Data Points - Making Do with Absent Foreign Keys

Tue, 03 Jan 2012 10:00:00 GMT

The absence of foreign key properties in classes adds some challenges to working in disconnected apps. In this column, Julie Lerman explores behavior with inserts and updates when no foreign key is available and demonstrates how to make Entity Framework toe the line.

Read article

Data Points - Handling Entity Framework Validations in WCF Data Services

Wed, 30 Nov 2011 10:00:00 GMT

Windows 8 Metro Style adds yet another UI that can consume OData. Julie Lerman helps you sharpen your OData creation skills with WCF Data Services, Code First and the Entity Framework Validation API.

Read article

Data Points - What the Heck Are Document Databases?

Wed, 26 Oct 2011 10:00:00 GMT

Our resident database expert explores some of the major players in the NoSQL world and shares what she’s learned. If you’re a database developer wondering what all the fuss is about, this overview of the MongoDB, CouchDB and RavenDBdocument databases is for you.

Read article

Data Points - Second-Level Caching in the Entity Framework and AppFabric

Fri, 09 Sep 2011 10:00:00 GMT

Sometimes useful state information about an Entity Framework context is lost when the context goes out of scope, but Julie Lerman explains how a second-level cache can help retain this information for further use, such as in automatically generated database persistence commands, for example.

Read article

Data Points - Demystifying Entity Framework Strategies, Part 3: Classes, Queries and Contexts

Thu, 30 Jun 2011 10:00:00 GMT

Julie Lerman takes on code generation in her third column exploring important decisions you have to make when using the Entity Framework, while also discussing the ObjectContext vs. DbContext choice and query building options.

Read article

Wed, 01 Jun 2011 10:00:00 GMT

With the Entity Framework, modeling the data is just a first step. You'll also need to use the right tools for querying and loading your data. We'll show you the options and help you choose the right ones for your application.

Read article

Data Points - Demystifying Entity Framework Strategies: Model Creation Workflow

Mon, 02 May 2011 10:00:00 GMT

The Entity Framework now includes more ways than ever to create a conceptual model, starting first with just your code, a model created with the visual designer, or a legacy database. We help you choose which one’s right for you.

Read article

Data Points - Composing WPF DataGrid Column Templates for a Better User Experience

Fri, 01 Apr 2011 10:00:00 GMT

Julie Lerman struggled for days with some vexing user experience problems related to the WPF DataGrid, so she’s saving you the bother by explaining how she solved them.

Read article

Data Points - Server-Side Paging with the Entity Framework and ASP.NET MVC 3

Fri, 04 Mar 2011 10:00:00 GMT

You don't always need to get huge amounts of data with your database queries. See how Julie Lerman uses new features of ASP.NET MVC 3 and Entity Framework to perform efficient server-side paging when you don't need to return those big data payloads.

Read article

Data Points - Slice and Dice OData with the jQuery DataTables Plug-In

Tue, 01 Feb 2011 10:00:00 GMT

OData lets you access data over the Web through simple HTTP commands. We’ll show you how the jQuery DataTables plug-in along with the Microsoft .NET Framework and Silverlight OData client libraries let you retrieve and display this data quickly, easily and with style.

Read article

Data Points - Profiling Database Activity in the Entity Framework

Fri, 03 Dec 2010 10:00:00 GMT

It’s important to profile your database queries to see what happens in response to Entity Framework queries and other data access activities, says Julie Lerman, who gives you the details on several profiling options to improve you coding.

Read article

Data Points - Using the Entity Framework to Reduce Network Latency to SQL Azure

Tue, 02 Nov 2010 10:00:00 GMT

Your app may function as expected when you switch to using a cloud database, but profiling and tuning queries to account for the varying effects of network latency can help you boost overall performance.

Read article

Data Points - Entity Framework Preview: code first, ObjectSet and DbContext

Fri, 01 Oct 2010 10:00:00 GMT

With the code first feature in Entity Framework, there is no visual data model and no XML describing that model. You simply create the classes for your application domain and go. We’ll show you this and several other nifty new features in the latest EF CTP.

Read article

Data Points - Deny Table Access to the Entity Framework Without Causing a Mutiny

Fri, 30 Jul 2010 10:00:00 GMT

Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables—without impacting application code or alienating developers.

Read article

Data Points - Microsoft Azure Table Storage – Not Your Father’s Database

Tue, 29 Jun 2010 10:00:00 GMT

Let go of your traditional relational database thinking if you want to understand how Azure Table storage works, says Julie Lerman. Luckily for you, she’s done the hard work to grasp the new concepts and help you get up to speed.

Read article

Data Points - LINQ Projection Queries and Alternatives in WCF Services

Mon, 03 May 2010 10:00:00 GMT

LINQ's ability to project randomly shaped data into anonymous types can be a blessing and a source of frustration, says Julie Lerman. It’s great when you just need to grab a special view of your data, but it can be problematic in certain circumstances. She explains what the limitations are and how to get around them.

Read article

Data Points - Precompiling LINQ Queries

Wed, 24 Feb 2010 10:00:00 GMT

Did you know that by precompiling LINQ queries you might actually be <i>degrading</i> your app’s performance if you’re not careful? Julie Lerman explains how to ensure you’re not <i>re</i>-precompiling queries each time and losing the expected performance benefits across post-backs, short-lived service operations and other code where critical instances are going out of scope.

Read article

Write On! - Create Web Apps You Can Draw On with Silverlight 2

Tue, 29 Jul 2008 10:00:00 GMT

We build a Silverlight 2.0 application using the InkPresenter to let users annotate a pre-defined collection of images, perform handwriting recognition, and save the annotations and recognized text into a server-side database.

Read article