In any Relation database, maintaining the integrity of the database is very important and Transaction is one way of maintaining database integrity. When you have the situation, where you need to insert data into multiple tables and if inserting a data in one of the table fails you should always rollback other inserts transaction becomes
Microsoft Entity Framework version 4.0 is a brand new ORM(Object Relational Mapper) from Microsoft. It’s provides now some new features which are not there in the earlier version of Entity framework. Let’s walk through a simple example of a new features which will create a new Entity class based on stored procedure result. We will
Before some days I have posted one post about how we can add NuGet package other than start project. In this post I am going to explain another way of doing that. Earlier we have use ‘Manage NuGet Package’. Today I am going to use Package Manager Console for that. So let’s take same example
Auto Number Field handy things in Microsoft access.It willautomatically increase the filed value as records are inserted. Developer don’t have to care for it. By default auto number field start with the zero but sometimes we required to start auto number with rather than zero.We can do it by creating the append query. Followingare the
Copyright @2024 Dotnetjalps