Git Product home page Git Product logo

sharepointmapper's Introduction

NuGet

Shmapper - Sharepoint Mapper

Shmapper is a lightweight mapper for Sharepoint lists (2010 and 2013) for CSOM.
Maps ListItem fields to strongly typed entities and provides handy interface to work with them.
Wiki: Mapping How-to / Comparison with alternatives / CSOM Info

Main Features

  • Attribute-based mapper for POCO entities
  • All basic CRUD operations for collections and single entities
  • Supports LINQ-filters for entities

Fast and Simple

  • Loads only mapped fields
  • LINQ queries converted to CAML (by Camlex.Net)
  • ExecuteQuery() called few times as possible

Basic Usage

var SharepointClient = new SharepointClient("sharepoint-url", new NetworkCredential("user", "password"));
var CustomersByQuery = SharepointClient.Query<SpCustomer>(c => c.Title == "Cisco");

// Mapping:
[SharepointList("CustomersListName")]
public class SpCustomer : ISharepointItem
{
  [SharepointField("IdInternalName")]
  public int Id { get; set; }

  [SharepointField("TitleInternalName")]
  public string Title { get; set; }
}

All requests will be translated to CAML query.
For example, expression SharepointClient.Query(c => c.Title == "Cisco") will be translated to:

<!-- Produced CAML query -->
<View>
	<Query>
		<Where>
			<Eq>
				<FieldRef Name="TitleInternalName" />
				<Value Type="Text">Cisco</Value>
			</Eq>
		</Where>
	</Query>
	<ViewFields>
		<FieldRef Name="IdInternalName" />
		<FieldRef Name="TitleInternalName" />
	</ViewFields>
</View>

More Examples

Installation

There are 2 ways to use this library:

Road Map

  • Check exotic fields (system, non writable, etc)
  • Support more field types
  • More documentation
  • Test with Sharepoint 2016
  • Check mapping method (?)
  • Exception handling (?)

sharepointmapper's People

Contributors

fixer-m avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar

sharepointmapper's Issues

Hi PLanning to Implement Shamapper not an issue

Hi
I landed here when google for EntityFrameweork for Sharepoint. currently I developed an application and using it without any mapper.

Do u u see any issues in long run, if I implement in my project.

planning to figure out a way to implement it

Fields which have multiple values

Hi all,

this mapping working fine for me, but i have list and there are some columns in this list contain multiple values and here, i can't retrieving data from the these columns .

any advice please @fixer-m

Contains predicate is not working for LookupMulti fields

Entity class:
`

   /// <summary>
    ///  Содержание мероприятий 
    ///  
    ///  List27List
    /// </summary>
    [SharepointList("Содержание мероприятий")]
    public partial class EventContent : ISharepointItem
    {

        [SharepointField("ID")]
        public int Id { get; set; } //ID:Counter , 

        /// <summary>
        ///Title:Text , 
        /// </summary>
        [SharepointField("Title")]
        public String Title { get; set; }

     
        /// <summary>
        ///lookup Id(s) for MontBlocks:
        ///LookupMulti 
        ///Блоки с контентом данного мероприятия  
        /// </summary>
        [SharepointField("MontBlocks", MapData.LookupId)]
        public List<int> MontBlocksId { get; set; }

      
        /// <summary>
        ///MontBlocks:LookupMulti , Блоки с контентом данного мероприятия
        /// </summary>
        [SharepointField("MontBlocks", MapData.LookupValue)]
        public List<String> MontBlocks { get; set; }

    }//Содержание мероприятий

`

Mapping is ok:

    [TestMethod]
    public void TestMethod4()
    {
        List<EventContent> eventContents = _sharepointClient.GetAll<EventContent>();
        }

But where query fails
Test:

  [TestMethod]
        public void TestMethod3()
        {
            var ecc= _sharepointClient.Query<EventContent>(ec => ec.MontBlocksId.Contains(1)).FirstOrDefault();
          
        }

with:

{CamlexNET.NonSupportedOperandTypeException: Operand type 'System.Collections.Generic.List1[System.Int32]' is not supported at CamlexNET.Impl.Factories.OperandBuilder.CreateValueOperand(Type type, Object value, Boolean includeTimeValue, Boolean parseExactDateTime, Boolean isComparisionOperation, Boolean isIntegerForUserId) at CamlexNET.Impl.Factories.OperandBuilder.createValueOperand(Type type, Object value, Expression expr) at CamlexNET.Impl.Factories.OperandBuilder.createValueOperandFromConstantExpression(ConstantExpression expr, Type explicitOperandType, Expression sourceExpr) at CamlexNET.Impl.Factories.OperandBuilder.CreateValueOperandForNativeSyntax(Expression expr, Type explicitOperandType, Expression sourceExpr) at CamlexNET.Impl.Factories.OperandBuilder.CreateValueOperandForNativeSyntax(Expression expr, Type explicitOperandType) at CamlexNET.Impl.UnaryExpressionBaseAnalyzer.getValueOperand(LambdaExpression expr) at CamlexNET.Impl.Operations.Contains.ContainsAnalyzer.GetOperation(LambdaExpression expr) at CamlexNET.Impl.GenericTranslator.TranslateWhere(LambdaExpression expr) at CamlexNET.Impl.Query.Where(Expression1 expr)
at Shmapper.SharepointClient.Query[T](Expression`1 filter) in 49}

`

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.