| |
browse.develop.com
Browse.develop.com is a community that was established to collect and
organize valuable web information. Our technical staff have selected and
indexed information and courses that they feel will help you stay
current on best practices across the SDLC.
|
15 Articles match "Database","LINQ"
| Related DevelopMentor Courses | MORE | | Maurice de Beijer: Querying RavenDB databases As we have seen in previous blog posts getting data from a RavenDB database is easy. Querying the database As IDocumentSession.Query () return an IQueryable we can just start composing queries just as we can with EntityFramework or another ORM. If you prefer the full LINQ syntax that is no problem as it produced exactly the same result±. If you try this you might notice one big difference from EntityFramework or in memory LINQ queries. However sometimes we want more control over what we want to load. As with any query this is easy to correct. 11: }. 11: }. 12: }. The Problem Solver - Monday, December 17, 2012 Screening C# Candidates: Let’s Play 20 Questions! For example, someone might be called upon to build a WPF app retrieving data from a WCF service that queries a SQL database using Entity Framework with Ninject for dependency injection and MOQ for unit testing. What keyword would you use to define an inline variable in a LINQ query? What keyword would you use to define an inline variable in a LINQ query? Over the past year I was involved in the process of interviewing candidates for both mid and senior level developer positions. Furthermore, I’m looking for a developer with a thirst for knowledge. > reference 2. DevelopMentor Courses - Tuesday, February 28, 2012 Entity Framework - Model First: One-to-One relationship Now you’re ready to generate your database schema. Entity Framework LINQIf you’re doing Model First with Entity Framework you may run into a scenario where you want to design a 1-to-1 relationship, but also have a foreign key be available on your entity. The default behavior in Entity Framework when doing a 1-to-1 relationship (with Model First), or 1-to-0.1 relationship, is to create a foreign key on the 0.1 side of the association but hide the foreign key. better approach is this: Start a new model. Make sure the StoreGeneratedPattern property is set to Identity. DevelopMentor Courses - Wednesday, June 29, 2011 |
35 Articles match "Database","LINQ"
| The Latest from DevelopMentor | MORE | | A Roundup of MongoDB Management Tools View your MongoDB database as a hierarchical tree consisting of databases, collections, indexes and users. Key features : Gain a quick and effective overview of your database (size, usage, doc count, etc). View your MongoDB database as a hierarchical tree consisting of databases, collections, indexes and users. Copy collections from a database to another database. really like the “overview” view for a given database to see just how much space everything is using and how your data is growing. NoSQL LINQ Open Source link]. Michael C. Kennedy's Weblog - Monday, April 22, 2013 Optimistic concurrency in MongoDB using.NET and C# 'This article demonstrates a technique and supporting library for adding optimistic concurrency control to NoSQL databases and MongoDB in particular. Ideally, all databases that allow concurrent access or disconnected access need to implement some form of concurrency control. Moreover, it is entirely inappropriate for NoSQL databases. All you do is call save and access entities via LINQ queries. Quickly, what is optimistic concurrency control? This usually comes in two flavors: Pessimistic concurrency control. Optimistic concurrency control. Edit in memory. Michael C. Kennedy's Weblog - Monday, April 8, 2013 Querying RavenDB databases As we have seen in previous blog posts getting data from a RavenDB database is easy. Querying the database As IDocumentSession.Query () return an IQueryable we can just start composing queries just as we can with EntityFramework or another ORM. If you prefer the full LINQ syntax that is no problem as it produced exactly the same result±. If you try this you might notice one big difference from EntityFramework or in memory LINQ queries. However sometimes we want more control over what we want to load. As with any query this is easy to correct. 11: }. 11: }. 12: }. The Problem Solver - Monday, December 17, 2012 | -
| The Best from DevelopMentor | MORE | - A Roundup of MongoDB Management Tools
View your MongoDB database as a hierarchical tree consisting of databases, collections, indexes and users. Key features : Gain a quick and effective overview of your database (size, usage, doc count, etc). View your MongoDB database as a hierarchical tree consisting of databases, collections, indexes and users. Copy collections from a database to another database. really like the “overview” view for a given database to see just how much space everything is using and how your data is growing. NoSQL LINQ Open Source link]. - The NoSQL Movement, LINQ, and MongoDB - Oh My!
you may cry, “for where will people put their data if not in a database? The outcry about flat files above is meant to highlight an assumption developers often have about building data-driven applications: Data goes in the database (SQL Server, Oracle, or MySql). The NoSQL movement asks the question: “Is the relational database (RDBMS) always the right tool for data storage and data access?”. However, those of us who are excited about NoSQL believe that relational databases are not always the answer. The NoSQL databases are also not always the right choice either. Michael C. Kennedy's Weblog - Thursday, April 22, 2010 - Who is Improving LINQ to SQL? Plinqo by Code Smith!
A lot of people have lingering doubts about whether to use LINQ to SQL for real-world applications, especially since Microsoft has left it to languish in favor of the new version of the Entity Framework slated for release with.NET 4.0 Nevertheless, I have a consulting client, Credit Solutions , that uses LINQ to SQL for their line-of-business web application and has had a very favorable experience working with it. In addition you’ll get better performance using LINQ to SQL (we’ll see how EF4 compares when it comes out). and Visual Studio 2010. Tony and Zuzana's World - Tuesday, August 4, 2009 - Maurice de Beijer: Querying RavenDB databases
As we have seen in previous blog posts getting data from a RavenDB database is easy. Querying the database As IDocumentSession.Query () return an IQueryable we can just start composing queries just as we can with EntityFramework or another ORM. If you prefer the full LINQ syntax that is no problem as it produced exactly the same result±. If you try this you might notice one big difference from EntityFramework or in memory LINQ queries. However sometimes we want more control over what we want to load. As with any query this is easy to correct. 11: }. 11: }. 12: }. The Problem Solver - Monday, December 17, 2012 - Windows Workflow Foundation futures and database access
One of the new features he demonstrated where the activities we can use to load data from a SQL server database into our workflow. Most of the new features are really cool but the database activities are not. Why don’t I like the new database activities With the new ExecuteSqlQuery we are back to typing in a literal SQL string to be executed on the server and the related connection string directly into a workflow. These days most.NET developers have gotten used to, and expect, the power and beauty or LINQ with the related IntelliSense and compile time checking. The Problem Solver - Saturday, November 20, 2010 - Who is Improving LINQ to SQL? Plinqo by Code Smith!
A lot of people have lingering doubts about whether to use LINQ to SQL for real-world applications, especially since Microsoft has left it to languish in favor of the new version of the Entity Framework slated for release with.NET 4.0 Nevertheless, I have a consulting client that uses LINQ to SQL for their line-of-business web application and has had a very favorable experience working with it. In addition you’ll get better performance using LINQ to SQL (we’ll see how EF4 compares when it comes out). and Visual Studio 2010. file under a common folder. Tony and Zuzana's World - Tuesday, August 4, 2009 - Entity Framework - Model First: One-to-One relationship
Now you’re ready to generate your database schema. Entity Framework LINQIf you’re doing Model First with Entity Framework you may run into a scenario where you want to design a 1-to-1 relationship, but also have a foreign key be available on your entity. The default behavior in Entity Framework when doing a 1-to-1 relationship (with Model First), or 1-to-0.1 relationship, is to create a foreign key on the 0.1 side of the association but hide the foreign key. better approach is this: Start a new model. Make sure the StoreGeneratedPattern property is set to Identity. DevelopMentor Courses - Wednesday, June 29, 2011 %>
| |   |
