Prime your flux capacitor: SQL Server temporal tables in EF Core 6.0
Introducing EF Core 5 Features: Using ToQueryString to get generated SQL
We are extremely excited to announce the general availability of EF Core 3.0and EF 6.3 on nuget.org .
What’s new in EF Core 3.0
Including major features, minor enhancements, and bug fixes, EF Core 3.0 contains more than 600 product improvements. Here are some of the most important ones:
Install-Package mongocsharpdriver
public class Author
{
public ObjectId Id { get; set; }
public string Name { get; set; }
} public class Language
{
public ObjectId Id { get; set; }
public string Name { get; set; }
} public class Book
{
public ObjectId Id { get; set; }
public string Title { get; set; }
public string ISBN { get; set; }
public int Price { get; set; }
public List<Author> Authors { get; set; }
public Language Language { get; set; }
} var book =new Book()
{
Title = "Gone With Wind",
ISBN = "43442424",
Price = 50000,
Language = new Language()
{
Name = "Persian"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Margaret Mitchell"
},
new Author()
{
Name = "Ali Mahboobi (Translator)"
},
}
}; var client = new MongoClient();
string connectionString = "mongodb://localhost:27017";
MongoClientSettings settings = MongoClientSettings.FromUrl(new MongoUrl(connectionString));
var client = new MongoClient(settings); var db = client.GetDatabase("publisher"); var collection = db.GetCollection<Book>("books"); collection.InsertOneAsync(book);
فعلا موجودیتهای مؤلفان و زبان به دلیل اینکه سند اختصاصی برای خود ندارند، با صفر پر شدهاند؛ ولی شناسه یکتای سند، مقدار خود را گرفته است.
عملیات خواندن
var client = new MongoClient();
var db = client.GetDatabase("publisher");
db.DropCollection("books");
var collection = db.GetCollection<Book>("books");
var book =new Book()
{
Title = "Gone With Wind",
ISBN = "43442424",
Price = 50000,
Year = 1936,
LastStock = DateTime.Now.AddDays(-13),
Language = new Language()
{
Name = "Persian"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Margaret Mitchell"
},
new Author()
{
Name = "Ali Mahboobi (Translator)"
},
}
};
var book2 = new Book()
{
Title = "Jane Eyre",
ISBN = "87897897",
Price = 60000,
Year = 1847,
LastStock = DateTime.Now.AddDays(-5),
Language = new Language()
{
Name = "English"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Charlotte Brontë"
},
}
};
var book3 = new Book()
{
Title = "White Fang",
ISBN = "43442424",
Price = 50000,
Year = 1936,
LastStock = DateTime.Now.AddDays(-13),
Language = new Language()
{
Name = "English"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Jack London"
},
new Author()
{
Name = "Philippe Mignon"
},
}
};
var book4 = new Book()
{
Title = "The Lost Symbol",
ISBN = "43442424",
Price = 3500000,
Year = 2009,
LastStock = DateTime.Now.AddDays(-17),
Language = new Language()
{
Name = "Persian"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Dan Brown"
},
new Author()
{
Name = "Mehrdad"
},
}
};
var book7 = new Book()
{
Title = "The Lost Symbol",
ISBN = "43442424",
Price = 47000000,
Year = 2009,
LastStock = DateTime.Now.AddDays(-56),
Language = new Language()
{
Name = "Persian"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Dan Brown"
},
new Author()
{
Name = "Mehrdad"
},
}
};
var book5= new Book()
{
Title = "The Help",
ISBN = "45345e3er3",
Price = 9000000,
Year = 2009,
LastStock = DateTime.Now.AddDays(-2),
Language = new Language()
{
Name = "Enlish"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Kathryn Stockett"
},
}
};
var book6 = new Book()
{
Title = "City of Glass",
ISBN = "454534545",
Price = 500000,
Year = 2009,
LastStock = DateTime.Now,
Language = new Language()
{
Name = "Persian"
},
Authors = new List<Author>()
{
new Author()
{
Name = "Cassandra Clare"
},
new Author()
{
Name = "Ali"
},
}
};
var books = new List<Book> {book, book2, book3, book4, book5, book6,book7};
collection.InsertManyAsync(books); var client = new MongoClient();
var db = client.GetDatabase("publisher");
var collection = db.GetCollection<Book>("books");
var filter=new BsonDocument();
var docs = collection.Find(filter).ToList();
foreach (var book in docs)
{
Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
} Gone With Wind By Margaret Mitchell Jane Eyre By Charlotte Brontë White Fang By Jack London The Lost Symbol By Dan Brown The Help By Kathryn Stockett City of Glass By Cassandra Clare The Lost Symbol By Dan Brown
var filter = Builders<Book>.Filter.Eq("Year", 2009);
var docs = collection.Find(filter).ToList();
foreach (var book in docs)
{
Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
} The Lost Symbol By Dan Brown The Help By Kathryn Stockett City of Glass By Cassandra Clare The Lost Symbol By Dan Brown
// var filter=new BsonDocument();
var filterBuilder = Builders<Book>.Filter;
var filter= filterBuilder.Eq("Year", 2009) | filterBuilder.Gte("Price",700000);
var docs = collection.Find(filter).ToList();
foreach (var book in docs)
{
Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
} Gone With Wind By Margaret Mitchell White Fang By Jack London The Lost Symbol By Dan Brown The Help By Kathryn Stockett City of Glass By Cassandra Clare The Lost Symbol By Dan Brown
var docs = collection.AsQueryable().Where(x => x.Year == 2009 || x.Price <= 50000).ToList();
var sort = Builders<Book>.Sort.Ascending("Title").Descending("Price");
var docs = collection.Find(filter).Sort(sort).ToList();
foreach (var book in docs)
{
Console.WriteLine(book.Title + " By "+ book.Authors[0].Name);
} City of Glass By Cassandra Clare Gone With Wind By Margaret Mitchell The Help By Kathryn Stockett The Lost Symbol By Dan Brown The Lost Symbol By Dan Brown White Fang By Jack London
SELECT * FROM Production.TransactionHistoryArchive
WHERE ReferenceOrderID < 100
SELECT ReferenceOrderLineID FROM Production.TransactionHistoryArchive
WHERE ReferenceOrderID < 100
| Family | Name | ID |
| Nasiri | Vahid | یک مقدار Guid |
| Akbari | Mohsen | یک مقدار Guid |
| Jamshidi | Mohsen | یک مقدار Guid |
private static void Query7()
{
using (var context = new StoreDbContext())
{
// Add
context.Customers.Add(new Customer { Name = "Ali", Family = "Jamshidi" });
// change
var customer1 = context.Customers.Single(c => c.Family == "Jamshidi");
customer1.Name = "Mohammad";
// Remove
var customer2 = context.Customers.Single(c => c.Family == "Akbari");
context.Customers.Remove(customer2);
var customers = context.Customers.Where(c => c.Name != "Vahid");
foreach (var cust in customers)
{
Console.WriteLine("Customer Name: {0}, Customer Family: {1}", cust.Name, cust.Family)
}
}
}private static void Query7_1()
{
using (var context = new StoreDbContext())
{
// Add
context.Customers.Add(new Customer { Name = "Ali", Family = "Jamshidi" });
// change
var customer1 = context.Customers.Single(c => c.Family == "Jamshidi");
customer1.Name = "Vahid";
// Remove
var customer2 = context.Customers.Single(c => c.Family == "Akbari");
context.Customers.Remove(customer2);
var customers = context.Customers.Where(c => c.Name != "Vahid");
foreach (var cust in customers)
{
Console.WriteLine("Customer Name: {0}, Customer Family: {1}", cust.Name, cust.Family)
}
}
}private static void Query8()
{
using (var context = new StoreDbContext())
{
// Add
context.Customers.Add(new Customer { Name = "Ali", Family = "Jamshidi" });
// change
var customer1 = context.Customers.Single(c => c.Family == "Jamshidi");
customer1.Name = "Mohammad";
// Remove
var customer2 = context.Customers.Single(c => c.Family == "Akbari");
context.Customers.Remove(customer2);
var customers = context.Customers.Local;
foreach (var cust in customers)
{
Console.WriteLine("Customer Name: {0}, Customer Family: {1}", cust.Name, cust.Family);
}
}
}private static void Query9()
{
using (var context = new StoreDbContext())
{
var customers = context.Customers.Where(c => c.Name == "Mohsen");
customers.Load();
foreach (var cust in context.Customers.Local)
{
Console.WriteLine("Customer Name: {0}, Customer Family: {1}", cust.Name, cust.Family);
}
}
// Output:
// Customer Name: Mohsen, Customer Family: Akbari
// Customer Name: Mohsen, Customer Family: Jamshidi
}System.Web.dll System.Web.ApplicationServices.dll
C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v2.0\Assemblies\WebMatrix.Data.dll C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v2.0\Assemblies\WebMatrix.WebData.dll
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="DefaultConnection"
connectionString="Data Source=.;Initial Catalog=SimpleMembershipProviderDB;Integrated Security=True;"
providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<roleManager enabled="true" defaultProvider="SimpleRoleProvider">
<providers>
<clear/>
<add name="SimpleRoleProvider" type="WebMatrix.WebData.SimpleRoleProvider, WebMatrix.WebData"/>
</providers>
</roleManager>
<membership defaultProvider="SimpleMembershipProvider">
<providers>
<clear/>
<add name="SimpleMembershipProvider" type="WebMatrix.WebData.SimpleMembershipProvider, WebMatrix.WebData"/>
</providers>
</membership>
</system.web>
</configuration>using System;
using System.Security.Principal;
using System.Web.Security;
using WebMatrix.WebData;
namespace MemberShipConsoleApplication
{
class Program
{
static void Main(string[] args)
{
WebSecurity.InitializeDatabaseConnection("DefaultConnection",
"UserProfile", "UserId", "UserName",
autoCreateTables: true);
AddUserAndRolSample();
Login();
if (System.Threading.Thread.CurrentPrincipal.Identity.IsAuthenticated)
RunApp();
}
static void AddUserAndRolSample()
{
if (WebSecurity.UserExists("iman"))
return;
// No implements in SimpleMembershipProvider :
// Membership.CreateUser("iman", "123");
WebSecurity.CreateUserAndAccount("iman", "123");
Roles.CreateRole("admin");
Roles.CreateRole("User");
Roles.AddUserToRole("iman", "admin");
}
static void Login()
{
for (int i = 0; i < 3; i++)
{
Console.Write("UserName: ");
var userName = Console.ReadLine();
Console.Write("Password: ");
var password = Console.ReadLine();
if (Membership.ValidateUser(userName, password))
{
var user = Membership.GetUser(userName);
var identity = new GenericIdentity(user.UserName);
var principal = new RolePrincipal(identity);
System.Threading.Thread.CurrentPrincipal = principal;
Console.Clear();
return;
}
Console.WriteLine("User Name Or Password Not Valid.");
}
}
static void RunApp()
{
Console.WriteLine("Welcome To MemberShip. User Name: {0}",
System.Threading.Thread.CurrentPrincipal.Identity.Name);
if (System.Threading.Thread.CurrentPrincipal.IsInRole("admin"))
Console.WriteLine("Hello Admin User!");
Console.Read();
}
}
}InitializeDatabaseConnection(string connectionStringName,
string userTableName,
string userIdColumn,
string userNameColumn,
bool autoCreateTables)