On nuget.org:
- 47% of the top one thousand packages support .NET Standard
- 30% of all packages support .NET Standard (about 48k out of 160k packages)
On nuget.org:
public class Page { public virtual int Id { get; set; } public virtual string Title { get; set; } public virtual DateTime? CreatedDate { get; set; } public virtual DateTime? ModifiedDate { get; set; } public virtual string Body { get; set; } public virtual string Keyword { get; set; } public virtual string Description { get; set; } public virtual string Status { get; set; } public virtual bool? CommentStatus { get; set; } public virtual int? Order { get; set; } public virtual User User { get; set; } public virtual User EditedByUser { get; set; } public virtual ICollection<Comment> Comments { get; set; } public virtual int? ParentId { get; set; } public virtual Page Parent { get; set; } public virtual ICollection<Page> Children { get; set; } }
this._pages.ToList().Where(page => page.Parent == null).ToList();
SELECT [Extent1].[Id] AS [Id], [Extent1].[Title] AS [Title], [Extent1].[CreatedDate] AS [CreatedDate], [Extent1].[ModifiedDate] AS [ModifiedDate], [Extent1].[Body] AS [Body], [Extent1].[Keyword] AS [Keyword], [Extent1].[Description] AS [Description], [Extent1].[Status] AS [Status], [Extent1].[CommentStatus] AS [CommentStatus], [Extent1].[Order] AS [Order], [Extent1].[ParentId] AS [ParentId], [Extent2].[Id] AS [Id1], [Extent2].[Title] AS [Title1], [Extent2].[CreatedDate] AS [CreatedDate1], [Extent2].[ModifiedDate] AS [ModifiedDate1], [Extent2].[Body] AS [Body1], [Extent2].[Keyword] AS [Keyword1], [Extent2].[Description] AS [Description1], [Extent2].[Status] AS [Status1], [Extent2].[CommentStatus] AS [CommentStatus1], [Extent2].[Order] AS [Order1], [Extent2].[ParentId] AS [ParentId1], [Extent2].[User_Id] AS [User_Id], [Extent2].[EditedByUser_Id] AS [EditedByUser_Id], [Extent1].[User_Id] AS [User_Id1], [Extent1].[EditedByUser_Id] AS [EditedByUser_Id1] FROM [dbo].[Pages] AS [Extent1] LEFT OUTER JOIN [dbo].[Pages] AS [Extent2] ON [Extent1].[ParentId] = [Extent2].[Id
var citiesContainPerson = context.Cities.Where(city => city.People.Any(person => person.Name == "user-1")).ToList();
SELECT [Extent1].[Id] AS [Id], [Extent1].[Name] AS [Name] FROM [dbo].[Cities] AS [Extent1] WHERE EXISTS (SELECT 1 AS [C1] FROM [dbo].[People] AS [Extent2] WHERE ([Extent1].[Id] = [Extent2].[BornInCityId]) AND (N'user-1' = [Extent2].[Name]) )
// from http://www.microsoft.com/en-us/download/details.aspx?id=14839 var connectionString = "Provider=VFPOLEDB.1;Data Source=" + @"D:\path\JVJ100.DBF" + ";Password=;Collating Sequence=MACHINE"; using (var dbConnection = new OleDbConnection(connectionString)) { using (var dataAdapter = new OleDbDataAdapter("select FAMILY from JVJ100.DBF", dbConnection)) { using (var dataset = new DataSet()) { dataAdapter.Fill(dataset, "table1"); foreach (DataRow dataRow in dataset.Tables[0].Rows) { var familyIranSystem = dataRow[0] as string; var familyIranUnicode = ConvertTo.Unicode(familyIranSystem, 1256); if (!string.IsNullOrWhiteSpace(familyIranUnicode)) { } } } } }