Book Description

Previously, SQL developers have been able to almost entirely ignore the SQLCLR and treat it as a peripheral technology—almost an extension to the main product. With the advent of LINQ and the Entity Framework, this is no longer the case, and the SQLCLR is moving to the center stage. It’s a powerful product but, for many, it is an entirely new way of working with data. Pro Entity Framework 4.0 will help readers understand the implications of the Entity Framework and how it can be used to change their development practices and make their databases more powerful and flexible. Since many readers will be encountering this subject for the first time, the book will create an inclusive environment in which the concepts of .NET development are approached from the perspective of the Relational T–SQL developer to foster a sense of shared–ownership in keeping with Microsoft’s latest best practices.

• Comprehensive coverage of the new greater and more challenging integration with .NET 3.5
• Written from Read More ...

Book Description

Take advantage of the Code First data modeling approach in ADO.NET Entity Framework, and learn how to build and configure a model based on existing classes in your business domain. With this concise book, you’ll work hands-on with examples to learn how Code First can create an in-memory model and database by default, and how you can exert more control over the model through further configuration.

Code First provides an alternative to the database first and model first approaches to the Entity Data Model. Learn the benefits of defining your model with code, whether you’re working with an existing database or building one from scratch. If you work with Visual Studio and understand database management basics, this book is for you.

• Learn exactly what Code First does—and does not—enable you to do
• Understand how property attributes, relationships, and database mappings are inferred from your classes by Code First
• Use Data Annotations and the Fluent API to Read More ...

Book Description

This book provides examples using the IQuery, ICriteria, QueryOver, and LINQ to NHibernate API’s within the context of an example Guitar Store inventory program.  The reader is walked through the creation of a Microsoft SQL Server 2008 database, the creation of a Visual Studio 2010 solution consisting of 3 projects (a Window Presentation Foundation (WPF), a Console Application, and a Class Library). Each one utilizes the .NET 4.0 framework.  Then the reader is walked through the steps required to configure and use the many features available contained within NHibernate 3.2.  Further instructions and examples exist for the insertion of parent/child relationships, Session management, entity states (transient, persistent and detached), deletion, caching, and batching.The last chapter utilizes ASP.NET MVC 3 and jqGrid for the creation of an internet program for viewing the guitar inventory using NHibernate and the session per web request model.

Table of Contents
Chapter 1: Read More ...

Book Description

Ideally, we would want to persist the objects our application uses and produces AS IS, without having to first transform them in complex ways. NHibernate is a framework that provides us with an object-oriented access to a relational database without having to write SQL and with little or no database-specific data access code. Definitely, if you are a .NET developer, knowing more about NHibernate will simplify and reduce your efforts in developing .Net applications.NHibernate 3 Beginner’s Guide introduces Nhibernate with step-by-step examples, and is the easiest way to learn about bridging the gap between object-oriented .NET applications and the relational database that stores the application’s data. It is a beginner’s guide to NHibernate that starts from scratch. Successive chapters build upon earlier concepts, while the sample code presents various ways to accomplish typical data access tasks.

NHibernate 3 Beginner’s Guide examines all of the topics required to get a functional Read More ...

Book Description

Entity Framework 4 in Action is an example-rich tutorial for .NET developers with full coverage of EF 4 features. The book begins with a review of the core ideas behind the ORM model and shows through detailed examples and larger case studies how Entity Framework offers a smooth transition from a traditional ADO.NET approach.

Entity Framework builds on the ADO.NET persistence model and the language features of LINQ to create a powerful persistence mechanism that bridges the gap between relational databases and object-oriented languages.

Entity Framework 4 in Action is an example-rich tutorial that helps .NET developers learn and master the subject. It begins by explaining object/relational mapping and then shows how you can easily transition to EF from ADO.NET. Through numerous focused examples and two larger case studies, the book unfolds the EF story in a clear, easy-to-follow style. Infrastructure and inner workings of EF are discussed when you need them to understand a Read More ...

Book Description

Now in its 4th Edition, this book shows Visual Basic developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. You’ll learn how to:

• quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010
• code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications…the route the professionals take for flexibility and control
• display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView
• work with XML-specific features of ADO.NET and SQL Server to read, write, and manipulate XML data in your applications
• create local reports using Visual Studio’s Report Designer and Report Viewer to display data easily…and clearly!…in tables, matrices, lists, and charts
• Use the Entity Framework to Read More ...